Jump to content

IPB 3.4.5 Driver Error при открытии темы


Recommended Posts

установлен форум (forum.metrpro.ru), категории/подкатегории создаются и открываются и редактируются без проблем.

но при попытке зайти в стандартную начальную тему "Добро пожаловать" или открыть любой форум/подфорум, вываливается приветствие в виде Driver error - хостинг от agava - но где посмотреть логи, я не знаю.

Очень прошу помочь

 

Безимени-2.jpg

Link to comment
Share on other sites

Нашел лог

 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              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Link to comment
Share on other sites

Поменял в 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              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
Link to comment
Share on other sites

Менял ли пароль? Нет, тот же остался, что был указан мною при создании базы и при установке форума

Link to comment
Share on other sites

Нашел лог

А дальше вбиваете в поиск часть ошибки "Illegal mix of collations" и находите решение.

Link to comment
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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Ваша ссылка была автоматически строена.   Отображать как обычную ссылку

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...