Hello there is an error that i have for 3 months now
Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '=' (SQL: select count(*) as aggregate from `wp_fc_subscribers` where `status` = 'subscribed' and `email` in (select `wp_wc_customer_lookup`.`email` from `wp_wc_customer_lookup` inner join `wp_fc_subscribers` on `wp_fc_subscribers`.`email` = `wp_wc_customer_lookup`.`email`))
can you please help?
This is what happened: your Woo’s database table and FluentCRM’s database tables have different collations. Most probably your server got changed somehow and when installing FluentCRM or the Woo then the collations got mixed.
possible solution:
Use admirer or phpMyAdmin to change the collations to utf8mb4_unicode_ci for all the tables.