What a waste of a few hours. Finally, I decided to upgrade my personal blogging site, running stuff, from Drupal 5.x to Drupal 6.x. The actual figures are from Drupal 5.15 to Drupal 6.10. I stripped the site back to the bare basics, removed all contributed modules that weren't absolutely necessary and back to the default theme, Garland. According to the update status, for version 5.x, everything was up to date.

I'm patting myself on the back in one regard in that I did a backup prior to upgrading.

Anyway, what a waste of time. Heaps and heaps of database errors, just too many to casually attempt to fix. I don't know how people survive without requisite database skills as now this has turned into a major upgrade, if I'm willing to upgrade after all. It's a problem I could overcome but it's now a decision whether I could be bothered putting the time into it.

Thank god for backups. Restoring the backup went through smoothly, within about 5 minutes, maybe a tad longer, my site is as it was hours earlier.

If anyone has some suggestions to ease the pain a little I'd love to hear from you. In my mind, I'm thinking that maybe the backup should go from Drupal 5.15 to Drupal 6.1 and then do all the necessary updates to the current version of 6.10.