Tuesday, November 6th, 2007
Upgrading to 2.3 breaks some plugins in Wordpress
“WordPress database error: [Table ‘mydatabase.wp_post2cat’ doesn’t exist]”
Recently, I’ve started receiving the above error message after I created my posts. A little unnerving, but it seemed to be alright. The site was running fine aside from the errors.
After trying to force an upgrade of my Wordpress Database - which did not work, I looked around a little more and apparently, the following tables have been removed from WordPress in it’s latest version 2.3:
- post2cat
- link2cat
- categories
The culprit was the google sitemaps plugin for Wordpress by http://www.arnebrachhold.de/ after deactivating this plugin, the error disappeared.
So if you are experiencing the same sort of issues and errors, the first place I’d suggest to look into is your plugins that may be using the “post2cat”, “link2cat” and “categories” Wordpress tables.
It’s times like these that make me wish that php had added Exceptions earlier. It would have been very easy to track this error down if I had a stack trace in front of me rather than having to do guess work debugging. Debugging someone elses procedural spaghetti is never an easy job.
For “quick debugging”, the next step would have been to place random “die” statements at key parts of the program to trap where the error was coming from. *shudder*
on Tuesday, November 6th, 2007 at 9:46 pm:
[…] database error: [Table ‘mydatabase.wp_post2cat’ doesn’t exist]” (see this post for the solution), but for those who may need to “force” an upgrade, this is how you do […]