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