[Skip to main content](#vessel-content) # error message when going into "order" ## - **[pamZGS](/forum/user/35438-pamzgs "View pamZGS's Profile")** - [![pamZGS's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35438-pamzgs "View pamZGS's Profile") Topic Author - [ Offline](/forum/user/35438-pamzgs) Less More - Posts: 18 - Thank you received: 1 - - 10 years 7 months ago [\#234221](#234221) by [pamZGS](/forum/user/35438-pamzgs "View pamZGS's Profile") *[error message when going into "order"](/forum/3-bug-report/883339-error-message-when-going-into-order#234221 "-- 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")* was created by *[pamZGS](/forum/user/35438-pamzgs "View pamZGS's Profile")* -- url of the page with the problem -- : [ www.brainsugarhealth.com](Http://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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODMzMzktZXJyb3ItbWVzc2FnZS13aGVuLWdvaW5nLWludG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pamZGS](/forum/user/35438-pamzgs "View pamZGS's Profile")** - [![pamZGS's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35438-pamzgs "View pamZGS's Profile") Topic Author - [ Offline](/forum/user/35438-pamzgs) Less More - Posts: 18 - Thank you received: 1 - - 10 years 7 months ago [\#234224](#234224) by [pamZGS](/forum/user/35438-pamzgs "View pamZGS's Profile") Replied by *[pamZGS](/forum/user/35438-pamzgs "View pamZGS's Profile")* on topic *[error message when going into "order"](/forum/3-bug-report/883339-error-message-when-going-into-order#234224 "-- 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")* found other messages - downloading from Hikashop site has corrected the issue - thanks! ![:cheer:](/media/kunena/emoticons/10.png ":cheer:") ![:P](/media/kunena/emoticons/15.png ":P") The following user(s) said Thank You: [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODMzMzktZXJyb3ItbWVzc2FnZS13aGVuLWdvaW5nLWludG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 10 years 7 months ago [\#234252](#234252) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[error message when going into "order"](/forum/3-bug-report/883339-error-message-when-going-into-order#234252 "-- 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")* Hi, Yes, downloading the install package of HikaShop on our website via the menu My account>My subscriptions and installing it on your website will fix the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODMzMzktZXJyb3ItbWVzc2FnZS13aGVuLWdvaW5nLWludG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[AnnaM](/forum/user/37022-annam "View AnnaM's Profile")** - [![AnnaM's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37022-annam "View AnnaM's Profile") - [ Offline](/forum/user/37022-annam) Less More - Posts: 6 - Thank you received: 0 - - 10 years 7 months ago [\#234374](#234374) by [AnnaM](/forum/user/37022-annam "View AnnaM's Profile") Replied by *[AnnaM](/forum/user/37022-annam "View AnnaM's Profile")* on topic *[error message when going into "order"](/forum/3-bug-report/883339-error-message-when-going-into-order#234374 "-- 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")* I had same problem after upgrading to Joomla latest version. Thanks for heads up ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODMzMzktZXJyb3ItbWVzc2FnZS13aGVuLWdvaW5nLWludG8tb3JkZXI/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.246 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)