SLM Posted February 25, 2017 Report Share Posted February 25, 2017 Revive Adserver is located on a subdomain ads.domain.de My Steps: Old Version 4.0.0 -> Folder renamed New Version uploaded and set to /adserver (wich looks at ads.domain.de) - Start Upgrade - Step 1, copy old ads.domain.de.conf.php in new /var folder - Step 2 - Database password entered- Step 3 - added Path to previous Revive Adserver installation & set data for System Administrator Account - continue -> Get Error: ---------------------------- An error occurred while accessing the database 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 v4.0.1 PHP/DB: PHP 5.6.29-0+deb8u1 / MySQL 5.5.54-0+deb8u1 Page: /www/admin/install.php Error: Duplicate entry 'xxx' for key 'rv_users_username' Query: INSERT INTO rv_users (contact_name , email_address , username , password , language , default_account_id , date_created , email_updated ) VALUES ('Administrator' , '[email protected]' , 'xxx' , '12237f9088c1417ea56846ff9596cac9' , 'de' , 41 , '2017-02-25 02:37:52' , '2017-02-25 02:37:52' ) $_POST: Array ( [_qf__install-config-form] => [action] => configuration [moreFieldsShown] => 1 [previousPath] => /home/xxx/html/adserver4 [adminName] => xxxx [adminPassword] => xxxxx [adminPassword2] => xx [adminEmail] => [email protected] [adminLanguage] => de [prefsTimezone] => Europe/Berlin [webpathAdmin] => ads.domain.de/www/admin [webpathDelivery] => ads.domain.de/www/delivery [webpathImages] => ads.domain.de/www/images [webpathDeliverySSL] => ads.domain.de/www/delivery [webpathImagesSSL] => ads.domain.de/www/images [storeWebDir] => /home/xxx/html/adserver/www/images [save] => Continue » ) $_GET: Empty -----------------------> Now Log on administration area -> Detected Revive Adserver 4.0.1 Revive Adserver is up to date Your Revive Adserver database and file structure are both using the most recent version and therefore no upgrade is required at this time. Please click Continue to proceed to the administration panel. - No banners are displayed in the admin area (preview). - Banners are displayed on managed websites - No statistics are displayed-> What can I do now? Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted February 27, 2017 Report Share Posted February 27, 2017 Hi @SLM, Well, I'm not sure how it happened, but you have a duplicate entry in the rv_users table, where it's the username column that has the duplicate. You will need to log into your database, and locate the rows with the duplicate username entries, take a careful backup of the rows (all the data!) and then delete the row or rows that you think are the incorrect duplicates. Hopefully, after that, it all works - and if you cannot log in again with that username, then you may need to remove the remaining row for that user, and put back in the other row (or one of the other rows) until you can log in again. Hope that helps! Quote Link to comment Share on other sites More sharing options...
SLM Posted February 27, 2017 Author Report Share Posted February 27, 2017 Hi @andrewatfornax There is only one entry in this table. In my opinion at the update at this point should not be asked for the access data at all. I use the previous conf.php, the script would simply continue here. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted February 28, 2017 Report Share Posted February 28, 2017 Hi @SLM, Is the wizard definitely saying that it's performing an upgrade, or is it saying that it's performing an install? Quote Link to comment Share on other sites More sharing options...
SLM Posted March 2, 2017 Author Report Share Posted March 2, 2017 @andrewatfornax The update I have run again, it was now also completely and without error message executed.Does after update not work yet again:- Banners are not displayed in the ACP- Statistics are not displayed-> All plugins are activated-> Maintenance is set up- Language can not be set Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted March 3, 2017 Report Share Posted March 3, 2017 Hi @SLM, Sounds to me like something has not gone right with the upgrade attempts previously, and you have bad data in the database. Anything in the logs when you do things that are not working in the UI? https://documentation.revive-adserver.com/pages/viewpage.action?pageId=8028358 Quote Link to comment Share on other sites More sharing options...
SLM Posted March 3, 2017 Author Report Share Posted March 3, 2017 (edited) Hello @andrewatfornax It is definitely not possible to save any settings. Therefore, no statistics are displayed and the settings can not be changed.After several tests I found the following:1. If I install version 4.0.1 fresh with a new database, all settings can be saved (language etc.).2. If I copy the data from the old database to the new database, the settings can not be saved anymore.It is therefore not due to wrongly set rights.Which table and which values are responsible for the database to save any settings? And what values are correct? Edited March 3, 2017 by SLM Quote Link to comment Share on other sites More sharing options...
SLM Posted March 5, 2017 Author Report Share Posted March 5, 2017 The problem is solved. The admin_account_id value in the application_variable table was set to a wrong value. After I have set the value back to 1, everything works again. andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.