Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

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

 
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4
 
Thread Tools
  #1  
Old 10-19-2016, 05:40 AM
 
anandat anandat is offline
 

X-Adept
  
Join Date: Jan 2004
Posts: 914
 

Exclamation 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 ?
__________________
X-Cart: 4.7.7 LIVE
Skin:Ultra by xcartmods.co.uk
X-cart Modules: | ACR, Rich Google Search, Customer Testimonials | Cloud Search, | Websitecm: CDSEO (2.1.9)
---------------
Server: Linux
php: 5.3
mysql: 5.0.89
----------------
Reply With Quote
  #2  
Old 10-19-2016, 12:51 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

Default 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
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote

The following user thanks cflsystems for this useful post:
anandat (10-23-2016)
  #3  
Old 10-23-2016, 10:49 PM
 
anandat anandat is offline
 

X-Adept
  
Join Date: Jan 2004
Posts: 914
 

Default 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 ?
__________________
X-Cart: 4.7.7 LIVE
Skin:Ultra by xcartmods.co.uk
X-cart Modules: | ACR, Rich Google Search, Customer Testimonials | Cloud Search, | Websitecm: CDSEO (2.1.9)
---------------
Server: Linux
php: 5.3
mysql: 5.0.89
----------------
Reply With Quote
  #4  
Old 10-24-2016, 07:31 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

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

Yes
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 01:38 AM.

   

 
X-Cart forums © 2001-2020