Duplicate entry error when changing Username to an existing one

[nothingman]

This happens when I try to upgrade/change my username to an existing one when I click Accounts. I believe 1.0 didn't have this duplicate entry error.

Following is the error that is displayed above the header when you change your username to say, Nick on the demo site.

Warning: Duplicate entry 'nick' for key 2 in /home/hotarorg/public_html/demo/libs/extensions/ezSQL/mysql/ez_sql_mysql.php on line 220

Warning: Cannot modify header information - headers already sent by (output started at /home/hotarorg/public_html/demo/libs/extensions/ezSQL/mysql/ez_sql_mysql.php:220) in /home/hotarorg/public_html/demo/libs/UserAuth.php on line 202

Warning: Cannot modify header information - headers already sent by (output started at /home/hotarorg/public_html/demo/libs/extensions/ezSQL/mysql/ez_sql_mysql.php:220) in /home/hotarorg/public_html/demo/libs/UserAuth.php on line 203

Warning: Cannot modify header information - headers already sent by (output started at /home/hotarorg/public_html/demo/libs/extensions/ezSQL/mysql/ez_sql_mysql.php:220) in /home/hotarorg/public_html/demo/libs/UserAuth.php on line 202

Warning: Cannot modify header information - headers already sent by (output started at /home/hotarorg/public_html/demo/libs/extensions/ezSQL/mysql/ez_sql_mysql.php:220) in /home/hotarorg/public_html/demo/libs/UserAuth.php on line 203
This is version 1.0.2, but changes and additions for the next version are being tested on it.

[Nick]

Thanks. I've managed to fix it on the SVN development branch (#957) so expect it in Hotaru 1.0.3.