Error upgrading to RT 3.8.1

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