Yet another quick upgrade session and we are now happily running WordPress 2.1.1. Same steps as before but this time I ran into a small problem because apparently my user account is lacking the proper privileges to alter tables. And although I have been granted the right to change my privileges I seem to lack the required privilege to flush them.
So even though the upgrade script seemed to run fine it did not manage to update the categories table and now the categories box in the admin is telling me the link_count column is missing. I could easily add it but I also seem to be missing the alter table privilege and until root comes on-line to flush the new settings for me there is nothing much I can do about it.
Fortunately though WordPress seems pretty robust and I did not spot any other problems although I have yet to inspect the upgrade script to determine all the other missing columns. There are bound to be other things that have failed.
Also got a new theme. Did not really like the old one anymore and besides, it lost most of its glory since I had to remove the spam counter after the previous upgrade. The blog is now using the Pool theme by Borja Fernandez although I changed the header logo and added some left padding on the numbered lists. I also had to change the background color of the static pages layer just below the header to better fit with the palette of the new image.
UPDATE 13:37 – My good friend and FreeGW admin Sven just came on-line and was kind enough to flush the privileges for me. I managed to fix the link_count error and also stumbled upon a few more missing columns. However, adding them was a piece of cake using the upgrade-schema.php file as a reference.