MySQL error message on orders landing page

  • Posts: 127
  • Thank you received: 1
8 years 8 months ago #233976

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.5.0
-- PHP version -- : 5.5.21
-- Browser(s) name and version -- : Safari 9.0.1
-- 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 r6b1a6_hikashop_order AS b LEFT JOIN r6b1a6_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN r6b1a6_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN r6b1a6_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 10

Hello,

I recently updated my client's in development website to Joomla 3.5.0. Most parts of Joomla and HikaShop are working correctly, but the error posted above is showing when I navigate to HikaShop > Orders. I can view individual orders with no errors, it just seems to be the main order page.

Mike

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 8 months ago #233986

Hi,

Download the install package of HikaShop on our website in the menu My account>My subscriptions and install it on your website and that will fix the problem.

The following user(s) said Thank You: Thierry H.

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

  • Posts: 127
  • Thank you received: 1
8 years 8 months ago #234011

Hello,

Installing the package again has seemed to fix the issue. Thanks.

Mike

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

Time to create page: 0.062 seconds
Powered by Kunena Forum