Jump to content

Error on login


Recommended Posts


When try to login, I found this 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.1.1
PHP/DB: PHP 7.0.27 / Unknown 5.5.5-10.1.30-MariaDB
Page: /www/admin/index.php
UPDATE  rv_session  SET sessiondata = 'a:3:{s:13:\"__authentic__\";b:1;s:5:\"token\";s:32:\"ac67d838e7f467aa6d835595fdf909c0\";s:4:\"user\";O:18:\"OA_Permission_User\":2:{s:5:\"aUser\";a:13:{s:7:\"user_id\";s:1:\"2\";s:12:\"contact_name\";s:16:\"[HIDDEN FOR SECURITY REASON]\";s:13:\"email_address\";s:29:\"[HIDDEN FOR SECURITY REASON]\";s:8:\"username\";s:10:\"[HIDDEN FOR SECURITY REASON]\";s:8:\"language\";s:2:\"fr\";s:18:\"default_account_id\";s:1:\"2\";s:8:\"comments\";s:0:\"\";s:6:\"active\";s:1:\"1\";s:11:\"sso_user_id\";s:0:\"\";s:12:\"date_created\";s:0:\"\";s:15:\"date_last_login\";s:19:\"2018-01-30 12:39:14\";s:13:\"email_updated\";s:0:\"\";s:8:\"is_admin\";b:0;}s:8:\"aAccount\";a:5:{s:10:\"account_id\";s:1:\"2\";s:12:\"account_type\";s:7:\"MANAGER\";s:12:\"account_name\";s:15:\"Default manager\";s:9:\"entity_id\";s:1:\"1\";s:9:\"agency_id\";s:1:\"1\";}}}' , lastused = '2018-01-30 12:39:14' , user_id = 2   WHERE (  rv_session.sessionid  = 'c2083662704c64a940a0d89bd89b192d' )  
    [oa_cookiecheck] => 41b30396db813d86013c570884fae9c3
    [username] => [HIDDEN FOR SECURITY REASON]
    [password] => [HIDDEN FOR SECURITY REASON]
    [login] => Login

We just migrate the entire revive on a new server. Any idea about this problem ?

I try :

- Empty rv_session table

- Empty cache folder

- Clear all session cookies

But nothing works.

Maybe something with MariaDB ?




Link to comment
Share on other sites

Hi @Matavai,

Yes, it could be an incompatibility with MariaDB.

Interestingly, I can't see anything above that indicates what the error actually is - just the query that is being run.

If you run the SQL manually, do you get an error? If so, what is it?

Are you able to put the original version of your database engine back in place (on your new server), to see if that solves the issue?

Link to comment
Share on other sites

  • 9 months later...

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...