On 2018-10-08 18:15, Reindl Harald wrote:
Am 08.10.18 um 17:14 schrieb Vincent Van Houtte:
These errors clearly say that the user 'arcgraph' does not exist, that RC wants to create the user by logging in (I don't believe this is default - an unknown user should just be rejected imho), and that the subsequent attempt to create that user fails.
There is also the mention of a plugin that may interfere here. Can you disable all plugins for the sake of testing?
bullshit
Field 'alias' doesn't have a default value (SQL Query: INSERT INTO
users(created,last_login,username,mail_host,language) VALUES (now(), now(), 'arcgraph', 'www.arcgraphics.ch', 'en_US')the table has a column 'alias' with no default value which is not listed in the insert - mysql basics
Although your assessment is correct, it misses the overall picture. The question relates to an existing installation that was merely updated. There is no reason why RC would need to create (INSERT INTO 'users') a new user upon login.
Even if my suggestion would be wrong, I don't see any reason to use such language, especially from someone dissing the lack of respect of other people.
Kind regards, Vincent
On 10/08/2018 06:36 PM, Vincent Van Houtte wrote:
Although your assessment is correct, it misses the overall picture. The question relates to an existing installation that was merely updated. There is no reason why RC would need to create (INSERT INTO 'users') a new user upon login.
You know nothing, John Snow ;)
@Meaulnes, the upgrade script did not fix the database structure for some reason. You have
to do this manually. Visit
https://github.com/roundcube/roundcubemail/tree/master/SQL/mysql. The files there are
named by date. You have to check all files starting from 2012080700 in order from most
recent to the oldest, until you see that the changes in the file are already in place.
Another option is to compare result of show columns from table command on every table
with table definitions from SQL/mysql.initial.sql file.
Your issue is quite rare, don't expect automated solution. Minimal knowledge about database administration is required in this case.
thanks all for your help! but I still didn't manage to fix this issue.
Your issue is quite rare, don't expect automated solution. Minimal knowledge about database administration is required in this case.
that's why I'm contacting a database specialist, I'm unfortunately not very familiar with mySQL, phpMyAdmin and such...
I'll let you guys know the outcome.
Best regards
_~_ '¿') `-´ Meaulnes Legler Zurich, Switzerland +41\0 44 260 16 60
On 08.10.18 19:40, A.L.E.C wrote:
On 10/08/2018 06:36 PM, Vincent Van Houtte wrote:
Although your assessment is correct, it misses the overall picture. The question relates to an existing installation that was merely updated. There is no reason why RC would need to create (INSERT INTO 'users') a new user upon login.
You know nothing, John Snow ;) @Meaulnes, the upgrade script did not fix the database structure for some reason. You have to do this manually. Visit https://github.com/roundcube/roundcubemail/tree/master/SQL/mysql. The files there are named by date. You have to check all files starting from 2012080700 in order from most recent to the oldest, until you see that the changes in the file are already in place. Another option is to compare result of
show columns from tablecommand on every table with table definitions from SQL/mysql.initial.sql file. Your issue is quite rare, don't expect automated solution. Minimal knowledge about database administration is required in this case.
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
-
A.L.E.C -
Meaulnes Legler ＠ roundcube -
Vincent Van Houtte