Did you run the upgrade script. It’s Step 2 here.
Makes me think the new terms database tables didn’t get created.
If necessary, try forcing a database upgrade.
If that doesn’t work you might have to restore to your database backup and do the upgrade again.
See:
How do I force a database upgrade?
I am getting somewhat similar errors when posts or comments are published…
I got this error when I tried to write a comment to one of my posts:
WordPress database error: [Table ‘whatwedig.wp_post2cat’ doesn’t exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = ‘publish’ GROUP BY cat_ID
I tried to force a database upgrade, but got this error:
WordPress database error: [Table ‘whatwedig.wp_categories’ doesn’t exist]
SELECT * FROM wp_categories ORDER BY cat_ID
WordPress database error: [Table ‘whatwedig.wp_post2cat’ doesn’t exist]
SELECT * FROM wp_post2cat
WordPress database error: [Table ‘whatwedig.wp_link2cat’ doesn’t exist]
SELECT * FROM wp_link2cat
Then I just noticed in my Manage Posts Page, the last post I posted says under the Category Column:
WordPress database error: [Table ‘whatwedig.wp_categories’ doesn’t exist]
SELECT categories.cat_ID FROM wp_categories as categories WHERE categories.category_nicename = ‘blog’ LIMIT 1
Everything is still posting and the site works fine, but users are redirected to these error pages when posting comments. Any thoughts?
I am getting somewhat similar errors
Not true.
Your error is completely different and it is addressed in one of the “sticky” posts on the main page of the forum.
Thanks, I checked it out and I had not updated Google Site Maps.
Thanks!
OK…I ran the “Forced Upgrade” and upon successful completion was presented with the following:
———————————————–
WordPress database error: [Table ‘affbiz_wrdp1.wp_categories’ doesn’t exist]
SELECT * FROM wp_categories ORDER BY cat_ID
WordPress database error: [Table ‘affbiz_wrdp1.wp_post2cat’ doesn’t exist]
SELECT * FROM wp_post2cat
WordPress database error: [Table ‘affbiz_wrdp1.wp_link2cat’ doesn’t exist]
SELECT * FROM wp_link2cat
Upgrade Complete
Your WordPress database has been successfully upgraded!
———————————————–
Note that is also says the db was successfully upgraded….
Next task?
And thank you for taking time out of your day to help me–you are appreciated.
I began deactivating plug-ins and have managed to get all of the on-page visible code to go away except one instance-in the top left corner-that says:
‘WordPress database error: [Table ‘affbiz_wrdp1.wp_categories’ doesn’t exist]
SELECT * FROM wp_categories
‘
Do I just continue deactivating plug-ins?
Thanks much!
jjh
There is no wp_categories table in WP 2.3 – so it must be either a plugin or a line of custom code calling for that table.
It might simply be the theme is not compatible with 2.3
Moshu…
I’ve deactivated each and every plug-in. I’ve even removed some of the suspect ones using phpMyAdmin/wp_options.
As of right now I have no plug-ins activated and maybe 5 total are even uploaded/installed.
Theme is 2.3 compatible…
What next?