- Posts: 13
- Thank you received: 0
Error on "Order" option in Backend
9 years 6 months ago #266260
by Bibok
Error on "Order" option in Backend was created by Bibok
-- 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.
-- 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.
9 years 6 months ago #266263
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Error on "Order" option in Backend
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,
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.
Please Log in or Create an account to join the conversation.
Time to create page: 0.164 seconds