Jump to content

Featured Replies


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Fri, 18 Apr 2014 00:33:44 +0000
Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
IP Address: 46.21.246.196 - /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 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Fri, 18 Apr 2014 00:43:03 +0000
Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
IP Address: 46.21.244.58 - /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 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Установил чистый форум 3.4.6,и смотрю не открываются форумы.
Прошу помочь
Ошибка мускула под спойлером

Ссылка на форум в профиле.

Link to comment
https://ipbmafia.ru/topic/7869-there-appears-to-be-an-error-with-the-database/
Share on other sites

поюзать поиск не пробывали? у вас как и у всех, ошибка в кодировке БД

Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

кодировка должна быть: utf8_general_ci

переустанавливайте лучше, по уроку который есть на форуме. 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Date: Fri, 18 Apr 2014 00:33:44 +0000

Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

IP Address: 46.21.246.196 - /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 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Date: Fri, 18 Apr 2014 00:43:03 +0000

Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

IP Address: 46.21.244.58 - /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 |

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Установил чистый форум 3.4.6,и смотрю не открываются форумы.

Прошу помочь

Ошибка мускула под спойлером

Ссылка на форум в профиле.

А лучше прежде чем ставить форум.прочитайте инструкцию.Дабы не создавать таких тем.не засорять форум.вам удобнее и приятней и нам не отвлекаться от тем с реальными проблемами)
Guest
This topic is now closed to further replies.

Последние посетители 0

  • No registered users viewing this page.