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: http://www.michaelhamilton.ca/?page_id=56