Unknown column 'category_nicename'... (3 posts)

  1. offlander
    Posted 10 years ago #

    Just installed WordPress on one of my TextDrive accounts and am getting the following error at the bottom of the page when I click on one of the category links. The error changes to 'category_id' if I don't include a SEF URL setting. I looked at the wp_posts table and indeed both category columns are missing.
    Couldn't find a way to deactivare PHP error messages in the admin. Here's the error:
    Database error: [Unknown column 'category_nicename' in 'where clause']
    SELECT COUNT(ID) FROM wp_posts WHERE 1=1 AND (category_nicename = 'ramblin') AND post_date_gmt <= '2004-10-21 07:37:59' AND (post_status = "publish")

  2. pIng
    Posted 10 years ago #

    Almost related... I moved my blog to a new server by copying the db. I then copied all of the WP files in to the blog directory, changed the configuration to point to the new DB location.. and presto! It worked.. i thought.

    One one of the blogs, I get an error when I try and post: Database error: [Unknown column 'post_date_gmt' in 'field list']

    On both "moved" blogs, I get parsing errors on the rss feed pages.

    Any ideas how I can get this fixed?

  3. pIng
    Posted 10 years ago #


    I'm an idiot. I have no clue.. all I know is that my admin moved our blogs to a new server.. and installed the latest WP drop.. and now we get this:

    Database error: [Unknown column 'post_date_gmt' in 'where clause']
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-02-10 07:29:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 10


    I know that my old DB had been customized by our host for me, but I don't know what was done.

    I just want help importing my sql data files (we dumped the data and structure to files) into my new install of WP.


Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.