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…

It’s weird though… i’ve been upgrading like this ever since simple-press allowed it without any problems. Is there any way to “not upgrade” and go back to non-maintenance mode?

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:

http://wiki.simple-press.com/installation/troubleshooting/increase-php-memory/

for a quick way to increase your php memory and see if that helps…

if you want to send me account credentials (it has to be an sp admin account to do the upgrade) via pm, I can take a look, but if mysql user issue, not much I can do… but can check few other things…

Thanks i’ll try that. Where can i download the simplepress version 5.0.4?

thanks

all good found it

so everything working now?

I’ve had exactly the same problem in trying to upgrade to 5.0.5 Build: 8289.

I clicked the “update automatically” link on my plugins page, but ended up being stuck in a loop in the same way as the OP and had to downgrade via a backup to get things to work again. How should I go about implementing updates?

I believe it’s best to upload the new plugin, but do not activate it, you should first disable the old plugin, then either delete it by ftp of file manager. Then activate the new plugin and run the upgrade script. At least that’s how i have done it with no problems.

When checking the paths you might find some have a red x on them. I ended up copying the new directory structure with ftp and changed the paths so everything resided under wp-content/sp-resources/ copying the images, avatars, etc, then deleting the old directories for simplicity.

Here is the proper paths for SP-5.

check FidoSysOp stuff, but if exact same problem,  did you solve it the same way??  I would guess its not the exact same problem…

have you checked your server error logs? might be something simple like running out of php memory…

using firefox and firebug (or the editor and dev tools of your choice) with the console open, see what kind of ajax response  you get…  its probably failing and the error will be shown…

Sorry for the delay in replying!

Any suggestions appreciated! Should I try updating this in the same way as I updated to 5.0 in the first place, as Fido suggests, by disabling and then uploading replacement? Just seems like a lot of work for every update. As it is, I’m already slowing re-uploading the backup, just so I can have it there to disable in case there was a conflict during this update.

As it happens there was one line with an X beside it among the paths, but I fixed it, and was still not able to update.

The following was everything that I saw on Firebug in terms of AJAX responses.

This makes no sense to me, as I otherwise have never had such memory issues on my site. The following were also underneath it:

... Date().getTime());urlstringtemp=new Array();for(key in this.vars){if(false==thi...

...=function(){var credit=document.getElementById('plusCardCredit');credit.style.di...