"DB Error: No such field" when searching for male members of a particular group

[tv2011]

Hi, I've been doing an advanced search for contacts who are both male and a member of a particular group. I get the following error. Any ideas?

This is on 4.4.4, using the CiviCRM starter kit on Drupal.

Code: [Select]

Mar 09 16:46:47  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a INNER JOIN civicrm_activity_contact
                      ON ( civicrm_activity_contact.contact_id = contact_a.id )  INNER JOIN civicrm_activity
                      ON ( civicrm_activity.id = civicrm_activity_contact.activity_id
                      AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 )  LEFT JOIN civicrm_group_contact `civicrm_group_contact-2` ON ( contact_a.id = `civicrm_group_contact-2`.contact_id AND `civicrm_group_contact-2`.group_id IN ( 2 ) )  INNER JOIN civicrm_rel_temp_522a0951e2aca9e909b74e216fe0fc11 civicrm_relationship ON civicrm_relationship.contact_id = contact_a.id WHERE  (  civicrm_activity_contact.record_type_id = 3 AND  civicrm_activity.status_id IN (1,2) AND civicrm_activity.is_test = 0 AND contact_a.gender_id = 2 AND `civicrm_group_contact-2`.group_id IN ( 2 ) AND `civicrm_group_contact-2`.status IN ("Added") AND civicrm_membership.is_test = 0 )  AND (contact_a.is_deleted = 0)    ORDER BY UPPER(LEFT(contact_a.sort_name, 1)) asc  [nativecode=1054 ** Unknown column 'civicrm_membership.is_test' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a INNER JOIN civicrm_activity_contact
                      ON ( civicrm_activity_contact.contact_id = contact_a.id )  INNER JOIN civicrm_activity
                      ON ( civicrm_activity.id = civicrm_activity_contact.activity_id
                      AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 )  LEFT JOIN civicrm_group_contact `civicrm_group_contact-2` ON ( contact_a.id = `civicrm_group_contact-2`.contact_id AND `civicrm_group_contact-2`.group_id IN ( 2 ) )  INNER JOIN civicrm_rel_temp_522a0951e2aca9e909b74e216fe0fc11 civicrm_relationship ON civicrm_relationship.contact_id = contact_a.id WHERE  (  civicrm_activity_contact.record_type_id = 3 AND  civicrm_activity.status_id IN (1,2) AND civicrm_activity.is_test = 0 AND contact_a.gender_id = 2 AND `civicrm_group_contact-2`.group_id IN ( 2 ) AND `civicrm_group_contact-2`.status IN ("Added") AND civicrm_membership.is_test = 0 )  AND (contact_a.is_deleted = 0)    ORDER BY UPPER(LEFT(contact_a.sort_name, 1)) asc  [nativecode=1054 ** Unknown column 'civicrm_membership.is_test' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a INNER JOIN civicrm_activity_contact
                      ON ( civicrm_activity_contact.contact_id = contact_a.id )  INNER JOIN civicrm_activity
                      ON ( civicrm_activity.id = civicrm_activity_contact.activity_id
                      AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 )  LEFT JOIN civicrm_group_contact `civicrm_group_contact-2` ON ( contact_a.id = `civicrm_group_contact-2`.contact_id AND `civicrm_group_contact-2`.group_id IN ( 2 ) )  INNER JOIN civicrm_rel_temp_522a0951e2aca9e909b74e216fe0fc11 civicrm_relationship ON civicrm_relationship.contact_id = contact_a.id WHERE  (  civicrm_activity_contact.record_type_id = 3 AND  civicrm_activity.status_id IN (1,2) AND civicrm_activity.is_test = 0 AND contact_a.gender_id = 2 AND `civicrm_group_contact-2`.group_id IN ( 2 ) AND `civicrm_group_contact-2`.status IN ("Added") AND civicrm_membership.is_test = 0 )  AND (contact_a.is_deleted = 0)    ORDER BY UPPER(LEFT(contact_a.sort_name, 1)) asc  [nativecode=1054 ** Unknown column 'civicrm_membership.is_test' in 'where clause']"]
)


Mar 09 16:46:47  [info] $backTrace = #0 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/Error.php(197): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...")
#4 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...")
#5 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...", "DB_Error", TRUE)
#6 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_membership.is_test' in 'where clause'")
#7 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...")
#9 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...")
#10 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...")
#11 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/DAO.php(160): DB_DataObject->query("SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...")
#12 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/DAO.php(907): CRM_Core_DAO->query("SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...", TRUE)
#13 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Contact/BAO/Query.php(4397): CRM_Core_DAO::executeQuery("SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicr...")
#14 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Contact/Selector.php(1047): CRM_Contact_BAO_Query->searchQuery(NULL, NULL, NULL, FALSE, FALSE, TRUE)
#15 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Utils/PagerAToZ.php(81): CRM_Contact_Selector->alphabetQuery()
#16 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Utils/PagerAToZ.php(106): CRM_Utils_PagerAToZ::getDynamicCharacters(Object(CRM_Contact_Selector), FALSE)
#17 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Utils/PagerAToZ.php(53): CRM_Utils_PagerAToZ::createLinks(Object(CRM_Contact_Selector), NULL, FALSE)
#18 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Contact/Form/Search.php(941): CRM_Utils_PagerAToZ::getAToZBar(Object(CRM_Contact_Selector), NULL)
#19 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Contact/Form/Search/Advanced.php(320): CRM_Contact_Form_Search->postProcess()
#20 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/Form.php(261): CRM_Contact_Form_Search_Advanced->postProcess()
#21 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/QuickForm/Action/Refresh.php(75): CRM_Core_Form->mainProcess()
#22 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Refresh->perform(Object(CRM_Contact_Form_Search_Advanced), "refresh")
#23 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Search_Advanced), "refresh")
#24 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("refresh")
#25 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Core_Controller->run((Array:4), (Array:0))
#26 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#27 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#28 /srv/domain.tld/public/htdocs/profiles/civicrm_starterkit/modules/civicrm/drupal/civicrm.module(458): CRM_Core_Invoke::invoke((Array:4))
#29 [internal function](): civicrm_invoke("contact", "search", "advanced")
#30 /srv/domain.tld/public/htdocs/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:3))
#31 /srv/domain.tld/public/htdocs/index.php(21): menu_execute_active_handler()
#32 {main}


[tv2011]

Never mind - I ran the same search again today and I don't seem to be able to reproduce.

[tomsinger]

I just hit the same issues which seems to be cause by this bug https://issues.civicrm.org/jira/browse/CRM-14297

Hotfixing the patch from the PR https://github.com/civicrm/civicrm-core/pull/2636 seems to clear the issue up.

[tv2011]

Thanks for that info - I think I'll wait until 4.4.5 is released to fix it!

[Eileen]

If it's a real issue you could switch to our deployment instance of 4.4 until 4.4.5 comes out - https://github.com/fuzionnz/civicrm-core - we put that patch in there quite a while back