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

[juan]

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?

 

 

[andrewatfornax]

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).