Support Forum

Database Errors

JW Jonah West
Jonah West
Member

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

5 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

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.

JW Jonah West
Jonah West
Member

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

YS Yellow Swordfish
Yellow Swordfish
Member

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.

JW Jonah West
Jonah West
Member

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

MP Mr Papa
Mr Papa
Member

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