metrpro Posted October 23, 2015 Report Share Posted October 23, 2015 установлен форум (forum.metrpro.ru), категории/подкатегории создаются и открываются и редактируются без проблем. но при попытке зайти в стандартную начальную тему "Добро пожаловать" или открыть любой форум/подфорум, вываливается приветствие в виде Driver error - хостинг от agava - но где посмотреть логи, я не знаю. Очень прошу помочь Quote Link to comment Share on other sites More sharing options...
metrpro Posted October 23, 2015 Author Report Share Posted October 23, 2015 Нашел лог Date: Fri, 23 Oct 2015 19:07:57 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 37.232.132.156 - /index.php?/topic/1-dobro-pojalovat/?view=getnewpost ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT t.*,xxx.* FROM forumtopics t LEFT JOIN forumcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=1 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/base/ipsRegistry.php | [app_class_forums].__construct | 1381 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Quote Link to comment Share on other sites More sharing options...
metrpro Posted October 23, 2015 Author Report Share Posted October 23, 2015 Поменял в phpmyadmin кодировку на 1251 и вдовесок теперь вываливается Date: Fri, 23 Oct 2015 19:35:57 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 37.232.132.156 - /index.php?/forum/2-forum/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT t.*,xxx.* FROM forumtopics t LEFT JOIN forumcore_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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Не знаю, как редактировать тут сообщения, но... Поменял в phpmyadmin кодировку обратно и теперь снова только Date: Fri, 23 Oct 2015 19:49:22 +0000 Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 37.232.132.156 - /index.php?/topic/1-dobro-pojalovat/?view=getnewpost ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT t.*,xxx.* FROM forumtopics t LEFT JOIN forumcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=1 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/base/ipsRegistry.php | [app_class_forums].__construct | 1381 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Quote Link to comment Share on other sites More sharing options...
Back Posted October 23, 2015 Report Share Posted October 23, 2015 А ви миня от бд пароль? Quote Link to comment Share on other sites More sharing options...
metrpro Posted October 23, 2015 Author Report Share Posted October 23, 2015 Менял ли пароль? Нет, тот же остался, что был указан мною при создании базы и при установке форума Quote Link to comment Share on other sites More sharing options...
LvsF Posted October 24, 2015 Report Share Posted October 24, 2015 Нашел лог А дальше вбиваете в поиск часть ошибки "Illegal mix of collations" и находите решение. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.