MySQL error

  • Resolved quantaweb

    (@quantaweb)


    6 years, 5 months ago

    I don’t usually filter posts by SEO score, but today I decided to do so. The result was a screenful of errors and no posts shown.

    Here is the error (which, for some reason, was shown twice):

    [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘))) AND ( ( ( wp_postmeta.meta_key = ‘_yoast_wpseo_linkdex’ AND CAST(wp’ at line 1]
    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = ‘_yoast_wpseo_meta-robots-noindex’ ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) WHERE 1=1 AND ((())) AND ( ( ( wp_postmeta.meta_key = ‘_yoast_wpseo_linkdex’ AND CAST(wp_postmeta.meta_value AS SIGNED) BETWEEN ’71’ AND ‘100’ ) ) AND ( mt1.post_id IS NULL OR ( mt2.meta_key = ‘_yoast_wpseo_meta-robots-noindex’ AND mt2.meta_value != ‘1’ ) ) ) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 100

    How can this be fixed?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    6 years, 4 months ago

    We are having a hard time reproducing this issue so we really need your help. If you have a few moments to spare, would you please provide us with some information about your WordPress setup.

    Here is a list of additional information that may be helpful while we investigate this issue:

    • Does the issue occur with the current version of WordPress?
    • Does the issue occur with the current version of the Yoast plugin?
    Plugin Support Jerlyn

    (@jerparx)

    6 years, 4 months ago

    Closed due to inactivity.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL error’ is closed to new replies.

Tags