Support Forum
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
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.
YELLOW
SWORDFISH
|
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.
YELLOW
SWORDFISH
|
and thanks for the heads up... As andy says, we have a ticket open for investigation...
Visit Cruise Talk Central and Mr Papa's World
1 Guest(s)