Illegal Mix of Collations Errors
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.
still getting same error
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.
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
Okay, I got the same error again when I tried to edit the Calendar view. Still hoping for some help here.