Title: Problem with Database error on fresh install
Last modified: August 18, 2016

---

# Problem with Database error on fresh install

 *  [czrsink](https://wordpress.org/support/users/czrsink/)
 * (@czrsink)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/problem-with-database-error-on-fresh-install/)
 * Help!
 * I’ve just set up my first WordPress site and I’m having a problem which seems
   to have been mentioned a few times on here, but doesn’t yet have a solution?
 * Here is the error in full:
 * WordPress database error: [Unknown column ‘publish’ in ‘where clause’]
    SELECT
   DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-04-14 12:44:59’
   AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT
   0, 10
 * If anybody can help me resolve this problem I would be extremely grateful. I 
   am able to Administer the site and post, but everytime the site is viewed the
   posts are missing and you are presented with the ‘Search’ option.
 * “Not Found
 * Sorry, but you are looking for something that isn’t here.”
 * Thanks,
    czrsiNk

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

 *  [ColdForged](https://wordpress.org/support/users/coldforged/)
 * (@coldforged)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/problem-with-database-error-on-fresh-install/#post-187740)
 * A search turned up [this](http://wordpress.org/support/topic.php?id=18563). Try
   that?
 *  Thread Starter [czrsink](https://wordpress.org/support/users/czrsink/)
 * (@czrsink)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/problem-with-database-error-on-fresh-install/#post-187744)
 * If only…
 * My wp-blog-header.php file doesn’t have that many lines, and makes no mention
   of $where at any point. I’m using 1.5 if that means anything?
 * (Sorry for repost and bumping up an old thread!)
 *  [ColdForged](https://wordpress.org/support/users/coldforged/)
 * (@coldforged)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/problem-with-database-error-on-fresh-install/#post-187746)
 * Eh, didn’t realize that was a 1.2.x post, my bad. How about `wp-includes/classes.
   php`. Mine’s at line 505, but yours may be different. Search for `$where .= '
   AND (post_status = "publish"';`
 *  Thread Starter [czrsink](https://wordpress.org/support/users/czrsink/)
 * (@czrsink)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/problem-with-database-error-on-fresh-install/#post-187751)
 * Thanks – I will give this a try. Currently my host is playing up though so will
   have to be later 🙁
 *  Thread Starter [czrsink](https://wordpress.org/support/users/czrsink/)
 * (@czrsink)
 * [21 years, 1 month ago](https://wordpress.org/support/topic/problem-with-database-error-on-fresh-install/#post-187753)
 * Woo YAY! It’s worked! Many thanks!

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

The topic ‘Problem with Database error on fresh install’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 2 participants
 * Last reply from: [czrsink](https://wordpress.org/support/users/czrsink/)
 * Last activity: [21 years, 1 month ago](https://wordpress.org/support/topic/problem-with-database-error-on-fresh-install/#post-187753)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics