X-Cart forums - Mysql Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general

X-Cart forums (https://forum.x-cart.com/index.php)

- Third Party Add-Ons for X-Cart 4 (https://forum.x-cart.com/forumdisplay.php?f=45)

Mysql Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_c

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 ? :(

Re: Mysql Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_c

You may have the table itself as utf8_unicode_ci but you also have to have all text fields in the table with the same

Re: Mysql Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_c

Quote:

Originally Posted by cflsystems

You may have the table itself as utf8_unicode_ci but you also have to have all text fields in the table with the same

Thanks Steve,
All tables & respective text fields set to utf8_general_ci & problem resolved.

Now only one x-cart table "xcart_words_en" gives similar error.
It's safe to alter this table & it's text fields to utf8_general_ci ?

Re: Mysql Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_c