Resolved Error import custom fields

Hello Thijs,

This error is not a problem with your import file but with your database structure. The error you see is because some parts in your database will only accept utf8_general_ci data and others only utf8mb4_general_ci. This mix, the database can't handle. What needs to be done is set everything to the same collation, this should be utf8mb4_general_ci everywhere. Once that is done, you can run the import again.

I believe Admin Tools has an option to fix the collation in your database, otherwise it needs to be done with a program like PhpMyAdmin.

Hi Roland,

I've just spent the pas 2 hours updating every table in my database to collation utf8mb4_general_ci.
Tested the import again and I get the same error again...

Er is een fout opgetreden tijdens de import. Hieronder het antwoord dat is ontvangen van de server.
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

Hope you can help me with this...

Thank you.

Kind regards,

Thijs

Hello Thijs,

I've just spent the pas 2 hours updating every table in my database to collation utf8mb4_general_ci.

You had so many tables and fields that were not utf8mb4?

The error may not have changed because not all fields are utf8mb4 yet. Have a look at the attached screenshot. The text fields have their own setting. Perhaps only change that where needed for the product and category tables and then give it a test run.

Thx Roland,

I'll look into it and have a go.

Any Idea which tables to check? Only the CSVI tables or the virtuemart tables as well?

Hello Thijs,

This concerns the VirtueMart tables. You would most likely be looking at the virtuemart_products and virtuemart_products_nl tables. The same goes for the virtuemart_categories. The fields you need to check are the text fields but I guess you see it soon enough once you have the fields list like I posted in the screenshot.