Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: bullten on August 09, 2018, 03:17:46 AM

Title: [BUG] RoundCube Failed Login After Upgrade
Post by: bullten 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'

(http://i63.tinypic.com/2yjt076.jpg)