A A A
Forum Scope


Match



Forum Options



Min search length: 3 characters / Max search length: 84 characters
Forum Login
Lost password?
general-topic
Tried to upgrade to 5.05 and now it's stuck on maintanence mode!
...View Related Tags
Avatar
stayhomemum
7 Posts
(Offline)
1
Apr 10, 2012 - 8:20 pm
Print

Please help, i’m caught in a loop!

I tried to upgrade (Upgrade Simple:Press From Version 5.0.4 to 5.0.5 – (Build 8189 to Build 8289)

and It says:

Upgrade Aborted
8189
8214
success

 

Now it’s stuck in maintanence mode. argh!

 

Please see the attached screenshot.

 

thanks,

 

Jodyforum-problems.jpgImage Enlarger

Attachments
Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
2
Apr 10, 2012 - 8:27 pm
Print

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?

Avatar
stayhomemum
7 Posts
(Offline)
3
Apr 10, 2012 - 9:00 pm
Print

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?

Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
4
Apr 10, 2012 - 9:09 pm
Print

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…

Avatar
stayhomemum
7 Posts
(Offline)
5
Apr 10, 2012 - 9:22 pm
Print

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?

Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
6
Apr 10, 2012 - 9:30 pm
Print

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/i…..hp-memory/

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

Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
7
Apr 10, 2012 - 9:31 pm
Print

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…

Avatar
stayhomemum
7 Posts
(Offline)
8
Apr 10, 2012 - 10:20 pm
Print

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

 

thanks

Avatar
stayhomemum
7 Posts
(Offline)
9
Apr 10, 2012 - 10:21 pm
Print

all good found it

Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
10
Apr 10, 2012 - 10:56 pm
Print

so everything working now?

Forum Timezone: America/New_York
All RSSShow Stats
Administrators: Blues Dancer, Simple Press, SP Community Support, Marcus (Simple:Press)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 630
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Newest Members:
Lorena Affleck
samantardh
PatrickAlawl
Hannelore Gaither
Margarito Nowacki
Elwood Mcclendon
samantaerx
Larue Cordeaux
Jerrold Stockman
Forum Stats:
Groups: 7
Forums: 17
Topics: 10071
Posts: 79393

 

Member Stats:
Guest Posters: 608
Members: 16976
Moderators: 0
Admins: 4

Most Users Ever Online
1170
Currently Online
Guest(s)
1
Currently Browsing this Page

1 Guest(s)