How many posts do you have in the forum? If a lot then I would leave that section we removed out of the update as this can be a timeout issue we now know – on big pools of posts.
If the problem was caused by a script conflict then yes – just need to be careful. But if you have to modify the version and build numbers as you have done here I assure you there is no serious harm. The last section in the update is just a minor clean up that will have no negative effect if not performed.
Support Forum
Around 2000 posts. Ok thanks, will proceed with the upgrade on production side then in a few days.
9068 – success
Yellow Swordfish said
Excellent.You need the table ‘sfoptions’. This is NOT the wp options table please note.
Find the row with the option name of ‘sfversion’ and change the option value to 5.1.4
Find the row with the option name of ‘sfbuild’ and change the option value to 9150This should get you going and we can review the part of the script that caused the timeout later. But you will be safe to use the forums etc.
Please do let me know the outcome.
I sent these instructions to my host, who responded that there is no sfoptions table.
What script should we run to create these tables? Just sp-upgrade.php?
Thanks for the help—my forums are stuck in maintenance mode!
Not sure what to say here. If you have been running SP you must have an sfoptions table. SP cannot exist without it. Would be wp_sfoptions with wp_ being different on your install.
But I really doubt this ticket is related to yours. And if a host did not give me db access I would be gone super, super fast. That is just crazy.
But we need to figure out why your server generated an error Have you checked the server error log for any more info? How many sp posts do you have?
Using firebox with firebug or your browser of choice with its dev tool, when you click on upgrade, are any errors shown in the console?
Thanks for the reply, Mr Papa.
Believe me, if i had a choice we would not have moved hosting. I checked our previous host, and you’re right: wp_sfoptions does exist.
I checked for errors while trying to update, and no errors were thrown. I had firebug’s error console up.
I’ve responded to my host with the revised table name, we’ll see if that works.
What version were you on? Build and version have been stored in there for some time. Without them, not sure how we would even tell you an update was available.
So in firebug console, you should have seen some Ajax status lines show up after hitting upgrade. Can you expand the last one and see the response?
Mr Papa said
What version were you on? Build and version have been stored in there for some time. Without them, not sure how we would even tell you an update was available.So in firebug console, you should have seen some Ajax status lines show up after hitting upgrade. Can you expand the last one and see the response?
I was on 5.1.3. My host finally found the table and rows and made those edits in post 6 of this thread. My forum is now responsive again and I can get back to working. I haven’t launched the forum yet so there’s only like 10 or so posts.
Sorry i wasn’t able to get the firebug ajax bugs, it was my first time using it and apparently didn’t know where to look. Next time i run into problems, i’ll try to expand the ajax status line and give you some useful information to help me with.
Cheers!
Perhaps related to this or then not: in sp-site-support-functions.php line 136 there is
$current_version = $log[0]->version;
Should this be
$current_version = $log[0][‘version’];
?
(don’t know about this myself, but got this report from our theme developer).
Oooh – good catch. Yes that is indeed wrong.
Thanks very much for that. I will get it corrected for the next update