Hello,
When I click to generate keywords in module Predictive Search which purchased from thexcartstore.com the admin logs show following error:
Quote:
[19-Oct-2016 18:03:51] (shop: 20-Oct-2016 05:03:51) SQL error:
Site : XX.XX.XXX.XX
Remote IP : XX.XX.XXX.XX
Logged as : XX.XX.XXX.XX
SQL query : SELECT m.manufacturer, m.manufacturerid, pak.keywordid FROM xcart_manufacturers AS m
LEFT JOIN txs_ps_a_keywords AS pak ON pak.keyword=m.manufacturer
WHERE 1=1
Error code : 1267
Description : Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Request URI: /devgb454/admin/txs_predictive_search.php?mode=auto_generate
Backtrace:
/home/store/public_html/devgb454/include/func/func.db.php:309
/home/store/public_html/devgb454/include/func/func.db.php:209
/home/store/public_html/devgb454/include/func/func.db.php:489
/home/store/public_html/devgb454/modules/Predictive_Search/auto_generate.php:233
/home/store/public_html/devgb454/admin/txs_predictive_search.php:660
|
All tables related to this module have set as utf8_unicode_ci in mysql
I have same module installed at localhost & it's working fine
Can any one tell me how to resolve this issue ?
