[RCU] can't login after upgrade — solved!

Meaulnes Legler @ roundcube roundcube at waveweb.ch
Wed Oct 24 11:05:15 CEST 2018

hello all

I just wanted to let you know about the outcome of my RC issue, I couldn't login after an update to version 1.3.7... It seemed to login, then immediately logged out and said « _/*!*\_ Login failed ». The roundcube/logs/errors reported:

[08-Oct-2018 15:37:11 +0200]: <345va73k> 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(), 'username', 'www.domain.tld', 'en_US')) in /home/.sites/106/site3/web/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (POST /roundcube/?_task=login&_action=login)

Someone told me, the culprit was this «alias» field in the MySQL database. Since I don't know how to manipulate mysql from the command line, I managed to access the database thru phpMyAdmin. I found out which database RC was using reading roundcube/config/config.inc.php:

// Format (compatible with PEAR MDB2): db_provider://user:password@host/database
$config['db_dsnw'] = 'mysql://nwa_L3w0xPCrNgqS:xxPZTNPgoBYYzn3q@localhost/nwa_YFXkGrYIiVZi';

then in phpMyAdmin, I looked for table * users * and clicked * Structure *. Then selected the * alias * field by clicking its checkbox and clicked on  Change (with the pencil). Then, in the new form, set the * Default * value from standard to *NULL*. And saved.

Now the user could log into the new version.

Best regards

`-´ 	 Meaulnes Legler
  Zurich, Switzerland
+41¦0 44 260 16 60

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.roundcube.net/pipermail/users/attachments/20181024/1604ef35/attachment.html>

More information about the users mailing list