Hi people,
In the last step of upgrade from RT 3.6.5 to 3.8.1 on FreeBSD-7.1-RELEASE,
got this error:
ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2
Steps executed:
# cd /usr/ports/www/rt38/ make install
# cd /usr/ports/www/rt38/work/rt-3.8.1/
# ./sbin/rt-setup-database --dba
You have users with names slightly different. Default mysql collation
assume that some characters with umlauts are equal to characters
without. If the current character set is latin1 then after upgrade
people with name field containing anything outside ascii wouldn't be
able to login (using name).