[rt-users] Error message in upgrade from 3.6.5 to 3.8.1

[Alex Moura]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090108/727a5c83/attachment.htm>