PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=': SELECT c.name, s.uid, c.updated FROM {ctools_object_cache} c INNER JOIN {sessions} s ON c.sid = s.sid WHERE c.obj = :obj AND c.name IN (:names_0, :names_1, :names_2, :names_3, :names_4, :names_5) ORDER BY c.updated ASC; Array ( [:obj] => page_manager_page [:names_0] => contact_site [:names_1] => contact_user [:names_2] => user_view [:names_3] => node_view [:names_4] => node_edit [:names_5] => term_view ) in ctools_object_cache_test_objects() (line 135 of /home/***/public_html/***/sites/all/modules/ctools/includes/object-cache.inc).

Comments

merlinofchaos’s picture

merlinofchaos commented

I'm not sure how, but you have the collation on one table set to utf8_general_ci and another has utf8_unicode_ci -- they need to be the same or they cannot be joined together.

Drupal doesn't generally specify collations, that I know of, it's handled by the server. You'll have to change the collation manually I guess. You'll need to look up how to do that, I don't know the syntax offhand.

Anonymous’s picture

Anonymous (not verified) commented

Is there anyway i can fix with the collations

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (won't fix)

There is, but as I said in #1, you'll have to look up how to do that.

ghmercado’s picture

ghmercado commented

i get same error http://is.gd/3dtu3m has anyone found a fix?

joshicsin’s picture

joshicsin
they/them
Primary language Gujarati
Location Rajkot
commented

Here is the way you can change the collation for all the tables at once.
This is specific to phpmyadmin interface:
1) Click on your db name
2) Click on 'operations'
3) On the successive page, find the collation section and select the one you want to change to.
4) Click 'go' and you are done.

Thank you.