Database Error (again), OPENX Support-- anyone there? Options

[jmueller]

While attempting to add a banner to an existing campaign.

An error occurred while accessing the database

Due to a problem with the database OpenX couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in OpenX. Please report the following information to the creators of OpenX. Also try to describe the actions that led to this error as clearly as possible.

Version: OpenX v2.8.2-rc25
PHP/DB: PHP 5.2.9 / MySQL 5.1.32-community-log
Page: /banner-edit.php
Error: Duplicate entry 'fc2de946dfb0870e0ad48587dea37d4c' for key 'PRIMARY'
Query:

INSERT INTO session (sessionid , sessiondata , lastused ) VALUES ('fc2de946dfb0870e0ad48587dea37d4c' , 'a:3:{s:6:\"phpCAS\";a:3:{s:4:\"user\";s:8:\"jmueller\";s:10:\"user_email\";s:23:\"jmueller@growthtrac.com\";s:7:\"user_id\";s:4:\"8209\";}s:4:\"user\";O:18:\"OA_Permission_User\":2:{s:5:\"aUser\";a:13:{s:7:\"user_id\";s:3:\"213\";s:12:\"contact_name\";s:11:\"Jim Mueller\";s:13:\"email_address\";s:23:\"jmueller@growthtrac.com\";s:8:\"username\";s:8:\"jmueller\";s:8:\"language\";s:2:\"en\";s:18:\"default_account_id\";s:3:\"317\";s:8:\"comments\";s:0:\"\";s:6:\"active\";s:1:\"1\";s:11:\"sso_user_id\";s:4:\"8209\";s:12:\"date_created\";s:19:\"2008-10-14 09:32:10\";s:15:\"date_last_login\";s:19:\"2009-11-02 20:06:29\";s:13:\"email_updated\";s:19:\"2008-10-14 09:32:10\";s:8:\"is_admin\";b:0;}s:8:\"aAccount\";a:7:{s:10:\"account_id\";s:3:\"317\";s:12:\"account_type\";s:7:\"MANAGER\";s:12:\"account_name\";s:10:\"growthtrac\";s:12:\"m2m_password\";s:25:\"cG=d2Y4poahT*T-c8^GK6H1Co\";s:10:\"m2m_ticket\";s:30:\"xsYEY*jViRoovLZO%6Jzn-eirFveac\";s:9:\"entity_id\";s:3:\"204\";s:9:\"agency_id\";s:3:\"204\";}}s:5:\"prefs\";a:4:{s:20:\"advertiser-index.php\";a:3:{s:12:\"hideinactive\";b:0;s:9:\"listorder\";s:0:\"\";s:14:\"orderdirection\";s:0:\"\";}s:24:\"advertiser-campaigns.php\";a:1:{i:6998;a:3:{s:12:\"hideinactive\";b:0;s:9:\"listorder\";s:0:\"\";s:14:\"orderdirection\";s:0:\"\";}}s:18:\"inventory_entities\";a:1:{i:204;a:2:{s:8:\"clientid\";s:4:\"6998\";s:10:\"campaignid\";a:1:{i:6998;s:5:\"69433\";}}}s:20:\"campaign-banners.php\";a:1:{i:69433;a:3:{s:12:\"hideinactive\";b:0;s:9:\"listorder\";s:0:\"\";s:14:\"orderdirection\";s:0:\"\";}}}}' , '2009-11-03 18:26:40' )

$_POST:

Array
(
[clientid] => 6998
[campaignid] => 69433
[bannerid] =>
[type] => bannerTypeText:oxText:genericText
)

$_GET:

Array
(
[clientid] => 6998
[campaignid] => 69433
)

[Michal Czosnyka]

Hi jmueller,

Thank you for the information. I will forward the error message to our administrators for a review.

[metrosnow]

Same here. I'm new to OpenX, haven't started serving ads yet and already having problems....

Support, why are we getting this error message? I'm not able to Login at all...

[Daily Light]

Same here. I'm new to OpenX, haven't started serving ads yet and already having problems....

Support, why are we getting this error message? I'm not able to Login at all...

I'm in the same position as Metrosnow - I have received my welcome to OpenX hosted, the system recognizes me, but says I haven't signed up!? It then takes me back to the original sign-up screen!?
Thanks.

[jmueller]

Hey Michal Czosnyka

How's that "review" coming along?

[Michal Czosnyka]

Hi,

The problem refers to the database performance problems. Main database server falls behind and the PHP errors are a result of the server outage.

These problems does not affect banner delivery and inventory at all.