Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Upgraded simple press before wordpresss... OOOPS
Avatar
MrWizard
Member
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 5:40 pm

I accidentally upgraded all of my simple press stuff before I upgraded to wordpress 3.6

How can I roll back to simple press 5.2 and then get this upgrade to work... right now I keep getting an error when I try to perform the upgrade.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:13 pm

what error?

the only way to roll back to 5.2.6 is to restore the db backup you made before the upgrade (per wp and our recommendations)...  db changes prevent you going back to old code...

Avatar
MrWizard
Member
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:17 pm

@mrpapa Check out this screenshot:

https://www.dropbox.com/s/snmk.....7%20PM.png

If I deleted the forum and then reinstalled it, would I lose all of my members and content?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:20 pm

okay, confused...  thought you updated sp first?  no?  have you updated wp yet (appears so)?

that error is the first script upgrade in the upgrade process...  its attempting to alter a table to add a column...  are you sure that your db user has alter table permissions?  might need to ask your host... very standard/normal for it to, but some hosts get wonky...

Avatar
MrWizard
Member
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:24 pm

Yes, I updated simple press first... unfortunately.  Alter table permissions?  I don't see any reason why I wouldn't have that permission, but I can check.  This is an issue that I would bring to my OVC dedicated server folks?  Would deleting simple press and reinstalling kill everything and remove all of my content or would that be a potential fix?

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:28 pm

yes, uninstalling simple press would delete all your existing forum data...

yes, ask your server hosts...   most hosts give it to users by default, but a handful do not...  you want to ask them if your mysql db user has the alter table permissions...  the upgrade script is trying to run an alter table mysql query and its failing...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:29 pm

and btw, I dont think it has anything to do with the sp or wp upgrade order... definitely not if alter table permission issue...

 

Avatar
MrWizard
Member
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:32 pm

Ok... so I didn't screw up majorly by upgrading out of order?

I guess that I just need to wait and see if I have that permission set up.... otherwise I don't even know if a reinstall would work.

Is there any folder or series of folders that I can save via FTP and drop back into place to keep all of my forum data if a reinstall is necessary?

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:38 pm

no... your forum data is all in the db... hence why you WordPress and us recommend making a db backup before upgrading...  really for all plugins you should do this (but we all get lazy at times)...

so if you want your data, grab a db backup...

I assume you have tried the sp upgrade multiple times?

one more time with the browser console open and seeing the ajax response might provide more data too...

Avatar
MrWizard
Member
Free Members
sp_UserOfflineSmall Offline
Aug 3, 2013 - 6:41 pm

browser console?  Give me some more info on that and I'll do it right away!

I backed up my site yesterday, but I've done a lot of work on it since.  I would love a rollback to be the last possible resort here. 

If I do a database backup now and THEN delete simple press, would that have the same benefit or not at all?

 

 

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625