Daniel Posted April 13, 2016 Report Share Posted April 13, 2016 Hello, As per title above, i've tried to upgrade with 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 v3.2.4 PHP/DB: PHP 5.5.30 / MySQL 5.5.46-cll Page: /www/admin/install.php Error: Table 'adservin_revive324.ox_account_user_assoc' doesn't exist Query: SELECT * FROM ox_account_user_assoc WHERE ( account_id = '0' ) AND ( ox_account_user_assoc.user_id = 0 ) $_POST: Empty $_GET: Array ( [action] => database ) I have no idea why my existing DB haven't got any table called " ox_account_user_assoc ". I've double checked the table and it's definitely not exist. However, i've ran this script for many years without errors. Do you guys have any idea what is the issue here? Many thanks for help. Quote Link to comment Share on other sites More sharing options...
Petr Posted March 16, 2017 Report Share Posted March 16, 2017 It seems there is a regresion regarding openx/phpopenads upgrades in revive-adserver-3.2.2. I have the same issue upgrading Openads-2.0.11-pr1 to revive-adserver-4.0.1 (except for the prefix of the table not found being different - phpads). I was able to workaround the issue by upgrading to Openads-2.0.11-pr1 to revive-adserver-3.2.2 and then revive-adserver-3.2.2 to revive-adserver-4.0.1. Quote Link to comment Share on other sites More sharing options...
Petr Posted March 16, 2017 Report Share Posted March 16, 2017 Actually the workaround is obviously to use revive-adserver-3.2.1 as revive-adserver-3.2.2 has already the issue. Quote Link to comment Share on other sites More sharing options...
Petr Posted March 16, 2017 Report Share Posted March 16, 2017 Issued a bug report at https://github.com/revive-adserver/revive-adserver/issues/819 Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted March 18, 2017 Report Share Posted March 18, 2017 Thanks @Petr. 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.