Title: Fixing a WordPress Database/MySQL Syntax Error
Last modified: August 19, 2016

---

# Fixing a WordPress Database/MySQL Syntax Error

 *  [outofthebuzzsaw](https://wordpress.org/support/users/outofthebuzzsaw/)
 * (@outofthebuzzsaw)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/fixing-a-wordpress-databasemysql-syntax-error/)
 * At the top of my public WordPress page, the following error shows:
 * _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‘)
   ORDER BY RAND() LIMIT 1’ at line 5]
    SELECT ID FROM wp\_posts WHERE post\_type
   = ‘post’ AND post\_status = ‘publish’ AND post\_date <= curdate( ) – INTERVAL
   30 day AND ID Not IN () ORDER BY RAND() LIMIT 1
 * I have no idea what this means. This is a new page to which I’m transferring 
   content from my ‘old’ WordPress blog to one on a server under my own URL.
 * Thanks.
 * Dahna

Viewing 1 replies (of 1 total)

 *  [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * (@vtxyzzy)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/fixing-a-wordpress-databasemysql-syntax-error/#post-1707238)
 * I don’t know the reason, but there is no list of ID numbers being passed to the‘
   Not IN () ‘ part of the query. You would normally expect to see something like‘
   Not IN (32,6,635) ‘.

Viewing 1 replies (of 1 total)

The topic ‘Fixing a WordPress Database/MySQL Syntax Error’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [syntax error](https://wordpress.org/support/topic-tag/syntax-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [vtxyzzy](https://wordpress.org/support/users/vtxyzzy/)
 * Last activity: [15 years, 8 months ago](https://wordpress.org/support/topic/fixing-a-wordpress-databasemysql-syntax-error/#post-1707238)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics