Module Out? No more orders detected, no more shipments, nothing

solved

Hello,

Since October 21, 2021 and my dozens of orders received, the module has stopped working, no more emails sent to customers, no orders or requests detected in the back office, it no longer works at all.

Cron is still activated and valid, but nothing is displayed in the back office, everything is empty!

No modification on my side, still the same server, nothing special ... ThirtyBees 1.2.0

What does it come from?

The same thing happened to us when we upgraded from a Thirty Bees 1.2 shop to version 1.3, it no longer recognises orders and does not send follow-up emails to customers.

Is there anything that can be done to get the module working again? Thanks in advance.

One possible reason is that your core database tables are using different charset/collation then revws tables. Some database servers have problems with queries that joins tables with different collations.

To fix this, you can execute following sqls (replece PREFIX with your db prefix)

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;

Thank you very much, with these modifications the problems have been solved.

wow, you are fast!