CiviCRM Community Forums (archive)

I'm wondering if folks have experienced this situation before? We are getting a "Sorry. A non-recoverable error has occurred. Could not get details for custom search." when we try to manage a Smart Group and View Contacts in that group.

We have a smart group that consists of both individuals and organizations, donors, and new contacts in the database who have either made a contribution in the last 3 years or have been added to the civicrm database in the last 3 years.  Rather than rely on specific date ranges, the smart group relies on a user created custom query to choose donors & new contacts who've been added or donated from the current date minus 3 years.

This Smart Group was used for a couple postal mailings a few months ago, when the number of contacts returned was around 3000+.

Now this smart group should be returning approximately 4500+ contacts.  Instead, when you "Manage Contacts > Contacts" to view the list of contacts, we get (with backtrace turned on)

backTrace (specific path changed back to generic values for purpose of this message)

/var/www/members/sites/foobar.org/modules/civicrm/CRM/Core/Error.php, backtrace, 296 /var/www/foo/sites/foobar.org/modules/civicrm/CRM/Contact/Form/Search/Custom.php, fatal, 58

Sorry. A non-recoverable error has occurred.
Could not get details for custom search.


It appears the smart group SQL has lost the Id# of the user generated custom query.

Aren't smart groups supposed to be able to work with custom queries?

The UI doesn't provide any method to edit the query used to generate the group, which is disappointing.

Client is on Drupal 6.19, MySQL 5.1.51, PHP 5.2.14, CiviCRM 3.4.4

Thanks,
-MaryKay