Products down after update

-- url of the page with the problem -- : nordicdental.dk/dental-shop/oralscanner/alliedstar-oralscannere
-- Browser(s) name and version -- : Chrome 156.0

Products down after update.
I need to reinstall my page now.
[color=rgba(255, 255, 255, 0.85)][color=rgba(255, 255, 255, 0.85)]En fejl opstod [/color] [/color]

[color=rgba(255, 255, 255, 0.85)]0 HY000, 1267, Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' [/color]

[color=rgba(255, 255, 255, 0.85)] [/color]
[color=rgba(255, 255, 255, 0.85)] [/color]

The error comes from the database update made by HikaShop 6.7.0/6.7.1: it moves the HikaShop tables to utf8mb4 so emojis can be saved. On your database some HikaShop tables were already in utf8mb4 with another collation (utf8mb4_general_ci vs utf8mb4_unicode_ci) and the update left them as they were. MySQL then refuses the queries that join these tables, which is why the product pages and the products listing of the backend fail. Your data is not damaged, so there is no need to reinstall anything.

We have corrected HikaShop so that the update and the "Check database" button put all the HikaShop tables on the same collation. Until that version is available, you can fix your site in two minutes:

1. Make a backup of your database.

2. Unzip the attached database.php.zip and upload the database.php file it contains to administrator/components/com_hikashop/helpers/ on your site, replacing the existing file.

3. In your backend, go to Components > HikaShop > System > Configuration and click the "Check database" button in the toolbar ( www.hikashop.com/support/documentation/54-hikashop-config.html ). It will report the tables it converted, and your product pages will work again.

If you prefer to do it directly in phpMyAdmin, the attached align-hikashop-collation.sql.txt file contains the queries to run, with the explanations.

Hi Nicolas
Ok, I think it is working now:-)
Thank you.

Sometimes I get this message when saving product.
En fejl opstod
42 42S22, 1054, Unknown column 'hk_price.price_value' in 'field list'

Hi,

This message comes from one of your mass actions, not from the database problem of the other day. When a product is saved, HikaShop runs the mass actions that have the "After a product is updated" trigger. Since HikaShop 6.7.0, an "Update values" action that calculates a value from the price (for example price.price_value*1.25) forgets to include the price table in its query, so MySQL refuses it with "Unknown column hk_price.price_value" and the save stops. This is why it only happens with some saves: those where that mass action applies.

We have corrected it on our end. Download again the install package of HikaShop on our website and install it on yours in order to get the patch.

Your mass action will then calculate its value again and products will save normally.

If the message still appears after that, please tell us which mass actions you have with a product trigger and what their actions are set to.