Hi,
I noticed a strange behavior of RC today. If a user logins first time with capitalized user name (ie. AYVAZ), RC normally creates a user at users table with that capitalized username. It seems ok, but if user tries to login next time with lowercase user name (ayvaz) RC gives an error like below,
[17-Nov-2011 11:05:10 +0200]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_511e08a96e8d2b4ad4bf55afa0101dede8ca2563c USING @0, @1, @2, @3] [Native code: 1062] [Native message: Duplicate entry ' ayvaz-posta.marmara.edu.tr' for key 2] in /usr/local/www/apache22/data/p/program/include/rcube_mdb2.php on line 642 (POST /p/?_task=login&_action=login)
I think RC checks if the username exists at the database, and mistakenly decides to it is a new one, then try to create new user. But it is not, and database gives a duplicate key error.
I found some bug reports (#1487681, #1486985, #1486393) but i think this is not the same issue. Or fixes for the bugs causes this behavior?
is it a bug or feature :)
Regards,
Melih
My environment,
FreeBSD 6.4 Apache 2.2 PHP 5.2.3 with Suhosin-Patch 0.9.6.2 MySql 5.0.41
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 17.11.2011 11:05, Melih Taşdizen wrote:
Hi,
I noticed a strange behavior of RC today. If a user logins first time with capitalized user name (ie. AYVAZ), RC normally creates a user at users table with that capitalized username. It seems ok, but if user tries to login next time with lowercase user name (ayvaz) RC gives an error like below,
[17-Nov-2011 11:05:10 +0200]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_511e08a96e8d2b4ad4bf55afa0101dede8ca2563c USING @0, @1, @2, @3] [Native code: 1062] [Native message: Duplicate entry 'ayvaz-posta.marmara.edu.tr http://ayvaz-posta.marmara.edu.tr' for key 2] in /usr/local/www/apache22/data/p/program/include/rcube_mdb2.php on line 642 (POST /p/?_task=login&_action=login)
What version? It should be already fixed in 0.7 (svn-trunk).