Failed To Find Pharm Hack

I installed your plugin and ran the initial Sync/Scan and it did not find this Pharm Hack I know exists on the site because it is in the site’s php.error.log.
Deactivated plugin and reactivated it and it scanned again with the same results.
(…I have screenshots)
Also, only 3 out of 26 tables were synced.
Why did the plugin not find this hack?
Why are only 3 of 26 tables synced?

WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships AS tr ON (wp_posts.ID = tr.object_id) LEFT JOIN wp_term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) LEFT JOIN wp_terms AS t ON (tt.term_id = t.term_id) WHERE 1=1 AND ( ((wp_posts.post_title LIKE '%????%') OR (wp_posts.post_content LIKE '%????%') OR (wp_posts.post_excerpt LIKE '%????%') OR ( ( t.name LIKE '%????%' ) )) AND ((wp_posts.post_title LIKE '%Naprosyn%') OR (wp_posts.post_content LIKE '%Naprosyn%') OR (wp_posts.post_excerpt LIKE '%Naprosyn%') OR ( ( t.name LIKE '%Naprosyn%' ) )) AND ((wp_posts.post_title LIKE '%Buy%') OR (wp_posts.post_content LIKE '%Buy%') OR (wp_posts.post_excerpt LIKE '%Buy%') OR ( ( t.name LIKE '%Buy%' ) )) AND ((wp_posts.post_title LIKE '%:%') OR (wp_posts.post_content LIKE '%:%') OR (wp_posts.post_excerpt LIKE '%:%') OR ( ( t.name LIKE '%:%' ) )) AND ((wp_posts.post_title LIKE '%??%') OR (wp_posts.post_content LIKE '%??%') OR (wp_posts.post_excerpt LIKE '%??%') OR ( ( t.name LIKE '%??%' ) )) AND ((wp_posts.post_title LIKE '%www.PillsDealer.com%') OR (wp_posts.post_content LIKE '%www.PillsDealer.com%') OR (wp_posts.post_excerpt LIKE '%www.PillsDealer.com%') OR ( ( t.name LIKE '%www.PillsDealer.com%' ) )) AND ((wp_posts.post_title LIKE '%??%') OR (wp_posts.post_content LIKE '%??%') OR (wp_posts.post_excerpt LIKE '%??%') OR ( ( t.name LIKE '%??%' ) )) AND ((wp_posts.post_title LIKE '%-%') OR (wp_posts.post_content LIKE '%-%') OR (wp_posts.post_excerpt LIKE '%-%') OR ( ( t.name LIKE '%-%' ) )) AND ((wp_posts.post_title LIKE '%Cheapest%') OR (wp_posts.post_content LIKE '%Cheapest%') OR (wp_posts.post_excerpt LIKE '%Cheapest%') OR ( ( t.name LIKE '%Cheapest%' ) )) AND ((wp_posts.post_title LIKE '%pills%') OR (wp_posts.post_content LIKE '%pills%') OR (wp_posts.post_excerpt LIKE '%pills%') OR ( ( t.name LIKE '%pills%' ) )) AND ((wp_posts.post_title LIKE '%????Buy%') OR (wp_posts.post_content LIKE '%????Buy%') OR (wp_posts.post_excerpt LIKE '%????Buy%') OR ( ( t.name LIKE '%????Buy%' ) )) AND ((wp_posts.post_title LIKE '%Naprosyn%') OR (wp_posts.post_content LIKE '%Naprosyn%') OR (wp_posts.post_excerpt LIKE '%Naprosyn%') OR ( ( t.name LIKE '%Naprosyn%' ) )) AND ((wp_posts.post_title LIKE '%Australia.%') OR (wp_posts.post_content LIKE '%Australia.%') OR (wp_posts.post_excerpt LIKE '%Australia.%') OR ( ( t.name LIKE '%Australia.%' ) )) AND ((wp_posts.post_title LIKE '%Order%') OR (wp_posts.post_content LIKE '%Order%') OR (wp_posts.post_excerpt LIKE '%Order%') OR ( ( t.name LIKE '%Order%' ) )) AND ((wp_posts.post_title LIKE '%Naprosyn%') OR (wp_posts.post_content LIKE '%Naprosyn%') OR (wp_posts.post_excerpt LIKE '%Naprosyn%') OR ( ( t.name LIKE '%Naprosyn%' ) )) AND ((wp_posts.post_title LIKE '%500%') OR (wp_posts.post_content LIKE '%500%') OR (wp_posts.post_excerpt LIKE '%500%') OR ( ( t.name LIKE '%500%' ) )) AND ((wp_posts.post_title LIKE '%Mg%') OR (wp_posts.post_content LIKE '%Mg%') OR (wp_posts.post_excerpt LIKE '%Mg%') OR ( ( t.name LIKE '%Mg%' ) )) AND ((wp_posts.post_title LIKE '%Cost%') OR (wp_posts.post_content LIKE '%Cost%') OR (wp_posts.post_excerpt LIKE '%Cost%') OR ( ( t.name LIKE '%Cost%' ) ))) AND wp_posts.post_type IN ('post', 'page') AND (wp_posts.post_status = 'publish') ORDER BY wp_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

• This topic was modified 3 years, 7 months ago by neotechnomad. Reason: additinal info