[wp-trac] [WordPress Trac] #17004: Apostrophe in first/last/nickname causes JS error on user profile page
WordPress Trac
noreply at wordpress.org
Wed Aug 23 15:30:35 UTC 2017
#17004: Apostrophe in first/last/nickname causes JS error on user profile page
-------------------------------------------------+---------------------
Reporter: johnbillion | Owner:
Type: defect (bug) | Status: closed
Priority: normal | Milestone: 3.1.4
Component: Administration | Version: 3.0
Severity: minor | Resolution: fixed
Keywords: has-patch needs-testing fixed-major | Focuses:
-------------------------------------------------+---------------------
Comment (by info2grow):
Still having this problem, could it be a BuddyPress issue? It's show up
in the user table (nicename) and usermeta (last_name).
Was this fixed?
{{{
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 'sullivan%' OR user_nicename LIKE '%louise o\\\\'sullivan%' OR
display_name LIKE '%' at line 1 for query SELECT SQL_CALC_FOUND_ROWS
DISTINCT u.ID as id FROM SERVMASK_PREFIX_users as u LEFT JOIN
SERVMASK_PREFIX_usermeta as m2 ON u.ID = m2.user_id WHERE ( user_login
LIKE '%louise o\\\\'sullivan%' OR user_nicename LIKE '%louise
o\\\\'sullivan%' OR display_name LIKE '%louise o\\\\'sullivan%' OR
user_email LIKE '%louise o\\\\'sullivan%' )
}}}
--
Ticket URL: <https://core.trac.wordpress.org/ticket/17004#comment:21>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform
More information about the wp-trac
mailing list