Error message when trying to access online orders

  • Posts: 35
  • Thank you received: 0
10 years 3 months ago #187668

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5 - i think
-- 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 ut1po_hikashop_order AS b LEFT JOIN ut1po_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN ut1po_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN ut1po_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20

Wanted to look at the back end of the orders got the above error message. Also having problems with confirmation emails confirming to me of order created/ confirmed etc.

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

  • Posts: 26232
  • Thank you received: 4035
  • MODERATOR
10 years 3 months ago #187669

Hi,

In the file "administrator/components/com_hikashop/views/order/view.html.php" please replace the line

$database->setQuery('SELECT a.*,b.*,c.*,IFNULL(c.name,CONCAT_WS(\' \',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name '.$query,(int)$pageInfo->limit->start,(int)$pageInfo->limit->value);
By
$database->setQuery('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 '.$query,(int)$pageInfo->limit->start,(int)$pageInfo->limit->value);

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.
The following user(s) said Thank You: nathan-walsh

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

  • Posts: 35
  • Thank you received: 0
10 years 3 months ago #187688

Thanks!!

Could you shed any light on my other topic? Not sending confirmation emails etc a few of the sites we host are doing the same now.

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

Time to create page: 0.056 seconds
Powered by Kunena Forum
loading