Problem with Database error on fresh install

  • czrsink

    (@czrsink)


    21 years, 1 month ago

    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

    (@coldforged)

    21 years, 1 month ago

    A search turned up this. Try that?

    Thread Starter czrsink

    (@czrsink)

    21 years, 1 month ago

    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

    (@coldforged)

    21 years, 1 month ago

    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

    (@czrsink)

    21 years, 1 month ago

    Thanks – I will give this a try. Currently my host is playing up though so will have to be later 🙁

    Thread Starter czrsink

    (@czrsink)

    21 years, 1 month ago

    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.