[buddypress-trac] [BuddyPress Trac] #5919: Xprofile field meta values not deleted with field

[buddypress-trac]

#5919: Xprofile field meta values not deleted with field
--------------------------+------------------
 Reporter:  tometzky      |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  high          |   Milestone:  2.2
Component:  XProfile      |     Version:  2.1
 Severity:  major         |  Resolution:
 Keywords:  needs-patch   |
--------------------------+------------------

Comment (by boonebgorges):

 In [changeset:"9073"]:
 {{{
 #!CommitTicketReference repository="" revision="9073"
 Better detection for false positives in meta SQL filters.

 Our wrappers for WP's _metadata() functions require some filtering of the
 SQL
 string (to change a column name and, in the case of xprofile, to add an
 'object_type' clause). Our str_replace() logic is too generous, creating
 the
 possibility of matching quoted text, as when the meta value contains the
 string
 'WHERE'.

 This changeset modifies the filters so that quoted content is swapped out
 with
 placeholders before we run our search-and-replace.

 See #5919.
 Props tometzky for feedback.
 }}}

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5919#comment:11>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac