[Skip to main content](#vessel-content) # DB Collation issue even ## - **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")** - [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author - [ Offline](/forum/user/30010-grayt7) Less More - Posts: 376 - Thank you received: 7 - - - [](http://www.identitywebdesign.com) - 11 years 4 months ago [\#206003](#206003) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile") *[DB Collation issue even](/forum/35-orders-management/877741-db-collation-issue-even#206003 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- 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 f8weg_hikashop_order AS b LEFT JOIN f8weg_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN f8weg_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN f8weg_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Hi, Not sure about this one. I have checked the DB and all the table collations are the same? I have even used this script to force all the same: www.siteground.com/kb/how_to_change_the_...ables_in_db_to_utf8/ I still get the error? Help please :)")* was created by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")* -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- 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 f8weg_hikashop_order AS b LEFT JOIN f8weg_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN f8weg_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN f8weg_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Hi, Not sure about this one. I have checked the DB and all the table collations are the same? I have even used this script to force all the same: [ www.siteground.com/kb/how\_to\_change\_the\_...ables\_in\_db\_to\_utf8/](https://www.siteground.com/kb/how_to_change_the_collation_for_all_tables_in_db_to_utf8/) I still get the error? Help please ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Nzc0MS1kYi1jb2xsYXRpb24taXNzdWUtZXZlbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 11 years 4 months ago [\#206004](#206004) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[DB Collation issue even](/forum/35-orders-management/877741-db-collation-issue-even#206004 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- 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 f8weg_hikashop_order AS b LEFT JOIN f8weg_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN f8weg_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN f8weg_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Hi, Not sure about this one. I have checked the DB and all the table collations are the same? I have even used this script to force all the same: www.siteground.com/kb/how_to_change_the_...ables_in_db_to_utf8/ I still get the error? Help please :)")* Hi, Normally, the users table of Joomla should have the same collation as HikaShop tables and that is utf8_general_ci You'll get that error if that's not the case. Run this query in your PHPMyAdmin and that should solve the issue: ALTER TABLE f8weg_users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; The following user(s) said Thank You: [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Nzc0MS1kYi1jb2xsYXRpb24taXNzdWUtZXZlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")** - [![grayt7's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar30010.jpg)](/forum/user/30010-grayt7 "View grayt7's Profile") Topic Author - [ Offline](/forum/user/30010-grayt7) Less More - Posts: 376 - Thank you received: 7 - - - [](http://www.identitywebdesign.com) - 11 years 4 months ago [\#206147](#206147) by [grayt7](/forum/user/30010-grayt7 "View grayt7's Profile") Replied by *[grayt7](/forum/user/30010-grayt7 "View grayt7's Profile")* on topic *[DB Collation issue even](/forum/35-orders-management/877741-db-collation-issue-even#206147 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- 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 f8weg_hikashop_order AS b LEFT JOIN f8weg_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN f8weg_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN f8weg_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Hi, Not sure about this one. I have checked the DB and all the table collations are the same? I have even used this script to force all the same: www.siteground.com/kb/how_to_change_the_...ables_in_db_to_utf8/ I still get the error? Help please :)")* Great, sorted thanks. Strange thoug as I changed the collation in the Operations tab of the table settings. Anyway, thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Nzc0MS1kYi1jb2xsYXRpb24taXNzdWUtZXZlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lenfanta](/forum/user/38350-lenfanta "View lenfanta's Profile")** - [![lenfanta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar38350.jpg)](/forum/user/38350-lenfanta "View lenfanta's Profile") - [ Offline](/forum/user/38350-lenfanta) Less More - Posts: 32 - Thank you received: 0 - 10 years 7 months ago [\#233991](#233991) by [lenfanta](/forum/user/38350-lenfanta "View lenfanta's Profile") Replied by *[lenfanta](/forum/user/38350-lenfanta "View lenfanta's Profile")* on topic *[DB Collation issue even](/forum/35-orders-management/877741-db-collation-issue-even#233991 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- 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 f8weg_hikashop_order AS b LEFT JOIN f8weg_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN f8weg_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN f8weg_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Hi, Not sure about this one. I have checked the DB and all the table collations are the same? I have even used this script to force all the same: www.siteground.com/kb/how_to_change_the_...ables_in_db_to_utf8/ I still get the error? Help please :)")* I have the same problem I get is an error message I am unable to access the page order component : Une erreur s'est produite 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Nzc0MS1kYi1jb2xsYXRpb24taXNzdWUtZXZlbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[lenfanta](/forum/user/38350-lenfanta "View lenfanta's Profile")** - [![lenfanta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar38350.jpg)](/forum/user/38350-lenfanta "View lenfanta's Profile") - [ Offline](/forum/user/38350-lenfanta) Less More - Posts: 32 - Thank you received: 0 - 10 years 7 months ago [\#233994](#233994) by [lenfanta](/forum/user/38350-lenfanta "View lenfanta's Profile") Replied by *[lenfanta](/forum/user/38350-lenfanta "View lenfanta's Profile")* on topic *[DB Collation issue even](/forum/35-orders-management/877741-db-collation-issue-even#233994 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- 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 f8weg_hikashop_order AS b LEFT JOIN f8weg_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN f8weg_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN f8weg_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Hi, Not sure about this one. I have checked the DB and all the table collations are the same? I have even used this script to force all the same: www.siteground.com/kb/how_to_change_the_...ables_in_db_to_utf8/ I still get the error? Help please :)")* I work whith joomla 3.5 and hikashop 2.6.1 here started after the update to 3.5 joomla Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Nzc0MS1kYi1jb2xsYXRpb24taXNzdWUtZXZlbj90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 10 years 7 months ago [\#233999](#233999) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[DB Collation issue even](/forum/35-orders-management/877741-db-collation-issue-even#233999 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.3 -- Browser(s) name and version -- : any -- 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 f8weg_hikashop_order AS b LEFT JOIN f8weg_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN f8weg_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN f8weg_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') ORDER BY b.order_id desc LIMIT 0, 20 Hi, Not sure about this one. I have checked the DB and all the table collations are the same? I have even used this script to force all the same: www.siteground.com/kb/how_to_change_the_...ables_in_db_to_utf8/ I still get the error? Help please :)")* Hi, It's a problem with a change in the Joomla database. Download the install package of HikaShop on our website via the menu My account>My subscriptions and install it on your website. That will fix the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg3Nzc0MS1kYi1jb2xsYXRpb24taXNzdWUtZXZlbj90bXBsPW1hcmtkb3du) 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.058 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)