Jump to content

Помощь с компонентом теги и префексы

Featured Replies

Здравствуйте!

 

Прощу помочь с компонентом после установки если зайти в префексы выдает ошибку с базой данных :( 

 

лог:

 

 

Date: Fri, 12 Apr 2013 08:57:31 +0000


Error: 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'like'
IP Address: 109.172.47.82 - /admin/index.php?adsess=8fee0846a5c20a1bb1e0b4fa84288dbe&app=advancedtagsprefixes
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.*,count(f.id) as forums FROM topic_prefixes p LEFT JOIN forums f ON ( f.tag_predefined like concat("%",p.prefix_title,"%") ) GROUP BY prefix_id ORDER BY prefix_title asc
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/advancedtagsprefixes/modules_admin/prefixes/prefixes.php| [admin_advancedtagsprefixes_prefixes_prefixes]._showAll | 65 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [admin_advancedtagsprefixes_prefixes_prefixes].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Fri, 12 Apr 2013 08:59:13 +0000
Error: 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'like'
IP Address: 109.172.47.82 - /admin/index.php?adsess=8fee0846a5c20a1bb1e0b4fa84288dbe&app=advancedtagsprefixes
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT p.*,count(f.id) as forums FROM topic_prefixes p LEFT JOIN forums f ON ( f.tag_predefined like concat("%",p.prefix_title,"%") ) GROUP BY prefix_id ORDER BY prefix_title asc
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/other/advancedtagsprefixes/modules_admin/prefixes/prefixes.php| [admin_advancedtagsprefixes_prefixes_prefixes]._showAll | 65 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [admin_advancedtagsprefixes_prefixes_prefixes].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 
Помогите :)
Link to comment
https://ipbmafia.ru/topic/3741-pomosh-s-komponentom-tegi-i-prefeksy/
Share on other sites

Кодировка базы данных и её таблиц должна быть в utf8, сравнение в utf8_general_ci

Link to comment
https://ipbmafia.ru/topic/3741-pomosh-s-komponentom-tegi-i-prefeksy/?&do=findComment&comment=27275
Share on other sites
Guest
This topic is now closed to further replies.

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

  • No registered users viewing this page.