Tuesday this week the brand-new WordPress 2.3 aka “Dexter” was released. There are some nice new features and changes which will enhance your weblog. I upgraded today to this version and was directly confronted with following error message:
WordPress database error: [Table '%table%.wp_terms' doesn't exist]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.term_id ASC
I searched the web to find a solution to my problem because I didn’t understand why that could happen while upgrading to a new release version but didn’t find a solution. Fortunately I made a database backup and imported all tables again to restore my pre-2.3 scheme. After making a diff between my files and the ones within the download archive I noticed that I forgot to copy some folders under wp-admin. After syncing all that files the upgrade runs smoothly. As conclusion for me I will remember to not update file by file but using all the files from the download archive.