CiviCRM Community Forums (archive)

I try to search users born after a specific date using the Search Builder, but I get an error:

Sorry. A non-recoverable error has occurred.
Database Error Code: Unknown column 'civicrm_contact.birth_date' in 'where clause', 1054

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 WHERE  (  ( civicrm_contact.birth_date > 19900101 AND contact_a.contact_type IN ('Individual') )  )  AND  ( 1 )     [nativecode=1054 ** Unknown column 'civicrm_contact.birth_date' 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 WHERE  (  ( civicrm_contact.birth_date > 19900101 AND contact_a.contact_type IN ('Individual') )  )  AND  ( 1 )     [nativecode=1054 ** Unknown column 'civicrm_contact.birth_date' 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 WHERE  (  ( civicrm_contact.birth_date > 19900101 AND contact_a.contact_type IN ('Individual') )  )  AND  ( 1 )     [nativecode=1054 ** Unknown column 'civicrm_contact.birth_date' in 'where clause']"]
)

It looks like the WHERE 'civicrm_contact.birth_date' should be 'contact_a.birth_date'.

Can someone tell me where I can change this?[/code]

Thanks, I'll watch the issue for a fix.