SQL error, not my host’s problem

This is on WP 1.2.2. I’m new to WP (convert from graymatter), new to style sheets and new to SQL, and until about an hour ago I was king of the world.

I have no recollection of changing anything other than uncommenting the popup comments script, but I’m now getting the following 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 ‘AND comment_approved = ‘1” at line 1]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = AND comment_approved = ‘1’;

My host was already running php 4.3.1 for some while before I got there and I’ve had the blog up and running for a couple of weeks, which would seem to rule out the php/zend problem.

The blog is here:
http://216.193.229.211/btcnews/index.php

I’m running one comments-related plugin, Elliot Black’s hashcash, which I installed two days ago with no problem (in fact it’s great, zapped the bejeebers out of my regular poker spammers).

The message is repeated, with the second instance being a link to the popup comment window for the last post on the page. I made a couple of posts private to check, and the error link always goes to the comments for the bottom post.

I’m at a complete loss here. Any notions will be greatly appreciated.

Cheers,
wb