ABJ-404-SOLUTION (ERROR): Ugh. SQL error

  • Resolved lestadt

    (@lestadt)


    6 years ago

    Hello, I am a frequent user of this plugin, today I looked at the error_log of one of my sites and I found this:

    [20-Mar-2019 09:10:07 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation ‘=’ for query select * from wp_abj404_redirects where url = ‘/my-post-name/?’ and disabled = 0 and status in (1, 2) and type not in (0) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, ABJ_404_Solution_WordPress_Connector::process404, ABJ_404_Solution_DataAccess->getActiveRedirectForURL
    [20-Mar-2019 09:10:45 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation ‘=’ for query select id from wp_abj404_logsv2 where requested_url = ‘/my-post-name/?’ limit 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, ABJ_404_Solution_WordPress_Connector::process404, ABJ_404_Solution_DataAccess->logRedirectHit, ABJ_404_Solution_DataAccess::queryAndGetResults
    [20-Mar-2019 09:10:45 UTC] ABJ-404-SOLUTION (ERROR): Ugh. SQL error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '='
    [20-Mar-2019 09:11:22 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation ‘=’ for query select * from wp_abj404_redirects where url = ‘/category/my-name-category/page/6/?’ and disabled = 0 and status in (1, 2) and type not in (0) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, ABJ_404_Solution_WordPress_Connector::process404, ABJ_404_Solution_DataAccess->getActiveRedirectForURL
    [20-Mar-2019 09:11:53 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation ‘=’ for query select id from wp_abj404_logsv2 where requested_url = ‘/category/my-name-category/page/6/?’ limit 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, ABJ_404_Solution_WordPress_Connector::process404, ABJ_404_Solution_DataAccess->logRedirectHit, ABJ_404_Solution_DataAccess::queryAndGetResults
    [20-Mar-2019 09:11:53 UTC] ABJ-404-SOLUTION (ERROR): Ugh. SQL error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '='
    —-
    The plugin seems to be working correctly, but I wanted to share this with you, I do not know if there really is a problem or if I have to configure something correctly .. Any suggestions?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Aaron

    (@aaron13100)

    Hey lestadt,

    Thanks for the heads-up. I’ve been getting a lot of these by email recently thanks to people who have checked the “Help the developer by sending error logs” box on the options page.

    I’m glad to hear the plugin is still working for you.

    I’m working on a fix for this and other error messages. I’m not sure when the next release will be though. Hopefully next week, but maybe after.

    Plugin Author Aaron

    (@aaron13100)

    Please try version 2.14.0. Thanks

    Plugin Author Aaron

    (@aaron13100)

    I’m pretty sure this is solved, so I’ll go ahead and close it. Let me know if there are other issues. thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘ABJ-404-SOLUTION (ERROR): Ugh. SQL error’ is closed to new replies.