Order Issue

-- HikaShop version -- : 2.3.2
-- Error-message(debug-mod must be tuned on) -- : 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM qus18_hikashop_order AS b LEFT JOIN qus18_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN qus18_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN qus18_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

Hey,
Think i've had this error message before tried a search couldn't find the answer and can't remember the solutions please help.

Hello,
Firstly can you download the last Hikashop version through our website, install it, and test it again ?
Thanks.

have done...

You have the latest stable version of HikaShop Business: 2.3.5

1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM qus18_hikashop_order AS b LEFT JOIN qus18_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN qus18_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN qus18_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

Hi,

This error message is present because your tables don't have the same collation.
Via your phpMyAdmin interface, if you list the tables of your database, you will see that they have a different collation.
So you need to execute a MySQL query to change the collation of the desired tables. The collation you should have is " utf8_general_ci".

Hey,

I looked at this and it is already set to this? - don't suppose it could be set anywhere else or something do you?

Hi,

Please check the tables of your database: take.ms/zanGb

Ahaa...

I have changed those in the collation... it hasn't solved the issue

Thank you,

I had changed it in the operations and not the individual tables.

nicolas wrote: Hi,

The jos_users table has a collation utf8_unicode_ci instead of utf8_general_ci in your database. Please make sure that it uses the same collation as the HikaShop tables and you won't get that error.