Illegal Mix of Collations Errors

Posted by miasmo on November 2, 2009 at 4:15am

I have received the following error message after attempting to use the Date Wizard from the Date Tools under Content Management:

user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT s.uid, v.updated FROM views_object_cache v INNER JOIN sessions s ON v.sid = s.sid WHERE s.sid != '0b91a44ccefbf87822891e515eeb4fd6' and v.name = 'calendar_date' and v.obj = 'view' ORDER BY v.updated ASC in /home/mydomain/public_html/mysubdomain/sites/all/modules/views/views_ui.module on line 235.

I am working on a new drupal 6.14 installation that I installed onto a subdomain using fantastico. I have installed the following modules:
advanced_help
calendar
cck
date
fckeditor
views

Also, I ran the php file recommendend in http://drupal.org/node/571470 for "Illegal Mix of Collations Errors." I had hoped that would solve the problem, but I am still getting a similar error message. Any help or suggestions would be appreciated.

Comments

still getting same error

Posted by miasmo on November 2, 2009 at 2:56pm

Since I couldn't figure out a solution, I decided to keep plowing through and trying to set up my site. I repeatedly keep getting the same error message referring to line 235 of /home/mydomain/public_html/mysubdomain/sites/all/modules/views/views_ui.module

I can't tell that it is actually screwing up my site in any discernible way. Is this going to cause me problems down the road if I don't address it now?

Does anyone have any clues as to how to solve this?

I think I fixed it.

Posted by miasmo on November 2, 2009 at 3:57pm

I ran that php file from http://drupal.org/node/571470 one more time, and I don't seem to be getting that error anymore. I thought I ran it after initial install, after uploading all the modules, and after activating the modules. I guess it's possible I missed one. It was late and I was tired.

Anyway, I hope my experience helps anyone who has a similar problem. If it happens again, I will run that file yet again.

BTW, it took me a chat with my hosting support guy to figure out that the database password for the php file was not what I thought it was. Fantastico randomly generated a password for the database which could be found in /sites/default/settings.php on line 92.

Still getting error

Posted by miasmo on November 2, 2009 at 4:13pm

Okay, I got the same error again when I tried to edit the Calendar view. Still hoping for some help here.

The Fix

Posted by RichardLynch on May 25, 2010 at 4:48pm

The fix at 571470 should work, if you have permissions to do it...

Change the line to:
mysql_query("ALTER TABLE $value COLLATE utf8_general_ci") or die(mysql_error());

It may tell you why it's not working.