WordPress database error – string should be escaped
-
We have some errors because french text contains apostrophe. Errors from debug.log:
[02-Mar-2017 13:29:18 UTC] 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 'un login et password.', read_access = 'group', ' at line 3 for query UPDATE wp_uam_accessgroups SET groupname = 'Client', groupdesc = 'Contenu uniquement accessible aux utilisateurs muni d'un login et password.', read_access = 'group', write_access = 'group', ip_range = '' WHERE ID = 1 made by edit_post, wp_update_post, wp_insert_post, do_action('save_post'), UserAccessManager->savePostData, UserAccessManager->_saveObjectData, UamUserGroup->saveI just checked function save in
class/UamUserGroup.php. You should add esc_sql ( https://codex.wordpress.org/Function_Reference/esc_sql ). Example:'groupname' => $this->_sGroupName, 'groupdesc' => $this->_sGroupDesc,should be
'groupname' => esc_sql( $this->_sGroupName ), 'groupdesc' => esc_sql( $this->_sGroupDesc ),It fixed our errors.
The topic ‘WordPress database error – string should be escaped’ is closed to new replies.