database error

  • Resolved monetenfuchs

    (@monetenfuchs)


    11 months, 1 week ago

    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.ID
    FROM wp_posts
    WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%Microsoft AZ-400 Practice Exams Questions e?|? Open ?€? https://www.pdfvce.com ?€‘ enter a?? AZ-400 a?? and obtain a free download e??￥AZ-400 Practice Test Online%’) OR (wp_posts.post_excerpt LIKE ‘%Microsoft AZ-400 Practice Exams Questions e?|? Open ?€? https://www.pdfvce.com ?€‘ enter a?? AZ-400 a?? and obtain a free download e??￥AZ-400 Practice Test Online%’) OR (wp_posts.post_content LIKE ‘%Microsoft AZ-400 Practice Exams Questions e?|? Open ?€? https://www.pdfvce.com ?€‘ enter a?? AZ-400 a?? and obtain a free download e??￥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’)))

                    ORDER BY (CASE WHEN wp_posts.post_title LIKE '%Microsoft AZ-400 Practice Exams Questions e?|? Open ?€? www.pdfvce.com ?€‘ enter a?? AZ-400 a?? and obtain a free download e??￥AZ-400 Practice Test Online%' THEN 1 WHEN wp_posts.post_title LIKE '%Microsoft AZ-400 Practice Exams Questions e?|? Open ?€? www.pdfvce.com ?€‘ enter a?? AZ-400 a?? and obtain a free download e??￥AZ-400 Practice Test Online%' THEN 2 WHEN wp_posts.post_excerpt LIKE '%Microsoft AZ-400 Practice Exams Questions e?|? Open ?€? www.pdfvce.com ?€‘ enter a?? AZ-400 a?? and obtain a free download e??￥AZ-400 Practice Test Online%' THEN 4 WHEN wp_posts.post_content LIKE '%Microsoft AZ-400 Practice Exams Questions e?|? Open ?€? www.pdfvce.com ?€‘ enter a?? AZ-400 a?? and obtain a free download e??￥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

    (@wpmudevsupport11)

    Hi @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://www.ads-software.com/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

    (@wpmudevsupport11)

    Hi @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.