Error 1267 - Illegal mix of collations

[Three_d]

Hello,

On te productdetails page I get the error:

Code Select Expand

Oops!1267 - Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8mb3_unicode_ci,EXPLICIT) for operation 'ifnull'
All other pages of the website seem to work but none of de productdetails pages.
It happened after the database was migrated from 5.7 to 8.

Can someone help me?

Jeroen

[Three_d]

I was able to solve the problem by going to Tools > Tools & Migration in VirtueMart and clicking on 'Update VirtueMart tables to UTF8MB4'. This caused the tables to be converted to UTF8MB4, but not all VirtueMart tables were converted to UTF8MB4 and an error message was displayed. By looking up the tables that had not yet been converted to UTF8MB4 via phpMyAdmin, I was able to find out where the problems were. That was in the tables prefix_virtuemart_categories_en_gb, prefix_virtuemart_manufacturercategories_en_gb, prefix_virtuemart_manufacturers_en_gb, prefix_virtuemart_paymentmethods_en_gb, prefix_virtuemart_products_en_gb, prefix_virtuemart_shipmentmethods_en_gb
By comparing the values of the fields with the NL tables, we were able to track down the problems and also run the 'Update VirtueMart tables to UTF8MB4' without errors.

Hopefully this information is useful to others.

Jeroen