Wordpress 2.1 (Ella)
Published 1.23.2007 by ~mattg
I downloaded and installed Wordpress 2.1 (Ella) today. The only problem I ran into was most definitely my fault, but I thought I’d jot down the problem and solution.
Since I have a script that backs up my site (database and content) every night, I already had the backups. So I download the tarball and unpacked it over top of my current install. I then ran the upgrade script. When I clicked Upgrade, I got a bunch of errors about not being able to run Alter Table scripts. As it turns out, I didn’t give my db user Alter Table privileges. Silly me.
So I fired up phpMyAdmin and granted my db user alter permissions. I then re-ran the upgrade script, but I still got errors (specifically, it was looking for the link_count field in wp_categories). I poked around the wordpress code until I found the database schema definition. As it turns out, re-running the upgrade did not alter one of the necessary tables, so I was missing a few fields.
Luckily, phpMyAdmin makes it easy to tack on some fields, so I did just that and I was up and running. I made sure I gave my db user alter privileges to the database for Deuce’s Wild, so I had no such problems in updating that side of the site.
Filed under Linux
