• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

BUG WordPress database error: [Illegal mix of collations

Designful

New member
Messages
3
Likes
0
Points
1
#1
Screenshot

WordPress database error: [Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '=']
SELECT COUNT(DISTINCT p.ID) FROM wordpress_posts p WHERE NOT EXISTS (SELECT * FROM wordpress_rio_process_queue WHERE p.ID = object_id AND p.post_type = item_type) AND p.post_type = 'attachment' AND p.post_mime_type IN ( 'image/jpeg', 'image/gif', 'image/png' )
 

Attachments

Temyk

Developer & Support
Messages
1,129
Likes
42
Points
48
#3
Hi,

What version of Robin do you have installed?
1561444129943.png

Update to the latest version.

If you have any questions or comments, please let me know and I'll be more than glad to assist you.
 

alexkovalev

Program developer
Staff member
Messages
267
Likes
19
Points
18
#5
Hi,

Try this plugin to fix the encoding in the database: Database Collation Fix

Be sure to make a backup before trying to fix it!

There is also a notice in your list of recommendations that it would be nice to change the encoding in the wp-config.php file.

Best regards, Alex