Update Error

  • Posts: 10
  • Thank you received: 0
  • Hikashop Business
4 days 18 hours ago #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

Please Log in or Create an account to join the conversation.

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
4 days 16 hours ago #365009

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 or Create an account to join the conversation.

Time to create page: 0.054 seconds
Powered by Kunena Forum