SQL Database gimped

  • After the upgrade from 2.2 to 2.3, numerous errors have happened for me. Right now, I am unable to change the category of any posts with the “manage, category” function.

    For whatever reason, there is something in the SQL database which is still referencing the wp_categories table which I believe was changed in 2.3. I did the regular upgrade routing and it seemed to work ok, and I’m not using any plugins to manage the categories – just simply editing an existing post and trying to ‘re-categorize’ it which produces the following error.

    WordPress database error: [Table ‘gymskinz_blog.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

    any way to fix this easily? Or should I just wipe the entire thing and start from scratch again with a brand new 2.3 install (?!?!)

    thanx
    T.

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL Database gimped’ is closed to new replies.