[Skip to main content](#vessel-content) # Unable install Hikashop after Joomla update to 4.2.5 ## - **[brustolino](/forum/user/45569-brustolino "View brustolino's Profile")** - [![brustolino's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45569-brustolino "View brustolino's Profile") Topic Author - [ Offline](/forum/user/45569-brustolino) Less More - Posts: 3 - Thank you received: 0 - - 3 years 10 months ago [\#347276](#347276) by [brustolino](/forum/user/45569-brustolino "View brustolino's Profile") *[Unable install Hikashop after Joomla update to 4.2.5](/forum/25-install-update/905493-unable-install-hikashop-after-joomla-update-to-4-2-5#347276 "-- Joomla version -- : 4.2.5 -- PHP version -- : 8.0.21 -- Browser(s) name and version -- : Firefox 107.0.1 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Hi all, I am trying to install hikashop, but i get this error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Anyone know how to fix? Thank you all")* was created by *[brustolino](/forum/user/45569-brustolino "View brustolino's Profile")* -- Joomla version -- : 4.2.5 -- PHP version -- : 8.0.21 -- Browser(s) name and version -- : Firefox 107.0.1 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Hi all, I am trying to install hikashop, but i get this error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Anyone know how to fix? Thank you all Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTQ5My11bmFibGUtaW5zdGFsbC1oaWthc2hvcC1hZnRlci1qb29tbGEtdXBkYXRlLXRvLTQtMi01P3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 3 years 10 months ago [\#347280](#347280) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unable install Hikashop after Joomla update to 4.2.5](/forum/25-install-update/905493-unable-install-hikashop-after-joomla-update-to-4-2-5#347280 "-- Joomla version -- : 4.2.5 -- PHP version -- : 8.0.21 -- Browser(s) name and version -- : Firefox 107.0.1 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Hi all, I am trying to install hikashop, but i get this error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Anyone know how to fix? Thank you all")* Hi, I'm not sure since I was never able to reproduce the problem. However, let's try: - extract the HikaShop install package on your local computer. - edit the file back/helpers/database.php and change the line: Code: $query = 'UPDATE `#__hikashop_user` AS hku LEFT JOIN `#__users` AS ju ON hku.`user_email`=ju.`email` SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id`'; to: Code: $query = 'UPDATE `#__hikashop_user` AS hku LEFT JOIN `#__users` AS ju ON (hku.`user_email`=ju.`email` COLLATE utf8mb4_general_ci) SET hku.`user_cms_id`=ju.`id` WHERE hku.`user_cms_id`!=ju.`id`'; - zip again all the files/folders in a new install zip - install the modified zip Let us know if it works of if you get an error. If it works, we could include this change to avoid that error when there is a mix of collations (I suppose because of old Joomla table collations, or database setup). The following user(s) said Thank You: [brustolino](/forum/user/45569-brustolino "View brustolino's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTQ5My11bmFibGUtaW5zdGFsbC1oaWthc2hvcC1hZnRlci1qb29tbGEtdXBkYXRlLXRvLTQtMi01P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[brustolino](/forum/user/45569-brustolino "View brustolino's Profile")** - [![brustolino's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45569-brustolino "View brustolino's Profile") Topic Author - [ Offline](/forum/user/45569-brustolino) Less More - Posts: 3 - Thank you received: 0 - - 3 years 10 months ago [\#347292](#347292) by [brustolino](/forum/user/45569-brustolino "View brustolino's Profile") Replied by *[brustolino](/forum/user/45569-brustolino "View brustolino's Profile")* on topic *[Unable install Hikashop after Joomla update to 4.2.5](/forum/25-install-update/905493-unable-install-hikashop-after-joomla-update-to-4-2-5#347292 "-- Joomla version -- : 4.2.5 -- PHP version -- : 8.0.21 -- Browser(s) name and version -- : Firefox 107.0.1 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Hi all, I am trying to install hikashop, but i get this error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Anyone know how to fix? Thank you all")* Thanks for the reply, but now it gives the following error: COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTQ5My11bmFibGUtaW5zdGFsbC1oaWthc2hvcC1hZnRlci1qb29tbGEtdXBkYXRlLXRvLTQtMi01P3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 3 years 10 months ago [\#347303](#347303) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unable install Hikashop after Joomla update to 4.2.5](/forum/25-install-update/905493-unable-install-hikashop-after-joomla-update-to-4-2-5#347303 "-- Joomla version -- : 4.2.5 -- PHP version -- : 8.0.21 -- Browser(s) name and version -- : Firefox 107.0.1 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Hi all, I am trying to install hikashop, but i get this error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Anyone know how to fix? Thank you all")* Hi, In that case I'm not sure what would be a solution there we could include in HikaShop. As a quick fix for your situation, you can just remove the whole block of code: Code: $query = 'INSERT IGNORE INTO `#__hikashop_user` (`user_email`,`user_cms_id`,`user_created`) SELECT `email`, `id`,'.time().' FROM `#__users`'; $this->db->setQuery($query); try{ $result = $this->db->execute(); if($result){ $ret[] = array( 'success', 'Joomla users synchronized' ); } } catch(Exception $e) { $ret[] = array( 'error', $e->getMessage() ); } from there and run the installation again. It will circumvent the problem. That MySQL query is there for migrations between two websites so that HikaShop can resynchronize the user's id if they changed in Joomla compared to what they were before. So it won't change anything normally. The following user(s) said Thank You: [brustolino](/forum/user/45569-brustolino "View brustolino's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTQ5My11bmFibGUtaW5zdGFsbC1oaWthc2hvcC1hZnRlci1qb29tbGEtdXBkYXRlLXRvLTQtMi01P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[brustolino](/forum/user/45569-brustolino "View brustolino's Profile")** - [![brustolino's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45569-brustolino "View brustolino's Profile") Topic Author - [ Offline](/forum/user/45569-brustolino) Less More - Posts: 3 - Thank you received: 0 - - 3 years 10 months ago [\#347305](#347305) by [brustolino](/forum/user/45569-brustolino "View brustolino's Profile") Replied by *[brustolino](/forum/user/45569-brustolino "View brustolino's Profile")* on topic *[Unable install Hikashop after Joomla update to 4.2.5](/forum/25-install-update/905493-unable-install-hikashop-after-joomla-update-to-4-2-5#347305 "-- Joomla version -- : 4.2.5 -- PHP version -- : 8.0.21 -- Browser(s) name and version -- : Firefox 107.0.1 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Hi all, I am trying to install hikashop, but i get this error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Anyone know how to fix? Thank you all")* Same error... ![:(](/media/kunena/emoticons/5.png ":(") COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8 Omg ;_; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTQ5My11bmFibGUtaW5zdGFsbC1oaWthc2hvcC1hZnRlci1qb29tbGEtdXBkYXRlLXRvLTQtMi01P3RtcGw9bWFya2Rvd24=) 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: 86289 - Thank you received: 14265 - - 3 years 10 months ago [\#347313](#347313) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Unable install Hikashop after Joomla update to 4.2.5](/forum/25-install-update/905493-unable-install-hikashop-after-joomla-update-to-4-2-5#347313 "-- Joomla version -- : 4.2.5 -- PHP version -- : 8.0.21 -- Browser(s) name and version -- : Firefox 107.0.1 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Hi all, I am trying to install hikashop, but i get this error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' Anyone know how to fix? Thank you all")* Hi, You can't have that error message if you removed the block of code since the "collation utf8mb4_general_ci" comes from the modified MySQL query you've added in there. So it means you must have made a mistake in the process when modifying the code and zipping again all the files of the install package, or you used the wrong install package. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNTQ5My11bmFibGUtaW5zdGFsbC1oaWthc2hvcC1hZnRlci1qb29tbGEtdXBkYXRlLXRvLTQtMi01P3RtcGw9bWFya2Rvd24=) 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.172 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)