pengtatt

Hi,

I can’t be sure whether my redirection plugin got hacked or not, from the error log under public_html it shows

[21-Jul-2016 15:23:35 UTC] WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation ‘=’ for query SELECT wp_redirection_items.*,wp_redirection_groups.position AS group_pos FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status=’enabled’ AND wp_redirection_groups.module_id=1 WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url=’/lin/fKk5V/シャネル’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, WordPress_Module->init, Red_Item::get_for_url

A check on the database, the wp_redirection_404 easily have 50000 entries related to the hacked files and links. The error log can be traced back to May 2015.
Unfortunately, I only discovered the somebody hacked and planted many files into my public_html and redirect my website to these files. I only discovered it when I see my disk space using up very fast.
I deleted the files and sub-directories but the errors do not seems go away.

Once I deactivate the redirection plugin yesterday, I don’t see these error.
However, I think this may not be solving the real issue.

From another error log file by SEO Ultimate plugin, I still see the redirection error even though I already deactivated the redirection plugin.

It could be some setting/config files or database that I need to clean up?

I am very new to this. Have been spending last few days figuring out what went wrong, steep learning curve for me.

Any suggestion that I can solve this problem once and for all?