Title: database error
Last modified: December 20, 2023

---

# database error

 *  Resolved [monetenfuchs](https://wordpress.org/support/users/monetenfuchs/)
 * (@monetenfuchs)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/database-error-399/)
 * Hallo,
 * ich erhalte folgende Fehlermeldung in der ERROR-Log:
 * 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 wp_posts.IDFROM wp_postsWHERE 1=1 AND (((wp_posts.post_title
   LIKE ‘%Microsoft AZ-400 Practice Exams Questions 🦝 Open 【 [http://www.pdfvce.com](http://www.pdfvce.com)
   】 enter ⮆ AZ-400 ⮄ and obtain a free download 🎥AZ-400 Practice Test 
   Online%’) OR (wp_posts.post_excerpt LIKE ‘%Microsoft AZ-400 Practice Exams Questions
   🦝 Open 【 [http://www.pdfvce.com](http://www.pdfvce.com) 】 enter ⮆ AZ-
   400 ⮄ and obtain a free download 🎥AZ-400 Practice Test Online%’) OR (wp_posts.
   post_content LIKE ‘%Microsoft AZ-400 Practice Exams Questions 🦝 Open 【 [http://www.pdfvce.com](http://www.pdfvce.com)
   】 enter ⮆ AZ-400 ⮄ and obtain a free download 🎥AZ-400 Practice Test 
   Online%’))) AND (wp_posts.post_password = ”) AND ((wp_posts.post_type = ‘post’
   AND (wp_posts.post_status = ‘publish’)) OR (wp_posts.post_type = ‘page’ AND (
   wp_posts.post_status = ‘publish’)) OR (wp_posts.post_type = ‘attachment’ AND (
   wp_posts.post_status = ‘publish’)))
 *     ```wp-block-code
                       ORDER BY (CASE WHEN wp_posts.post_title LIKE '%Microsoft AZ-400 Practice Exams Questions 🦝 Open 【 www.pdfvce.com 】 enter ⮆ AZ-400 ⮄ and obtain a free download 🎥AZ-400 Practice Test Online%' THEN 1 WHEN wp_posts.post_title LIKE '%Microsoft AZ-400 Practice Exams Questions 🦝 Open 【 www.pdfvce.com 】 enter ⮆ AZ-400 ⮄ and obtain a free download 🎥AZ-400 Practice Test Online%' THEN 2 WHEN wp_posts.post_excerpt LIKE '%Microsoft AZ-400 Practice Exams Questions 🦝 Open 【 www.pdfvce.com 】 enter ⮆ AZ-400 ⮄ and obtain a free download 🎥AZ-400 Practice Test Online%' THEN 4 WHEN wp_posts.post_content LIKE '%Microsoft AZ-400 Practice Exams Questions 🦝 Open 【 www.pdfvce.com 】 enter ⮆ AZ-400 ⮄ and obtain a free download 🎥AZ-400 Practice Test Online%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
                       LIMIT 0, 10
                    made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
       ```
   

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * (@wpmudevsupport11)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/database-error-399/#post-17293436)
 * Hi [@monetenfuchs](https://wordpress.org/support/users/monetenfuchs/),
 * Could we know what is the version of the Broken Link Checker plugin that you 
   are currently using and also the WordPress version?
 * The error in general occurs when there is a change in default collation:
 * Most probably the ‘posts’ table and its columns, specifically ‘post_type’, maintain
   the old collation, causing errors when installing BLC, which uses the new default.
 * Fixing this issue requires ensuring all tables use the same collation, which 
   can be fixed by your host, or with the help of the ‘Database Collation Fix’plugin:
 * [https://wordpress.org/plugins/database-collation-fix/](https://wordpress.org/plugins/database-collation-fix/)
 * This plugin should help convert the tables using the ‘utf8mb4_unicode_520_ci’
   or ‘utf8_unicode_520_ci’ collation algorithms to ‘utf8mb4_unicode_ci’.
 * Please do make sure to run the above test in a staging site and let us know if
   you have any further queries.
 * Best Regards,
 * Nithin
 *  Plugin Support [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * (@wpmudevsupport11)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/database-error-399/#post-17305028)
 * Hi [@monetenfuchs](https://wordpress.org/support/users/monetenfuchs/),
 * Since we haven’t heard from you for a while. I’ll mark this thread as resolved
   for now. Please feel free to open a new thread if you have new queries.
 * Best Regards
   Nithin

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘database error’ is closed to new replies.

 * ![](https://ps.w.org/broken-link-checker/assets/icon-256x256.png?rev=2900468)
 * [Broken Link Checker](https://wordpress.org/plugins/broken-link-checker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/broken-link-checker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/broken-link-checker/)
 * [Active Topics](https://wordpress.org/support/plugin/broken-link-checker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/broken-link-checker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/broken-link-checker/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Nithin – WPMU DEV Support](https://wordpress.org/support/users/wpmudevsupport11/)
 * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/database-error-399/#post-17305028)
 * Status: resolved