Прошу помочь с решением Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='Прошу помочь с решением Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
При этом форум работал исправно, но вот вдруг позавчера перестал работать,
вот полностью лог ошибки:
Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
IP Address: 94.27.83.220 - /forum/index.php?/forum/2-%d0%bd%d0%be%d0%b2%d0%be%d1%81%d1%82%d0%b8/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.forum_id=2 AND t.pinned IN (0,1) AND t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,30
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications/forums/modules_public/forums/forums.php | [public_forums_forums_forums].renderForum | 451 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/forums.php | [public_forums_forums_forums].showForum | 147 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_forums_forums_forums].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
ps
Перевел таблицу Topics в кодировку UTF8 (не помогло)
все остальные таблицы в "Сравнении" выдают cp1251_general_ci
хотя сама бд:
InnoDB
utf8_general_ci