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.
Thanks for documenting your problem and the solution!
“As conclusion for me I will remember to not update file by file but using all the files from the download archive.”
Either that, or you could install instant-upgrade and forget all about updates 😉 but of course not about backups.
http://www.zirona.com/software/wordpress-instant-upgrade
Abdul, I don’t want to run an upgrade of WordPress by a plugin. In such a case all the files have to be writable by the web server and my blog could be attacked by malicious scripts if holes in WordPress are known. Anyway thank you for that information.