Support » Fixing WordPress » Media Library search broken

  • Hello, I get this error when I try to search my media library

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'A OR ((tter.name LIKE '%man%')) OR ((tter.slug LIKE '%man%')) OR ((ttax.descri' at line 1]
    SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships AS trel ON (wp_posts.ID = trel.object_id) LEFT JOIN wp_term_taxonomy AS ttax ON ( ( ttax.taxonomy = 'category' OR ttax.taxonomy = 'post_tag' ) AND trel.term_taxonomy_id = ttax.term_taxonomy_id) LEFT JOIN wp_terms AS tter ON (ttax.term_id = tter.term_id) WHERE 1=1 AND ( ((((wp_posts.post_title LIKE '%man%') OR (wp_posts.post_content LIKE '%man%'))) A OR ((tter.name LIKE '%man%')) OR ((tter.slug LIKE '%man%')) OR ((ttax.description LIKE '%man%')) ) AND wp_posts.post_type = 'attachment') AND post_type != 'revision' ORDER BY wp_posts.post_date DESC LIMIT 0, 20

    Help?

  • The topic ‘Media Library search broken’ is closed to new replies.