Support » Fixing WordPress » Database error with regard to Category Archives?

  • I’m having trouble with the category archives on my site. The Date-sorted archives work just fine, but when I try the “Category” links, I receive an error. Can anyone help me with this? I’m using WP 2.0.

    Here is the error that I receive:

    WordPress database error: [You have an error in your SQL syntax near ‘-1-1’ at line 1]
    SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (category_id = 7) AND post_date_gmt <= ‘2006-02-09 04:34:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) GROUP BY wp_posts.ID ORDER BY post_category DESC LIMIT 0, 999-1-1

    Any tips? Here is a link to my general Archives page:

  • The topic ‘Database error with regard to Category Archives?’ is closed to new replies.