SQL Error During Successful install (5 posts)

  1. snafu
    Posted 11 years ago #

    Hey, got it sorted. My 'admin' hadn't given me permissions to edit tables in sql.

  2. Anonymous
    Posted 11 years ago #

    Hi hope you can help. I have 2 problems on my upgrade to 1.2 which I am doing as a complete reinstall. Problem 1 is a mysql error as follows.
    'Database error: [Unknown column 'post_date_gmt' in 'where clause']
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2004-05-02 22:53:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 20'
    It seemed to install OK. As far as I can see in phpadmin it all seems OK but
    mysql and php are not my thing.
    I am atthe404

  3. Anonymous
    Posted 11 years ago #

    I have had a look at the table wp-posts and there is no post_date_gmt. Could that be the cause of it. If so where do I alter the code please?

  4. Anonymous
    Posted 11 years ago #

    Well I solved the post_date_gmt problem. Even on a new install we need to run wp-admin/upgrade.php. All running smoothly now.

  5. Anonymous
    Posted 10 years ago #

    I had the same problem, 'Database error: [Unknown column 'post_date_gmt' in 'where clause'] blah blah
    Running wp-admin/upgrade.php took care of the problem. Thanks

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.