[Skip to main content](#vessel-content) # Update Error ## - **[marcw](/forum/user/76961-marcw "View marcw's Profile")** - [![marcw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/76961-marcw "View marcw's Profile") Topic Author - [ Offline](/forum/user/76961-marcw) Less More - Posts: 11 - Thank you received: 0 - - 1 year 10 months ago [\#365008](#365008) by [marcw](/forum/user/76961-marcw "View marcw's Profile") *[Update Error](/forum/25-install-update/908982-update-error#365008 "-- url of the page with the problem -- : believer.com/book-store -- HikaShop version -- : 5.1.2 -- Joomla version -- : Joomla! 5.2.2 Stable -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Chrome Version 131.0.6778.140 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations Hello, When I did the last update from Hikashop 5.1.1 to 5.1.2, I received the following error: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '=' I am not sure what table and not sure how to correct also, the extension update now shows: Hikashop Installed: 5.1.2 to Available: 5.1.2 Thank you for your valuable time, marc")* was created by *[marcw](/forum/user/76961-marcw "View marcw's Profile")* -- url of the page with the problem -- : [ believer.com/book-store](https://believer.com/book-store) -- HikaShop version -- : 5.1.2 -- Joomla version -- : Joomla! 5.2.2 Stable -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Chrome Version 131.0.6778.140 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations Hello, When I did the last update from Hikashop 5.1.1 to 5.1.2, I received the following error: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '=' I am not sure what table and not sure how to correct also, the extension update now shows: Hikashop Installed: 5.1.2 to Available: 5.1.2 Thank you for your valuable time, marc Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzkwODk4Mi11cGRhdGUtZXJyb3IvMzY1MDA4P3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86291 - Thank you received: 14269 - - 1 year 10 months ago [\#365009](#365009) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Update Error](/forum/25-install-update/908982-update-error#365009 "-- url of the page with the problem -- : believer.com/book-store -- HikaShop version -- : 5.1.2 -- Joomla version -- : Joomla! 5.2.2 Stable -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Chrome Version 131.0.6778.140 -- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations Hello, When I did the last update from Hikashop 5.1.1 to 5.1.2, I received the following error: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '=' I am not sure what table and not sure how to correct also, the extension update now shows: Hikashop Installed: 5.1.2 to Available: 5.1.2 Thank you for your valuable time, marc")* Hi, This must come from the same process behind the "check database" button of the HikaShop configuration page. If you click that button, you should get the same error. In that case, it means that the update was successful as this process is done by HikaShop's update system right at the end. Also, this probably means that there is a difference between the collation of Joomla's users table and what HikaShop expects it to be. Ideally, you want to go in your PHPMyAdmin and change the collation of the "email" column of the users table to be utf8mb3_unicode_ci instead of utf8mb3_general_ci That way, you won't get the error next time you update HikaShop or you use the check database process. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzkwODk4Mi11cGRhdGUtZXJyb3IvMzY1MDA4P3RtcGw9bWFya2Rvd24=) 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.118 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)