Errors after migrating to new server

[flins]

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 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 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!

[Ian vM]

MySQL 8 is not compatible.

[flins]

Ouch.

Is MySQL 8 support planned? What can I do in the meantime? Thank you!

Edited August 18, 2020 by flins