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
_______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
