Error message in upgrade from 3.6.5 to 3.8.1

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 root --action upgrade

rm -fr /var/run/rt38/mason_data/obj/

/usr/local/etc/rc.d/apache.sh restart

perl ./etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root > sql.queries

more sql.queries

mysql -u root -p rt3 < sql.queries

Enter password:
ERROR 1062 (23000) at line 210: Duplicate entry ‘’ for key 2

The line 210 says:

ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL
DEFAULT ‘’;

Is this an error that I can ignore and move on, or will I regret if I do so?

Thanks

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). As well, data would be corrupted as it’s
UTF8 stored in latin1 column.

You can: select different collation, rename conflicting users, convert
name to latin1. First two solutions are preffered.On Thu, Jan 8, 2009 at 9:31 PM, Alex Moura alexsm@gmail.com wrote:

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 root --action upgrade

rm -fr /var/run/rt38/mason_data/obj/

/usr/local/etc/rc.d/apache.sh restart

perl ./etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root > sql.queries

more sql.queries

mysql -u root -p rt3 < sql.queries

Enter password:
ERROR 1062 (23000) at line 210: Duplicate entry ‘’ for key 2

The line 210 says:

ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL
DEFAULT ‘’;

Is this an error that I can ignore and move on, or will I regret if I do so?

Thanks


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.