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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com