Hi people,<br><br>In the last step of upgrade from RT 3.6.5 to 3.8.1 on FreeBSD-7.1-RELEASE, got this error:<br><br>ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2<br><br>Steps executed: <br><br># cd /usr/ports/www/rt38/ && make install <br>
# cd /usr/ports/www/rt38/work/rt-3.8.1/<br><div id=":2ys" class="ArwC7c ckChnd"># ./sbin/rt-setup-database --dba root --action upgrade<br># rm -fr /var/run/rt38/mason_data/obj/<br>
# /usr/local/etc/rc.d/apache.sh restart<br># perl ./etc/upgrade/<a href="http://schema.mysql-4.0-4.1.pl/" target="_blank">schema.mysql-4.0-4.1.pl</a> rt3 root > sql.queries<br># more sql.queries <br># mysql -u root -p rt3 < sql.queries<br>
Enter password:<br>ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2<br>#</div><br>The line 210 says: <br><br>ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL DEFAULT '';<br>
<br>Is this an error that I can ignore and move on, or will I regret if I do so?<br><br>Thanks<br>