Skip to:

many lines of SQL sysntax errors in error log

  • Lately, I find a lot of lines with SQL syntax errors in my error log

    `[31-Jan-2013 08:06:53 UTC] 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 ‘) LIMIT 0, 8’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%’))) AND (wp_posts.post_password = ”) AND wp_posts.post_type IN (‘post’, ‘forum’, ‘topic’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘closed’) ORDER BY FIELD(wp_posts.ID, ) LIMIT 0, 8 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts`

    It seems like the ‘%’ should have been something like ‘%s’ and replaced by a string?

  • You must be logged in to reply to this topic.
Skip to toolbar