CiviCRM Community Forums (archive)

I've encountered a bizarre and catastrophic problem with search.  A large portion of my custom fields are no longer searchable--that is to say, they ARE configured as searchable, and the entry fields DO display in the advanced search screen, BUT they cannot be used to return any results.  Here are the symptoms:

1. Any range-based search for a custom NUMBER or MONEY field works the same as running a blank search--i.e. they always return ALL records.
2. Alphanumeric fields remain searchable.
3. A drop-down menu search of a number field works.
3. Custom search views display ALL custom fields as blank (see attached).
4. All data is still available in the profile view--this is the only context in which custom number and money fields can be viewed at all.
5. Smart groups based on number fields display all records when searched.
6. Custom data cannot be exported (this is the worst part, because it means my data is trapped)

Please, someone help!

1. can u upgrade to 2.2.6

3. did this work before, if so what version?

I'm a little uncomfortable upgrading without the ability to first backup through export.  Otherwise, I'm relying on the hope that the mySQL data will be readable to the new install of civiCRM.

2.2.2 is the only install I've ever had, and these searches have always worked fine as far as I know until this week.

2. can u reproduce the same issue on demo and see if it is a bug in the core code

I created an identical field on the demo site, and the error did not reproduce.

Worked like a charm.  Thanks!