Greetings,
Any hints regarding what to do next when the upgrading scripts spit this
error?
ERROR 1062 (23000) at line 210: Duplicate entry ‘’ for key 2
Commands executed:
[admin@localhost ~/rt-3.8.1]# perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 >
sql.queries
[admin@localhost ~/rt-3.8.1]# mysql rt3 < sql.queries
Thanks in advance,
Alex
Alex Moura wrote:
Greetings,
Any hints regarding what to do next when the upgrading scripts spit this
error?
ERROR 1062 (23000) at line 210: Duplicate entry ‘’ for key 2
Commands executed:
[admin@localhost ~/rt-3.8.1]# perl etc/upgrade/schema.mysql-4.0-4.1.pl
http://schema.mysql-4.0-4.1.pl rt3 > sql.queries
[admin@localhost ~/rt-3.8.1]# mysql rt3 < sql.queries
What is line 210 in your sql.queries?
Regards
Racke
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
What is line 210 in your sql.queries?
It’s this:
210 ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL
DEFAULT ‘’;
Thanks