Support Forum
Support Forum
Offline
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?
Offline
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?
 |
YELLOW
SWORDFISH
|
Offline
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.
Offline
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...
|
YELLOW
SWORDFISH
|
Offline
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.
Offline
Are you using any caching plugins?
|
YELLOW
SWORDFISH
|
Offline
Nope.
The site is http://www.aihhp.org/, and the forum is at http://www.aihhp.org/forum-2/.
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)