[Skip to main content](#vessel-content) # Products down after update ## - **[Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile")** - [![Peter Kjeldsen's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile") Topic Author - [ Offline](/forum/user/33928-peter-kjeldsen) - Peter Kjeldsen Less More - Posts: 167 - Thank you received: 6 - - - [](http://www.nordicdental.dk) - 3 weeks 19 hours ago [\#100000306](#100000306) by [Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile") *[Products down after update](/forum/25-install-update/100000062-products-down-after-update#100000306 "-- 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. [/font][/size][/color]")* was created by *[Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile")* -- url of the page with the problem -- : [ nordicdental.dk/dental-shop/oralscanner/alliedstar-oralscannere](https://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)][ ](https://nordicdental.dk/administrator)[/color] [color=rgba(255, 255, 255, 0.85)][ ](https://nordicdental.dk/administrator/index.php?option=com_hikashop&ctrl=product#)[/color] Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzEwMDAwMDA2Mi1wcm9kdWN0cy1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 3 weeks 18 hours ago [\#100000308](#100000308) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products down after update](/forum/25-install-update/100000062-products-down-after-update#100000308 "-- 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. [/font][/size][/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](https://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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzEwMDAwMDA2Mi1wcm9kdWN0cy1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile")** - [![Peter Kjeldsen's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile") Topic Author - [ Offline](/forum/user/33928-peter-kjeldsen) - Peter Kjeldsen Less More - Posts: 167 - Thank you received: 6 - - - [](http://www.nordicdental.dk) - 3 weeks 18 hours ago [\#100000310](#100000310) by [Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile") Replied by *[Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile")* on topic *[Products down after update](/forum/25-install-update/100000062-products-down-after-update#100000310 "-- 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. [/font][/size][/color]")* Hi Nicolas Ok, I think it is working now:-) Thank you. The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzEwMDAwMDA2Mi1wcm9kdWN0cy1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile")** - [![Peter Kjeldsen's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile") Topic Author - [ Offline](/forum/user/33928-peter-kjeldsen) - Peter Kjeldsen Less More - Posts: 167 - Thank you received: 6 - - - [](http://www.nordicdental.dk) - 2 weeks 6 days ago [\#100000335](#100000335) by [Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile") Replied by *[Peter Kjeldsen](/forum/user/33928-peter-kjeldsen "View Peter Kjeldsen's Profile")* on topic *[Products down after update](/forum/25-install-update/100000062-products-down-after-update#100000335 "-- 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. [/font][/size][/color]")* Sometimes I get this message when saving product. En fejl opstod 42 42S22, 1054, Unknown column 'hk_price.price_value' in 'field list' Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzEwMDAwMDA2Mi1wcm9kdWN0cy1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 2 weeks 6 days ago [\#100000337](#100000337) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products down after update](/forum/25-install-update/100000062-products-down-after-update#100000337 "-- 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. [/font][/size][/color]")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzEwMDAwMDA2Mi1wcm9kdWN0cy1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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.072 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)