Error Orders

  • Posts: 7
  • Thank you received: 0
8 years 2 months ago #249426

I am getting this error under orders (admin section):

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

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 2 months ago #249428

Hi,

1/ Please perform some search before creating a new thread.
www.hikashop.com/forum/install-update/87...sentials-to-bus.html
www.hikashop.com/forum/3-bug-report/8729...t-string.html#181639

2/ You should provide the informations about your HikaShop version number and your Joomla version number.

3/ You should really update your HikaShop 2.3.4 which has been release 2 years ago.

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.052 seconds
Powered by Kunena Forum