flins Posted August 18, 2020 Report Share Posted August 18, 2020 Hello, I am running Revive 5.0.2. I migrated servers from: CentOS 7 PHP 5.6 MySQL 5.7 to: CentOS 8 PHP 7.4.9 MySQL 8.0.17 domain and paths stayed the same. The ad server works fine, meaning serving ads and tracking works, but when I try to log in, I get the error: You need to enable cookies before you can use Revive Adserver or Session cookie error, please log in again But when I try to log in a second time, I am able to. Of course cookies are enabled and I have no adblockers or anything like that. Once logged in, I cannot create new banner ads. I get the error: An error occurred while accessing the databaseDue 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 v5.0.2 PHP/DB: PHP 7.4.9 / Unknown 8.0.17- Page: /www/admin/banner-edit.php Error: Query: INSERT INTO rv_banners (campaignid , contenttype , pluginversion , storagetype , filename , imageurl , htmltemplate , htmlcache , width , height , weight , target , url , alt , statustext , bannertext , description , adserver , etc... $_POST: Array ( [_qf__bannerForm] => [token] => 0e5202c00efaf4da36b55f5bcec91a30f [clientid] => 3 [campaignid] => 4 [bannerid] => [type] => web [status] => [MAX_FILE_SIZE] => 8388608 [replaceimage] => t [replacealtimage] => t etc... } $_GET: Empty And if I try to update Revive Adserver to the latest version, the update page simply refreshes endlessly, nothing else. What might be the problem, and how could I fix it? Thank you! Quote Link to comment Share on other sites More sharing options...
Ian vM Posted August 18, 2020 Report Share Posted August 18, 2020 MySQL 8 is not compatible. Quote Link to comment Share on other sites More sharing options...
flins Posted August 18, 2020 Author Report Share Posted August 18, 2020 (edited) Ouch. Is MySQL 8 support planned? What can I do in the meantime? Thank you! Edited August 18, 2020 by flins 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.