WordPress.org

Support

Support » How-To and Troubleshooting » Unknown column ‘category_nicename’…

Unknown column ‘category_nicename’…

  • 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”)

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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?

    HELP!

    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.

    Help?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Unknown column ‘category_nicename’…’ is closed to new replies.
Skip to toolbar