Can view orders after update

-- url of the page with the problem -- : blynd.com
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.5.0
-- PHP version -- : 5.4.45
-- 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 #__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

Hello,

My client performed the Joomla! update to 3.5 this morning. Before that, she was able to view the orders. After the update she now gets the error mentioned above when clicking on Orders in the backend. This is a Joomla error notice not a php debug notice. There was a HikaShop update available so I did that to see if it would correct the issue, but it didn't. The store front-end seems to be working at this time. What is causing this?

Dan

Excellent. That seems to have worked. Thank you!