Jump to content

Can't Upgrade From Openx 2.8.10 To Revive 3.2.1: Duplicate Entry...

Recommended Posts

I follow the steps in http://www.revive-adserver.com/support/upgrading/


But at the last step of the process I receive:


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

Version:    Revive Adserver v3.2.1 PHP/DB: PHP 5.4.21 / MySQL 5.1.54-community Page: /www/admin/install.php Error: Duplicate entry 'default_banner_image_url' for key 'phpads_preferences_preference_name' Query: INSERT INTO phpads_preferences (preference_name , account_type ) VALUES ('default_banner_image_url' , 'TRAFFICKER' ) $_POST: Array
[_qf__install-config-form] =>
[token] =>
[action] => configuration
[moreFieldsShown] => 1
[previousPath] => C:\sitiosweb\sitios\myweb\vhosts\ads
[adminName] => admin
[adminPassword] => 1234
[adminPassword2] => 1234
[adminEmail] => [email protected]
[adminLanguage] => es
[prefsTimezone] => Europe/Madrid
[webpathAdmin] => ads2.myweb.mio/www/admin
[webpathDelivery] => ads2.myweb.mio/www/delivery
[webpathImages] => ads2.myweb.mio/www/images
[webpathDeliverySSL] => ads2.myweb.mio/www/delivery
[webpathImagesSSL] => ads2.myweb.mio/www/images
[storeWebDir] => C:\sitiosweb\sitios\myweb\vhosts\ads2\www\images
[save] => Continue »
) $_GET: Empty


I set all permissions to the user of database. I can make a fresh install of Revive, but I want to preserve actual data of old OpenX.

I've made a hundred upgrade with the same results.

I've tried with revive 3.0.0 : same


I'have anymore ideas ....

Any help?



Link to comment
Share on other sites

  • 1 year later...

Hi @juan,

For whatever reason, you have manged to get a duplicate entry for the phpads_preferences_preference_name key in the phpads_preferences database table. 

You will need to log into the database, and review the duplicates (SELECT * FROM phpads_preferences WHERE preference_name = 'default_banner_image_url';) and decide which entry is (or entries are) the duplicate(s), and delete the duplicate row(s).

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...