Error message when trying to access online orders

-- 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.

Hi,

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

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.