FAQ09 – WordPress database error: [Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT)

This error can occur if some of your database tables have different character encoding and is not caused by Multi Rating Pro. Multi Rating Pro uses the default WordPress charset collate when the db tables are created or updated (global $charset_collate variable).

If you encounter this error, there is an SQL query you can use to alter the DB table collate (make sure you change the table names as required).

ALTER TABLE table CONVERT TO CHARACTER SET "utf8", COLLATE "utf8_general_ci"