Kus’ Blog

I must confess, I got into troubles while upgrading the installation of this wordpress.

Seems impossible how a such easy and user-friendly piece of code as wp is can go wrong and mess a little, just a little. Here it comes my little pain in the ass…

In this this story I’m much responsible as wp upgrade thing. When I created this hosting account and created a new mysql user for my blog I gave it limited grants to only select, insert, update and delete. When I got the upgrade of course it tells me that it has to upgrade my database, sure why not, help yourself wp! And here they are! lots of error of access denied while trying to alter or create tables in the database…

1st Round: Result, blog showing sql errors…

I quickly give my user the proper perms to let it make anything, then go to upgrade one more time and… what? Database is up-to-date… Uhm… You did it wrong wp…

A little ‘vim’ here and there and a solution was found. It seems that the upgrade.php script in wp don’t detects well access denied errors type and it updates the db_version option, that is located at wp_option table of your wp database. So I had to manually “downgrade” its value to let upgrade script rerun again.

Now everything is ok and posting.