Posted 14 марта, 20159 yr comment_83102 Доброго времени суток. Установил IPB 3.4.6 и при переходе в один из форумов, выходит такая ошибка: There appears to be an error with the database. Последняя SQL ошибка (Сегодня, 09:21) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sat, 14 Mar 2015 09:21:25 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 94.143.198.138 - /forum/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 IN (1,0,-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 | '----------------------------------------------------------------------------+----------------------------------------------------------- В чем проблема, подскажите пожалуйста? 2 раза переустанавливал форум, ошибка та же. Link to comment https://ipbmafia.ru/topic/10822-oshibka-there-appears-to-be-an-error-with-the-database/ Share on other sites Больше вариантов
14 марта, 20159 yr comment_83103 Isco, Кодировку БД смените. Link to comment https://ipbmafia.ru/topic/10822-oshibka-there-appears-to-be-an-error-with-the-database/?&do=findComment&comment=83103 Share on other sites Больше вариантов
14 марта, 20159 yr Author comment_83104 Isco, Кодировку БД смените. На cp1251_general_ci? Link to comment https://ipbmafia.ru/topic/10822-oshibka-there-appears-to-be-an-error-with-the-database/?&do=findComment&comment=83104 Share on other sites Больше вариантов
14 марта, 20159 yr comment_83106 нет, utf8_general_ci Link to comment https://ipbmafia.ru/topic/10822-oshibka-there-appears-to-be-an-error-with-the-database/?&do=findComment&comment=83106 Share on other sites Больше вариантов
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.