Archives MySQL error

My archive index is generating an SQL error:

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 ‘(IP, time, referrer, keyword, page, browser, OS) VALUES ]
SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-01-30 13:39:21’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC LIMIT 6

Is it possible to fix this? And if not, can I just re-set the archives mechanism somehow, so that it will start over?

Thanks