Scary spammy database error
-
I had debugging log on the last few days. Today I was shocked to see a database error that involved a bunch of spammy phrases and icons. I don’t really know what it means or where it came from. I searched the WF traffic log and found no security entry that seemed to correspond at that time.
Can you tell how this happened? Is this something WF can block?
[18-Dec-2020 17:00:52 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS wp75_posts.ID FROM wp75_posts WHERE 1=1 AND wp75_posts.ID NOT IN (5729,5709,4178,2170,2433,1966,1908,1800,650,76) AND (((wp75_posts.post_title LIKE '%💕🦸 Pills without prescription on 🎁 www.xxxxxxx.store 🎁 Buy Levitra from $0.84/pill 🦸💕Purchase Levitra Canada - Levitra 20 Mg Order Online%') OR (wp75_posts.post_excerpt LIKE '%💕🦸 Pills without prescription on 🎁 www.NetDoctor.store 🎁 Buy Levitra from $0.84/pill 🦸💕Purchase Levitra Canada - Levitra 20 Mg Order Online%') OR (wp75_posts.post_content LIKE '%💕🦸 Pills without prescription on 🎁 www.xxxxx.store 🎁 Buy Levitra from $0.84/pill 🦸💕Purchase Levitra Canada - Levitra 20 Mg Order Online%'))) AND (wp75_posts.post_password = '') AND wp75_posts.post_type IN ('post', 'page', 'attachment', 'ncpage', 'event') AND (wp75_posts.post_status = 'publish' OR wp75_posts.post_status = 'closed') ORDER BY (CASE WHEN wp75_posts.post_title LIKE '%💕🦸 Pills without prescription on 🎁 www.xxxx.store 🎁 Buy Levitra from $0.84/pill 🦸💕Purchase Levitra Canada - Levitra 20 Mg Order Online%' THEN 2 ELSE 6 END), wp75_posts.post_date DESC LIMIT 0, 15 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
- The topic ‘Scary spammy database error’ is closed to new replies.