• Resolved wpdev917

    (@wpdev917)


    Hello,
    I’m reviewing the error logs on my server and am noticing a number of entries that involve Redirection. I’m not exactly sure what they are referring to. Can you please review and help me troubleshoot? Thank you.

    [24-Jan-2018 09:34:30 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20web.rar’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:35:15 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20web.zip’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:35:40 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20website.rar’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:36:47 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20websoft.zip’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:37:11 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20www.rar’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:37:35 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20www.zip’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:38:19 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20wwwroot.rar’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:39:26 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/∏¥º˛%20wwwroot.zip’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:40:13 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/–¬Ω®%20WinRAR%20ZIP%20—πÀıŒƒº˛.zip’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:41:53 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/–¬Ω®%20WinRAR%20—πÀıŒƒº˛.rar’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:42:17 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/–¬Ω®Œƒº˛º–.7z’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:43:01 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/–¬Ω®Œƒº˛º–.rar’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url
    [24-Jan-2018 09:43:44 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_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=’/–¬Ω®Œƒº˛º–.zip’) 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’), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘Error Log: WordPress database error Illegal mix of collations’ is closed to new replies.