Error on "Order" option in Backend

  • Posts: 13
  • Thank you received: 0
7 years 7 months ago #266260

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.6.1
-- PHP version -- : 5.4
-- Browser(s) name and version -- : OPERA 43
-- Error-message(debug-mod must be tuned on) -- : COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' 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 #__hikashop_order AS b LEFT JOIN #__hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN #__hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN #__users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

Good morning,

I have recently updated my Joomla version to 3.6.1 and Hikashop has shown the following error when I click in the "buy" option.



What can I do? My clients don't recieve any bill since then. Also they can pay with PayPal.

Thank you.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 7 months ago #266263

Hi,

1 - You're using a very old version of HikaShop

2 - You can perform a little search in that forum in order to find threads with the exact same problem.
www.hikashop.com/forum/orders-management...r-orders.html#249426

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.047 seconds
Powered by Kunena Forum