With any luck, this website has been restored to a pristine state. Here’s what happened:
As I have mentioned before, I use the Subversion update process to keep my WordPress installs up to date. WordPress 2.8 was recently released, so I set out to update my sites, starting with this one. Unfortunately, the update failed for reasons I still don’t understand. Switching to 2.8 with Subversion appeared to go successfully, and the site looked alright after updating, but the admin panel was completely unusable. I tried a number of workarounds, none of which worked. I ultimately rolled back to 2.7.1, but noted that WordPress wanted me to ‘upgrade’ my database again. Given that I don’t know what goes on during this process, and seeing as I was actually ‘downgrading’, I wasn’t sure what state the database was left in. I tried upgrading a second time with no luck, and rolled back yet again.
I was able to successfully update a few other websites that I run on WordPress, so the problem was clearly with this particular domain. As an ultimate fix, I created a brand new database, installed a brand new copy of WordPress 2.8, and imported all of my old data. I had to do some database massaging to get things back to their desired state (official comments weren’t marked, for example), but things should hopefully be back to normal.
This entire process has yielded a few overall site improvements:
- This site now runs on a MySQL 5 database instead of MySQL 4.
- Since this site is rather old, the base WordPress configuration files were terribly out of date; they have now been updated.
- A few other behind-the-scenes changes have been made to make my life easier.
See something that’s broken? Let me know! It’s my hope that everything is operating as it once did. I know that my contact form works, as I tested it earlier this evening. It’s my hope that this problem doesn’t crop up again. Let this be a lesson; back up your website early and often! I’m glad I did.