Title: SQL error, not my host’s problem
Last modified: August 18, 2016

---

# SQL error, not my host’s problem

 *  [weldonberger](https://wordpress.org/support/users/weldonberger/)
 * (@weldonberger)
 * [21 years, 4 months ago](https://wordpress.org/support/topic/sql-error-not-my-hosts-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](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

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [weldonberger](https://wordpress.org/support/users/weldonberger/)
 * (@weldonberger)
 * [21 years, 4 months ago](https://wordpress.org/support/topic/sql-error-not-my-hosts-problem/#post-126224)
 * Never mind. Apparently I accidentally dragged the query from where it belonged
   to where it doesn’t. It’s fixed now.
 *  Thread Starter [weldonberger](https://wordpress.org/support/users/weldonberger/)
 * (@weldonberger)
 * [21 years, 4 months ago](https://wordpress.org/support/topic/sql-error-not-my-hosts-problem/#post-126232)
 * Never mind. Apparently I accidentally dragged the query from where it belonged
   to where it doesn’t. It’s fixed now.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL error, not my host’s problem’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 1 participant
 * Last reply from: [weldonberger](https://wordpress.org/support/users/weldonberger/)
 * Last activity: [21 years, 4 months ago](https://wordpress.org/support/topic/sql-error-not-my-hosts-problem/#post-126232)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics