Automation : No order found after update to 2.3.0

solved

I tried this soluion, found on this forum, but it didn't change anything

ALTER TABLE `PREFIX_revws_criterion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_criterion_lang` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_criterion_category` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_criterion_product` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_review` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_review_grade` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_review_reaction` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_review_image` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_email` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PREFIX_revws_subscription` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Did you change PREFIX with your db prefix (usually ps) ?

yes. tables where already in utf8mb4_unicode_ci

Then check collation and charset of your core tables, for example ps_orders table. They should use utf8mb4_unicode_ci as well, but if your ps is older, it might not.

In that case, I suggest you update revws tables to match charset and collations of your core tables. For example, if it uses utf8mb4_general_ci, then convert revws tables to this collation as well

That's right. My core tables are using utf8mb4_general_ci.

It works now. Thanks !