Title: ABJ-404-SOLUTION (ERROR): Ugh. SQL error
Last modified: March 20, 2019

---

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

 *  Resolved [lestadt](https://wordpress.org/support/users/lestadt/)
 * (@lestadt)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/abj-404-solution-error-ugh-sql-error/)
 * 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](https://wordpress.org/support/users/aaron13100/)
 * (@aaron13100)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/abj-404-solution-error-ugh-sql-error/#post-11337554)
 * 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](https://wordpress.org/support/users/aaron13100/)
 * (@aaron13100)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/abj-404-solution-error-ugh-sql-error/#post-11342349)
 * Please try version 2.14.0. Thanks
 *  Plugin Author [Aaron](https://wordpress.org/support/users/aaron13100/)
 * (@aaron13100)
 * [7 years, 1 month ago](https://wordpress.org/support/topic/abj-404-solution-error-ugh-sql-error/#post-11363858)
 * 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.

 * ![](https://ps.w.org/404-solution/assets/icon-256x256.jpg?rev=1610739)
 * [404 Solution](https://wordpress.org/plugins/404-solution/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/404-solution/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/404-solution/)
 * [Active Topics](https://wordpress.org/support/plugin/404-solution/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/404-solution/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/404-solution/reviews/)

## Tags

 * [error_log](https://wordpress.org/support/topic-tag/error_log/)
 * [sql-error](https://wordpress.org/support/topic-tag/sql-error/)
 * [WordPress database error](https://wordpress.org/support/topic-tag/wordpress-database-error/)

 * 3 replies
 * 2 participants
 * Last reply from: [Aaron](https://wordpress.org/support/users/aaron13100/)
 * Last activity: [7 years, 1 month ago](https://wordpress.org/support/topic/abj-404-solution-error-ugh-sql-error/#post-11363858)
 * Status: resolved