Title: Database error; SQL syntax
Last modified: August 19, 2016

---

# Database error; SQL syntax

 *  [Cyndy Otty](https://wordpress.org/support/users/ceo/)
 * (@ceo)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/database-error-sql-syntax/)
 * Doing a search for this I couldn’t find a specific thread that dealt with comments
   initiating this issue:
 * > WordPress 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’ ORDER BY comment_date_gmt DESC LIMIT 15′ at line
   > 1 for query SELECT wp_comments.* FROM wp_comments WHERE comment_post_ID = AND
   > comment_approved = ‘1’ ORDER BY comment_date_gmt DESC LIMIT 15
 * I do recall generating this error when I was using the OpenID plugin, but I gave
   up on that ages ago. I can’t figure out what is causing the error because I personally
   can’t seem to recreate it.
 * Suggestions? I’m totally lost!

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

 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/database-error-sql-syntax/#post-701282)
 * When exactly does the error occur? And if it’s displayed on an otherwise normally
   working page, where? No additional comment-related plugins such as one for recent
   comments?
 * Looking over the SQL query the comment_post_ID is not being assigned a value (
   that is, the post’s numeric ID). This is of course the cause of the error.
 *  Thread Starter [Cyndy Otty](https://wordpress.org/support/users/ceo/)
 * (@ceo)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/database-error-sql-syntax/#post-701289)
 * I can’t figure out what triggers the error, Kaf, as I personally can’t recreate
   it. I’m only seeing it pop up in error logs. And it’s definitely not every comment.
 * While it seems to have started randomly with all the plugins I had active working
   fine before this error cropped up, I did disable the two comment related ones
   I had (Absolute Comments – I think it was called, that allows you to comment 
   through the admin panel – and Subscribe to Comments). As evidenced by the above
   post, that didn’t seem to clear it up.
 * Is it maybe being generated by spam comments?
 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/database-error-sql-syntax/#post-701338)
 * Hmm. Definitely strange if it’s only appearing in your error log.
 * Extremely unlikely it’s due to spam attempts. It’s a SELECT query, where something
   is making a request to the database for a number of comments (LIMIT 15) on a 
   specific post. Or at least, it would be a specific post if the post ID was there.
 * No chance any commented code is hiding in your templates or perhaps a function
   in the theme’s functions.php? Long shot guess as I’m not sure what the need would
   be (in a plugin or some embedded code) for calling the comments on a post, but
   limiting them to just 15.
 *  Thread Starter [Cyndy Otty](https://wordpress.org/support/users/ceo/)
 * (@ceo)
 * [18 years, 3 months ago](https://wordpress.org/support/topic/database-error-sql-syntax/#post-701422)
 * Well, hmm.
 * I did move to a new domain and server, but I moved the entire website, databases
   and all . . . so I can’t say it’s that. And I haven’t changed any of my theme
   files, etc. even when I was using comment related plugins.
 * I only suggested that perhaps it’s a spam thing because I’m not seeing a comment
   pop up necessarily when I notice the error times in my log. But I’ve personally
   left comments and other people have as well and there’s no SQL error generated.
   I’m totally befuddled.
 * It’s so random and weird, it’s nearly funny. The 15 thing I really don’t get ...
   coincidently though that is how many posts are pulled for each PAGE of posts 
   on my site, but I hardly think that’s related.

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

The topic ‘Database error; SQL syntax’ is closed to new replies.

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)
 * [SQL syntax](https://wordpress.org/support/topic-tag/sql-syntax/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [Cyndy Otty](https://wordpress.org/support/users/ceo/)
 * Last activity: [18 years, 3 months ago](https://wordpress.org/support/topic/database-error-sql-syntax/#post-701422)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics