| Arnold_Jackson | Опубликовано 17 июля, 2016 Поделиться Опубликовано 17 июля, 2016 Что делать? ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sun, 17 Jul 2016 20:36:57 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 85.140.78.69 - /index.php?/forum/2-forum/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 | 457 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | 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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sun, 17 Jul 2016 20:39:03 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 85.140.78.69 - /index.php?/forum/2-forum/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 | 457 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | 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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Цитата Ссылка на комментарий Поделиться на другие сайты Поделиться
IAF Опубликовано 18 июля, 2016 Поделиться Опубликовано 18 июля, 2016 7 часов назад, | Arnold_Jackson | сказал: Что делать? ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sun, 17 Jul 2016 20:36:57 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 85.140.78.69 - /index.php?/forum/2-forum/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 | 457 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | 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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sun, 17 Jul 2016 20:39:03 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 85.140.78.69 - /index.php?/forum/2-forum/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 | 457 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | 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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Воспользоваться поиском, решение тут уже точно раз 100 описывалось. Но если вы всё-же не сможете найти поиском, тогда хоть тему в правильном разделе создайте... Цитата Ссылка на комментарий Поделиться на другие сайты Поделиться
Рекомендуемые сообщения
Присоединяйтесь к обсуждению
Вы можете написать сейчас и зарегистрироваться позже. Если у вас есть аккаунт, авторизуйтесь, чтобы опубликовать от имени своего аккаунта.
Примечание: Ваш пост будет проверен модератором, прежде чем станет видимым.