Author Topic: CiviCASE db error in search builder (Read 1767 times)

creea1 · February 16, 2009, 02:14:05 am

In search builder I selected
record type = case activity
activity field = activity subject
operator = IS NOT NULL

and I got the db error below;

Code: [Select]

Search Builder

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: no such field

    Database Error Code: Unknown column 'civicrm_case.id' in 'on clause', 1054

    Return to home page.

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(contact_a.id) as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, case_activity.subject as case_subject  FROM civicrm_contact contact_a INNER JOIN civicrm_case_activity ON civicrm_case_activity.case_id = civicrm_case.id  INNER JOIN civicrm_activity case_activity ON ( civicrm_case_activity.activity_id = case_activity.id
				                                                        AND case_activity.is_current_revision = 1 ) WHERE  ( 1 )    ORDER BY contact_a.sort_name asc  LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_case.id' in 'on clause']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT(contact_a.id) as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, case_activity.subject as case_subject  FROM civicrm_contact contact_a INNER JOIN civicrm_case_activity ON civicrm_case_activity.case_id = civicrm_case.id  INNER JOIN civicrm_activity case_activity ON ( civicrm_case_activity.activity_id = case_activity.id
				                                                        AND case_activity.is_current_revision = 1 ) WHERE  ( 1 )    ORDER BY contact_a.sort_name asc  LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_case.id' in 'on clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT(contact_a.id) as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, case_activity.subject as case_subject  FROM civicrm_contact contact_a INNER JOIN civicrm_case_activity ON civicrm_case_activity.case_id = civicrm_case.id  INNER JOIN civicrm_activity case_activity ON ( civicrm_case_activity.activity_id = case_activity.id
				                                                        AND case_activity.is_current_revision = 1 ) WHERE  ( 1 )    ORDER BY contact_a.sort_name asc  LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_case.id' in 'on clause']"]
)

[/code]

Kurund Jalmi · February 16, 2009, 03:24:56 am

Can you file an issue for this in jira.

thanx

Kurund

CiviCRM Community Forums (archive)

News:

Author Topic: CiviCASE db error in search builder (Read 1767 times)

creea1

CiviCASE db error in search builder

Kurund Jalmi

Re: CiviCASE db error in search builder