MYSQL Error after updating from Essentials to Bus

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.1.1
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : Firefox 33.0.2
-- Error-message(debug-mod must be tuned on) -- : 1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30

I am getting the MYSQL error after upgrading from Essentials to Business on the ORDERS Page. The Orders page worked fine before on Essnetials. If i re-install essentials I can get the Orders page to work, but I purchased the Business version upgrade and need it for email settings and such.

Thanks

1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM leca0_hikashop_order AS b LEFT JOIN leca0_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN leca0_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN leca0_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 30

I also tested the installation another test account and got the same error message. I upgraded using the Essentials to Business update packet which I had essentials already installed.

That worked. I did see that my users table was using latin, which i changed and added the new snippet of code and all is good now.

Thanks

Hi,
I do receive a similar error in the backend when I try to access my orders. It happened after updating to 2.3.4. I changed the code as advised in this thread. The SQL table uses UTF-8, but it's still not working. This is the error message:

1253 COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name COLLATE utf8_general_ci,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM mmp_jomkas_hikashop_order AS b LEFT JOIN mmp_jomkas_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN mmp_jomkas_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN mmp_jomkas_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

Thanks
Roger

Hi,
just fixed it by reloading the original file and for some reason it works now. Very strange....