stuck in maintenance mode? wp is? or do you just mean the forum is awaiting upgrade?
have you tried it a second time?
so that first upgrade it seems to be failing on is an update to a mysql table... can you verify that your mysql user on your server has 'alter' permissions?
Thanks for getting back to me so quickly...
The forum is stuck in maintenance mode (www.stayathomemum.net.au/forum) so yes, awaiting upgrade. The problem is though, the upgrade won't work so now it's stuck. I've tried it many times, probably about 10 now. From different accounts as well. The mysql user is the administrator and has 'alter' permissions.
This is exactly what happened:
1) Clicked "upgrade" from the plugins menu
2) waited until upgrade was completed and plugin was reactivated.
3) I then USUALLY click on upgrade database, but instead for some reason i went back to the plugins page.
4) realised i'd done this and then clicked upgrade from the forum side panel menu
5) got the error as attached
6) got really frustrated
Any ideas? Should I create you an account?
the process you followed was just fine...
you are going to have to check with your host and see if your mysql user has 'alter' permissions... it seems to be failing when trying to alter the mysql table... some hosts mistakenly dont give users that permission...
since the database has not been upgraded, you could delete the simple press plugin from plugins dir (do NOT uninstall) and then upload the old 5.0.4... but if you keep 5.0.5 there, it will expect the database changes...
we have done alter statement in previous upgrades, but not frequently...
can you check your error log? perhaps some more information in there like maybe running out of php memory... see this topic:
for a quick way to increase your php memory and see if that helps...