-- url of the page with the problem -- :
www.brainsugarhealth.com
-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.5.0
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- : When going into "orders" this is the error I get:
**An error has occurred.**
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 jos_hikashop_order AS b LEFT JOIN jos_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN jos_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN jos_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20
Call stack
# Function Location
1 JApplicationCms->execute() /home/zerogsol/public_html/brainsugarhealth.com/administrator/index.php:51
2 JApplicationAdministrator->doExecute() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/application/cms.php:257
3 JApplicationAdministrator->dispatch() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/application/administrator.php:152
4 JComponentHelper::renderComponent() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/application/administrator.php:98
5 JComponentHelper::executeComponent() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/component/helper.php:380
6 require_once() /home/zerogsol/public_html/brainsugarhealth.com/libraries/cms/component/helper.php:405
7 hikashopController->execute() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/hikashop.php:54
8 JControllerLegacy->execute() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/helpers/helper.php:1628
9 hikashopController->listing() /home/zerogsol/public_html/brainsugarhealth.com/libraries/legacy/controller/legacy.php:728
10 hikashopController->display() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/helpers/helper.php:1382
11 JControllerLegacy->display() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/helpers/helper.php:1648
12 OrderViewOrder->display() /home/zerogsol/public_html/brainsugarhealth.com/libraries/legacy/controller/legacy.php:690
13 OrderViewOrder->listing() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/views/order/view.html.php:26
14 JDatabaseDriver->loadObjectList() /home/zerogsol/public_html/brainsugarhealth.com/administrator/components/com_hikashop/views/order/view.html.php:167
15 JDatabaseDriverMysqli->execute() /home/zerogsol/public_html/brainsugarhealth.com/libraries/joomla/database/driver.php:1692
Hello please advise how I might remedy this issue.
When going into orders, I am receiving error message.
thanks,
Pam
