That meant I had to hack the installation script a bit to get the database upgraded. Not too bad but not something everybody can do obviously. I'll have to figure a better way around that.
Next problem occurred during the install program. The upgrade procedure will create a new admin user, NewAdmin, with sufficient rights to administer the site. Well you have to have records in the userindex, userprefs and usercomment tables for that user or else the session code will bomb.
After that it was just a matter of changing the blocks to be in the right order and life was good! We'll be formatting the site a bit over the next few days to make it a bit purtier but other than that I'm pretty happy!
What do you think?