CiviCRM Community Forums (archive)

Hi All,
I am fairly new to CiviCRM and am having a great time setting up 14k+ record contact database for a client of mine.
Currently I am using CiviCRM 1.8 on PHP5, linux/apache web server.

I had a request for contacts from two states (Kansas and Missouri) so I ran an Advanced Search for each state and created a smart group from the search results of each.   Now when I go to do a search, advanced search or search builder query, and select either or both of the two smart groups I get this error.(Twice if both groups are selected)

warning: Invalid argument supplied for foreach() in /var/www/core-id/drupal/modules/civicrm/CRM/Core/BAO/Mapping.php on line 683.

The search then returns *every* record in the database.

My first thought is the fact that I had created a custom field for the contacts and maybe something isnt matching up correctly.

Any help would be greatly appreciated.
Thanks and Kind Regards
Ryan

Hi - I have had the same errors (see quote from internal email) and suspect that it was basically caused by the Smart Group not creating correctly - and if I deleted the Smart Groups, reworked the search, recreated the Smart Groups (and if everything went properly) then everything worked sweet. So no technichal response from me but 'you are not on your own'.

However also note that twice when i created a Smart Group i got

    * warning: Invalid argument supplied for foreach() in /var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Mapping.php on line 683.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Mapping.php on line 683.
 
and once


    * warning: Invalid argument supplied for foreach() in /var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Mapping.php on line 742.
    * warning: Invalid argument supplied for foreach() in /var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Mapping.php on line 683.

when i think on both occasion i did the right thing.

and when i tried the search builder  i got
warning: Invalid argument supplied for foreach() in /var/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/Mapping.php on line 683. - oh! same thing

I was able to replicate warning message issue while creating smart group. So filed http://issues.civicrm.org/jira/browse/CRM-2242

kurund

On a related note - there have been a couple of times when I have made a change to a Smart Group - and the change has not 'stuck' - but then i realised that i wasn't getting the window that asks one to confirm the change of Update Smart Group - so had to go through and do it all again. Our server is down so can't be more specific than that at present.

But I would also note that on a couple of occassions I have forgotten to click 'GO" and I also note the instructions say
"select Update Smart Group from the '- more actions -' drop-down menu" but then do not say AND THEN CLICK GO!

Hey Lobo - not sure if I am hearing you clearly. Are you asking me for a suggested rewording?? If so
"If you've changed search criteria for this 'smart group' and want to save your changes, select Update Smart Group from the '- more actions -' drop-down menu, and then click GO".
At a more generic level, the 'Search' page could be improved from

Use the Search Criteria form to find contacts by name, type of contact, group membership, tags, etc. You can then view or edit contact details, print a contact list, assign tags, export contact data to a spreadsheet, etc.

to

Use the Search Criteria form to find contacts by name, type of contact, group membership, tags, etc. You can then view or edit contact details, or you can use the More Actions drop down list to print a contact list, assign tags, add to Groups, create Smart Groups, export contact data to a spreadsheet, etc.

If not, can you ask me again - sorry.

Lobo - could just be me using wrong terminology.
http://demo.civicrm.org/drupal/civicrm/contact/search/basic?_qf_Search_display=true&qfKey=352161998d7a89d7c0053853f1ef92e6 for the search and
http://demo.civicrm.org/drupal/civicrm/contact/search/advanced?reset=1&force=1&ssID=7 for updating smart groups.
Wasn't with you on the documentation thing when you said

edit the documentation

.
So now I have found the section in the Documentation Wiki http://wiki.civicrm.org/confluence/display/CRMDOC/Smart+Groups and have made some additions but felt that Edit Smart Group Criteria needed more prominence but it obviously isn't an H4 tag so not sure what formatting should be applied.

No probs - sorted on wiki by putting in an 'info' box