[wp-trac] [WordPress Trac] #17004: Apostrophe in first/last/nickname causes JS error on user profile page

[WordPress Trac]

#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