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
Database Errors
Avatar
Jonah West
Member
Free Members
sp_UserOfflineSmall Offline
Nov 3, 2015 - 12:30 pm

Hello,

We are running the latest version of WordPress 4.3.1 and SP 5.5.11

We are seeing a number of db errors in our logs:

-----------------------------------------

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 's Group";s:14:"usergroup_desc";s:0:"";s:15:"usergroup_badge";s:0:"";s:14:"usergr' at line 1 for query UPDATE wp_13_sfmembers SET memberships = 'a:1:{i:0;a:5:{s:12:"usergroup_id";s:1:"8";s:14:"usergroup_name";s:14:"Donald's Group";s:14:"usergroup_desc";s:0:"";s:15:"usergroup_badge";s:0:"";s:14:"usergroup_join";s:1:"0";}}' WHERE user_id=1273 /* From [symy2015.dharmaocean.org/forum/] in [/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php:292] */ made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array, call_user_func_array, sp_is_forum_page, sp_load_current_user, sp_get_user, spUser->__construct, sp_update_member_item

-----------------------------------------

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 's Group";s:14:"usergroup_desc";s:0:"";s:15:"usergroup_badge";s:0:"";s:14:"usergr' at line 1 for query UPDATE wp_13_sfmembers SET memberships = 'a:1:{i:0;a:5:{s:12:"usergroup_id";s:2:"11";s:14:"usergroup_name";s:15:"Lisette's Group";s:14:"usergroup_desc";s:0:"";s:15:"usergroup_badge";s:0:"";s:14:"usergroup_join";s:1:"0";}}' WHERE user_id=1168 /* From [symy2015.dharmaocean.org/wp-admin/admin-ajax.php] in [/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php:292] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, sp_load_current_user, sp_get_user, spUser->__construct, sp_update_member_item, referer: http://symy2015.dharmaocean.org/bodhisattva-vow-information-meeting/

-----------------------------------------

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 's Group";s:14:"usergroup_desc";s:0:"";s:15:"usergroup_badge";s:0:"";s:14:"usergr' at line 1 for query UPDATE wp_13_sfmembers SET memberships = 'a:1:{i:0;a:5:{s:12:"usergroup_id";s:1:"8";s:14:"usergroup_name";s:14:"Donald's Group";s:14:"usergroup_desc";s:0:"";s:15:"usergroup_badge";s:0:"";s:14:"usergroup_join";s:1:"0";}}' WHERE user_id=1273 /* From [symy2015.dharmaocean.org/forum/] in [/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php:292] */ made by require('wp-blog-header.php'), wp, WP->main, do_action_ref_array, call_user_func_array, sp_is_forum_page, sp_load_current_user, sp_get_user, spUser->__construct, sp_update_member_item, referer: http://symy2015.dharmaocean.org/program-content/unit-3/

-----------------------------------------

Any idea what this could be?

Thanks!

- Jonah

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 3, 2015 - 12:37 pm

I am sorry to say that it is those grammatically correct apostrophes in the group names. We had problems with those and php serialised data before.
I know it hurts but I would take them out - apologise to everyone about the bad grammar - and I will open a ticket to get it looked at. But it might be a real nasty one to try and fix.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Jonah West
Member
Free Members
sp_UserOfflineSmall Offline
Nov 3, 2015 - 12:38 pm

Thanks for the speedy reply! Aside from the errors popping up, would these cause any other issues on the site?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 3, 2015 - 12:43 pm

They might cause some odd issues with user group membership identification. After you have removed the apostrophe and re-saved the user group record - go to the forum toolbox > housekeeping and run the 'reset auth cache' task.
It should then all correct itself. If it doesn't then come back and shout and we can double check. I would clear out the error log as well so you can keep an eye on it.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Jonah West
Member
Free Members
sp_UserOfflineSmall Offline
Nov 3, 2015 - 12:58 pm

Gotcha. We'll try that out. Thanks for the fix!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 3, 2015 - 10:20 pm

and thanks for the heads up... As andy says, we have a ticket open for investigation...

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: 639
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17342
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10116
Posts: 79581