I've checked the logs for this error message and I can find similar examples of the issue but it's not really helping me! Here's the message I'm getting

user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT s.uid, c.updated FROM ctools_object_cache c INNER JOIN sessions s ON c.sid = s.sid WHERE s.sid != '6f388fcc8b6cb0b693ab4d8160195d00' AND c.obj = 'page_manager_page' AND c.name = 'user_view' ORDER BY c.updated ASC in /home/render/public_html/modules/ctools/includes/object-cache.inc on line 92.

I can follow directions just fine, but I'm not completely caught up to speed on all of the lingo! So if anyone happens to have a step by step instruction, I would really appreciate it!

Thank you so much for helping me!

Comments

Renderministry’s picture

Renderministry commented
Priority: Normal » Critical
merlinofchaos’s picture

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

This means that the collations for tables in your database have been mismatched. This isn't somethign Drupal does, it just creates using the default collations. Something you did or someone did for you has put the wrong collations on one of your tables.

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented
Assigned: Renderministry » Unassigned
Priority: Critical » Normal

First, a quick queue lesson: Support requests are never critical, don't assign things to yourself unless you are planning on fixing them, and make sure you read the message you get when filing an issue. In this case, mine says to make sure it's actually an APK issue.

If you look at the error you're getting, it says CTools, which normally would mean a CTools problem. In this case, though, the problem is the collations in your database are messed up and you have them mis-matched. This isn't something that either APK or CTools can do anything about. You need to go into your database and make sure they're all matching.

Michelle