Posted 7 августа, 20168 yr comment_111148 Привет всем, у меня такая проблема на ipb 3.4 ( Мучаюсь давно, не могу исправить и решил написать вам, ребят....Вообщем, при заходе в тему на форуме вылезает ошибка " There appears to be an error with the database. "Помогите исправить, уже и переустанавливал, даже ничего не менял как установил чистую ipb сразу пошел в "Форум" , все ровно ошибкаВот форум : define-project.ru, выручайте :с SQL LOG ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sun, 07 Aug 2016 13:20:47 +0000 Error: 1146 - Table 'definepr_df.core_applications' doesn't exist IP Address: 195.46.101.57 - / ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT app_directory, app_public_title, app_enabled FROM core_applications .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/base/ipsRegistry.php | [IPSLib].buildFurlTemplates | 1474 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sun, 07 Aug 2016 13:31:18 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 195.46.101.57 - /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, 07 Aug 2016 13:48:45 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 195.46.101.57 - /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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
7 августа, 20168 yr comment_111150 нахрена орать то? у вас кодировка БД не верная, должна быть: utf8_general_ci ПОИСК ВСЕГДА РУЛИТ!!!!!!!!!!!!!!
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.