Support Forum

"Upgrade Aborted" error – forum unavailable!

CB Chris Buckley
Chris Buckley
Member
Member since Nov 2012
18 posts
Oct 17, 2014 · 11:16 am · Edited

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?

11 Answers

New Answer
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
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?

CB Chris Buckley
Chris Buckley
Member
Member since Nov 2012
18 posts
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.

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
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…

CB Chris Buckley
Chris Buckley
Member
Member since Nov 2012
18 posts
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:Inetpubvhostsaihhp.orghttpdocswp-contentpluginssimple-presssp-startupsitesp-site-deprecated.php on line 73.”

 

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

Thanks.

CB Chris Buckley
Chris Buckley
Member
Member since Nov 2012
18 posts
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/.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
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…

CB Chris Buckley
Chris Buckley
Member
Member since Nov 2012
18 posts
Oct 23, 2014 · 4:24 am

Latest version of WordPress (4.0), and 5.5.1 of Simple:Press.

I think the problem was outdated SP plugins, thats something I overlooked. Just updated them and it seems fine again now, thanks.

Regarding the error messages, we have:
define(‘WP_DEBUG’, false);

 

What else would be causing the site to display them? All the PHP settings are left on default.

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Oct 23, 2014 · 4:41 am

Great news.

If you are seeing warnings and notices on the display then it will be coming from your site php.ini file settings. If you have access to these search for the error block – they are well documented. If no access then I would check with your host. Not only do these messages disrupt the display but they also reveal your server path.