[Skip to main content](#vessel-content) # installation failure ## - **[Peggasso](/forum/user/33234-peggasso "View Peggasso's Profile")** - [![Peggasso's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33234-peggasso "View Peggasso's Profile") Topic Author - [ Offline](/forum/user/33234-peggasso) Less More - Posts: 2 - Thank you received: 0 - - 12 years 3 months ago [\#162218](#162218) by [Peggasso](/forum/user/33234-peggasso "View Peggasso's Profile") *[installation failure](/forum/25-install-update/869354-installation-failure#162218 "Hello everyone. When I try to install HikaShop joomla 3.3.1 I get this error: 1267 Illegal mix of collations (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' SQL = UPDATE `AS` gym_hikashop_user hku gym_users `JOIN` AS ju ON hku. `User_email` = ju. Hku SET `email`. 'user_cms_id `= ju.` id `WHERE hku.` `user_cms_id! = ju.` id ` I changed the collation of the tables and I have put in all the HikaShop using, and still give the same error ...... So the extension but no plugin is installed, so when I get configure multiple faults. Any solution? Thanks in advance.")* was created by *[Peggasso](/forum/user/33234-peggasso "View Peggasso's Profile")* Hello everyone. When I try to install HikaShop joomla 3.3.1 I get this error: 1267 Illegal mix of collations (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' SQL = UPDATE `AS` gym_hikashop_user hku gym_users `JOIN` AS ju ON hku. `User_email` = ju. Hku SET `email`. 'user_cms_id `= ju.` id `WHERE hku.` `user_cms_id! = ju.` id ` I changed the collation of the tables and I have put in all the HikaShop using, and still give the same error ...... So the extension but no plugin is installed, so when I get configure multiple faults. Any solution? Thanks in advance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTM1NC1pbnN0YWxsYXRpb24tZmFpbHVyZT90bXBsPW1hcmtkb3du) 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 - - 12 years 3 months ago [\#162223](#162223) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[installation failure](/forum/25-install-update/869354-installation-failure#162223 "Hello everyone. When I try to install HikaShop joomla 3.3.1 I get this error: 1267 Illegal mix of collations (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' SQL = UPDATE `AS` gym_hikashop_user hku gym_users `JOIN` AS ju ON hku. `User_email` = ju. Hku SET `email`. 'user_cms_id `= ju.` id `WHERE hku.` `user_cms_id! = ju.` id ` I changed the collation of the tables and I have put in all the HikaShop using, and still give the same error ...... So the extension but no plugin is installed, so when I get configure multiple faults. Any solution? Thanks in advance.")* Hi, Extract the HikaShop install package and change the code: Code: $query = 'UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id`'; $this->db->setQuery($query); $this->db->query(); to: Code: $query = 'UPDATE `#__hikashop_user` AS hku JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id`'; $this->db->setQuery($query); try{$this->db->query();}catch(Exception $e){} in the file back/helpers/update.php, then compress again the files into a zip and use that zip for the install and that should hopefully avoid the problem. If not, simply delete these lines from that file all together and it will work. The following user(s) said Thank You: [Peggasso](/forum/user/33234-peggasso "View Peggasso's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTM1NC1pbnN0YWxsYXRpb24tZmFpbHVyZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Peggasso](/forum/user/33234-peggasso "View Peggasso's Profile")** - [![Peggasso's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33234-peggasso "View Peggasso's Profile") Topic Author - [ Offline](/forum/user/33234-peggasso) Less More - Posts: 2 - Thank you received: 0 - - 12 years 3 months ago [\#162270](#162270) by [Peggasso](/forum/user/33234-peggasso "View Peggasso's Profile") Replied by *[Peggasso](/forum/user/33234-peggasso "View Peggasso's Profile")* on topic *[installation failure](/forum/25-install-update/869354-installation-failure#162270 "Hello everyone. When I try to install HikaShop joomla 3.3.1 I get this error: 1267 Illegal mix of collations (utf8_general_ci, IMPLICIT) and (utf8_unicode_ci, IMPLICIT) for operation '=' SQL = UPDATE `AS` gym_hikashop_user hku gym_users `JOIN` AS ju ON hku. `User_email` = ju. Hku SET `email`. 'user_cms_id `= ju.` id `WHERE hku.` `user_cms_id! = ju.` id ` I changed the collation of the tables and I have put in all the HikaShop using, and still give the same error ...... So the extension but no plugin is installed, so when I get configure multiple faults. Any solution? Thanks in advance.")* Fixed. Works fine. thank you very much Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2OTM1NC1pbnN0YWxsYXRpb24tZmFpbHVyZT90bXBsPW1hcmtkb3du) 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.201 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)