WordPress.org

Ready to get started?Download WordPress

Forums

Database error when publishing post (3 posts)

  1. BJ05
    Member
    Posted 6 years ago #

    I just upgraded to 2.3 without a problem using the usual protocol, but when I write a post and "publish" it, I get the following error message.

    `WordPress database error: [Table 'fronter_mextruck.wp_categories' doesn't exist]
    SELECT c.cat_ID AS ID, MAX(p.post_modified) AS last_mod FROM wp_categories c, wp_post2cat pc, wp_posts p WHERE pc.category_id = c.cat_ID AND p.ID = pc.post_id AND p.post_status = 'publish' AND p.post_type='post' GROUP BY c.cat_id

    However, the post shows on the blog as it is supposed to, in the proper category in which it was placed.

    I'm bumfuzzled!

  2. Dion Hulse
    WordPress Dev
    Posted 6 years ago #

    the wp_categories table is no longer used by wordpress, Most likely you have a plugin installed which is not compatible.

    The Google XML sitemaps plugin is a common one which would produce that error, See this list for other possibilities:
    http://codex.wordpress.org/Plugins/Plugin_Compatibility/2.3#Non-working_plugins.2C_or_has_issues

  3. arnee
    Member
    Posted 6 years ago #

    Upgrade the Google Sitemaps plugin and any other plugins which use the old category tables.

    Compatible plugins: http://codex.wordpress.org/Plugins/Plugin_Compatibility/2.3

    Google Sitemaps Plugin: http://wordpress.org/extend/plugins/google-sitemap-generator/

Topic Closed

This topic has been closed to new replies.

About this Topic