I'm getting the "ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2" error when updating the database from 3.4.5 to 3.8.2. I see from this message: http://www.mail-archive.com/rt-users@lists.bestpractical.com/msg17534.html
that I have a few different choices as to how to solve this. However, I'm not a mysql expert, so I'm afraid I'll need a little more help. I've tried changing the Users table's collation to utf8_unicode_ci, however I still get the same error when updating the database. What collation should I use to prevent this error? The original collation is latin1_swedish_ci. I've also tried to find the affected rows so that I can rename the users. However, I'm not getting anywhere. The error says that the duplicate entry is '', however "select * from Users where Name='';" returns zero rows. I've also tried dumping the Name column into a text file and using the uniq unix command, but it finds no duplicates. What is the best way to find duplicate entries? -- Jim Faulkner / james.faulk...@cs.yale.edu Systems Administrator, Linux Systems Design & Support (LSDS) Yale University Information Technology Services (ITS) =============================================================== NOTE: Yale ITS will NEVER request passwords or other personal information via email. Messages requesting such information are fraudulent and should be deleted. _______________________________________________ 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