Bugzilla – Bug 3512
"Illegal mix of collations" when running scanner
Last modified: 2011-03-16 04:19:55 UTC
Running the 8th June nightly. When I run: ./scanner.pl --progress --wipe --prefsfile /etc/slimserver.conf I get the following error: DBD::mysql::st execute failed: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' at /home/usr_local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 525. 2006-06-08 18:16:28.6596 ERROR: scanner - while running txn_commit: [DBIx::Class::ResultSetProxy::search(): Error executing 'SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( namesearch = ? )' (`SA�AN SUPA CREW'): DBD::mysql::st execute failed: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' at /home/usr_local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 525. ] Please let me know what other data you need.
David - what version of MySQL are you running? Are you using the built-in copy, or an external one? Can you run mysqldump against the DB if running external? Thanks
Created attachment 1255 [details] mysql dump I'm using an external mysql. Version: mysql Ver 14.7 Distrib 4.1.12, for mandriva-linux-gnu (i586) using readline 5.0 Dump attached.
David - what are your settings for: default-character-set & default-collation in MySQL? They should be set as such in the my.cnf file: default-character-set = utf8 default-collation = utf8_general_ci
Hi Dan I tried this but get the same error. I had already played around with making sure that the database was set up as utf 8 and it is. I had concluded that the error was reporting things the other way round - ie. the db was utf8 but something was trying to write latin1 to the db. I moved the artist name that I think is causing the problem - "Saïan Supa Crew" - and the next failure I get is for "CESÃRIA ÃVORA". So, this must be something to do with the odd characters in these strings.
David - can you attach one of those files to this bug? Thanks
Created attachment 1267 [details] Track that fails
David - that track works fine for me here. What is your LC_CTYPE environment variable set to? Thanks
It is set to en_GB
Subject: Re: "Illegal mix of collations" when running scanner Can you set it to en_GB.UTF-8, and run SlimServer under that encoding? Thanks. -D -- Off the record, on the QT, and very hush-hush.
Ping
Sorry Dan, I completely missed your previous comment. So, the ping was worthwhile. I downloaded the current nightly (11-Jul-2006 01:02) and it works just fine with no errors. I did not change the LC_CTYPE, so it seems that the error has gone away. Mysterious.
Ok.. I'm going to close then.