1.5.1.3 to 2.2 Headaches

The time came to upgrade, because my server was complaining about too many database queries per hour.

So… I checked my PHP and SQL versions:

PHP 4.4.1
MySQL 4.0.16

I backed up my blog (thank God!).

I changed the files over.

I ran the update.php. It didn’t work. I got an “Unknown column ‘post_type’ in ‘where clause'”

In fact, I got one of these on nearly every element of the blog — the header, the sidebar items, the footer too if I recall correctly. Update.php just wasn’t gonna run.

I restored everything from backup.

On coming back, Akismet is broken, which is a pain because I can’t get a version of Akismet that works with WP 1.5.1.3 anymore.

So all I’ve gotten for my efforts were several wasted hours and now tons and tons of spam.

Can anyone help? With any of these concerns? I’d really appreciate it, and I’d sing your praises from my blog.