SQL Error when trying to go to orders-page

  • Posts: 1
  • Thank you received: 0
10 years 9 months ago #176723

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.25
-- Browser(s) name and version -- : Google Chrome 38.0.2125.104 m
-- Error-message(debug-mod must be tuned on) -- : Error
COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' SQL=EXPLAIN EXTENDED 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 m8syu_hikashop_order AS b LEFT JOIN m8syu_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN m8syu_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN m8syu_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

Get that sql error when trying to enter orders-page either in admin side->components->Hikashop->Orders or in Hikashop and via the Orders-menu->Orders.

So mainly, the problem is that I can't get to Orders-page at all.

This happened after I updated my starter-version to the business version.

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
10 years 9 months ago #176732

Hi,

The problem seems to be that you created your MySQL table with a "latin1" collation instead of "'utf8_general_ci" or vice versa.
stackoverflow.com/questions/5906585/change-database-collation

Please backup before anything.

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum