Author Topic: [BUG] RoundCube Failed Login After Upgrade  (Read 4312 times)

0 Members and 1 Guest are viewing this topic.

Offline
***
[BUG] RoundCube Failed Login After Upgrade
« on: August 09, 2018, 03:17:46 AM »
Hello,

The older version of roundcube was using table alias but newer version doesnt have that table. If anyone upgraded from older version to newer version may end up failing to login into roundcube with the error below.

Code: [Select]
tail -f /usr/local/cwpsrv/var/services/roundcube/logs/errors
Quote
[09-Aug-2018 02:56:32 +0000]: <janbsfca> DB Error: [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), 'email@domain.com', 'localhost', 'en_US')) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 539 (POST /roundcube/?_task=login&_action=login)
[09-Aug-2018 02:56:32 +0000]: <janbsfca> PHP Error: Failed to create new user in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_user.php on line 684 (POST /roundcube/?_task=login&_action=login)
[09-Aug-2018 02:56:32 +0000]: <janbsfca> PHP Error: Failed to create a user record. Maybe aborted by a plugin? in /usr/local/cwpsrv/var/services/roundcube/program/include/rcmail.php on line 641 (POST /roundcube/?_task=login&_action=login)

The resolution to it is

Dropping the table 'alias' under 'roundcube --> users'