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

 

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

 

лог:

 

 

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

 

Помогите

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

Спасибо