Hi Ruslan, > This happens when Name in the Users table contains duplicate values in > terms of case-sensetivity or incorrect UTF-8 data that gets converted > to empty string. > > You either have two users with name 'Санкт-Петербург' > spelled in > different case or this value is not UTF-8, but cp1251, koi8-r or may > be cp866. The latter may happen because of spam.
I'am not a MySQL guru. How can I find this users or how can I fix this problem? There are about 30k users. Most of them from spam mail. Can I use the option --with-charset=binary with mysqldump to export the old database? Thanks and regards Torsten -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 _______________________________________________ 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