CiviCRM Community Forums (archive)

A client of ours we recently upgraded to CiviCRM 4.3.4 on Drupal 6 as that was as far as we could upgrade them on their legacy server. (The incremental update for 4.3.5 caused a MySQL crash with their old version of MySQL, so we ended up leaving well enough alone until the site moves to the new server. At that point we will upgrade the rest of the way to current release.)

Anyway, 4.3.4 appears to have broken the ability to search contributions based on a custom field which is a pick list of values. Specifically there is one value in the pick list with a single quote character (Children's) as the word is suppose to be possessive.

I went searching through the database as to why that one pick list value is causing so much trouble. Other values of the one custom pick list field appear to work as expected, as at least searching with other criteria has a result set.

And since it is a combo box pick list, I am unable to escape the single quote character.

I noticed in the DB that the custom pick list values are verbatim statically duplicated over and over for each record needing to refer to the particular pick list value. I find the value stored in table "civicrm_value_solicitation_methods_3" field "purpose_56 varchar(150)".

May someone simply reply yea / nay as to if a single quote being contained within a custom field pick list value should be possible to search based on in CiviCRM 4.3.4? I would think that CiviCRM would itself need to be doing some sort of single quote safe search, or be escaping the single quote within the search string since CiviCRM has verbatim statically placed the actual value in the field.

I am thankful,

Greetings capo,

The search executes with an empty result set.

So, what steps are advised to clean up the single quote which is now in numerous records?

I do see the two fields you alluded to: Option Label and Option Value. Will CiviCRM retroactively adjust existing records if I remove the single quote from the Option Value?

I am thankful,