Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
"Upgrade Aborted" error - forum unavailable!
Avatar
Chris Buckley
Manchester, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 17, 2014 - 11:16 am

Just updated the plugin and then pressed the "Perform Upgrade" button, and getting a page full of error messages, the first one being this:

 

Upgrade Aborted

current build: 11493

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''wp_sfadversaries' at line 1 for query SHOW TABLES LIKE 'wp_sfadversaries made by require('C:Inetpubvhostsaihhp.orghttpdocswp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include('C:Inetpubvhostsaihhp.orghttpdocswp-contentpluginssimple-presssp-startupinstallsp-upgrade.php'), sp_rebuild_table_list, spdb_select WordPress database error

 

This is what I'm trying to upgrade from:

Upgrade Simple:Press From Version 5.5 to 5.5.1

(Build 11487 to Build 11910)
 

How can I fix this?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 17, 2014 - 11:27 am

My my my you found a bug and how odd is it that nobody has found it already after many, many weeks of 5.5.1 upgrades!

Apologies.

Are you willing and up for making a small code edit to get you going again?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Chris Buckley
Manchester, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 17, 2014 - 11:32 am

Thanks for the quick reply.

 

Yes ready and willing to make any code changes.

PS. I've attached the full list of errors that are appearing, if it helps.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 17, 2014 - 11:38 am

Try this.... the file to edit is at /simple-press/sp-startup/install/sp-schema.php

The line that needs editing is at line number 149 - about two thirds of the way down. It currently looks like this:

$found = spdb_select('var', "SHOW TABLES LIKE '$table");

and it should be:

$found = spdb_select('var', "SHOW TABLES LIKE '$table'");

Now it is a little hard to see from this by after the $table variable near the end there is currently a double quote. There should be a single quote before it.

Feel bad about this - that's a beginners mistake! I guess the reason it hasn't shown up is that most people (and you really ought to) hide these error messages.

Again - sorry for this. Please let us know how this goes...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Chris Buckley
Manchester, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 17, 2014 - 12:05 pm

Works perfect! Thanks :)  

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 17, 2014 - 12:13 pm

Good stuff!

Avatar
Chris Buckley
Manchester, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 22, 2014 - 12:08 pm

Hi,

Our users are reporting problems accessing the forum since we made the above fix. The forum is saying "Access denied - you do not have permission to view this page", when trying to view a thread.

Also the following warning appears too "Warning: The function sp_build_qurl() has been deprecated and will be removed in a future update. Use WordPress function add_query_arg() instead. in C:\Inetpub\vhosts\aihhp.org\httpdocs\wp-content\plugins\simple-press\sp-startup\site\sp-site-deprecated.php on line 73."

 

Users are currently unable to post anything as a result. Hope you can help.

Thanks.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 22, 2014 - 3:10 pm

Are you using any caching plugins?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Chris Buckley
Manchester, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 22, 2014 - 4:33 pm

Nope.

The site is http://www.aihhp.org/, and the forum is at http://www.aihhp.org/forum-2/.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 22, 2014 - 10:41 pm

what version of sp?  it appears you have some sp plugins that are out of date...  and an old version is still calling a function that has been deprecated...

btw, you really shouldnt be showing notices and warnings on a production site...  best to hide those...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 643
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17343
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79590