Title: WordPress database error – string should be escaped
Last modified: March 3, 2017

---

# WordPress database error – string should be escaped

 *  [Saša](https://wordpress.org/support/users/stodorovic/)
 * (@stodorovic)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/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->save
       ```
   
 * I just checked function save in `class/UamUserGroup.php`. You should add esc_sql(
   [https://codex.wordpress.org/Function_Reference/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.

 * ![](https://ps.w.org/user-access-manager/assets/icon.svg?rev=1563783)
 * [User Access Manager](https://wordpress.org/plugins/user-access-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-access-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-access-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/user-access-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-access-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-access-manager/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Saša](https://wordpress.org/support/users/stodorovic/)
 * Last activity: [9 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-string-should-be-escaped/)
 * Status: not resolved