• 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 ). 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.