CiviCRM Community Forums (archive)

i'd like to report a bug:

I created a Smart Group (Mailing List) which contained one contact with a working email-address.

At Step 4 of the CiviMail Wizard i tried to send a test mail to my smart group and i got the following error..

After hours of becoming desperate i simply pressed the done button and startet cron job... and it worked.


//I guess it has something to do with the Status field in the civicrm_group_contact table, because the relation of contacts and smart groups are stored   in //the civicrm_group_contact_cache table. I removed the field `civicrm_group_contact-11`.status as status and the SQL worked.


Is "send a test mail" using a different query or why does it suddenly work? =)
Sorry. A non-recoverable error has occurred.

DB Error: no such field

Database Error Code: Unknown column 'civicrm_group_contact-11.status' in 'field list', 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 contact_a.id as contact_id,
                      civicrm_email.email as email, `civicrm_group_contact-11`.status as status  FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_11` ON contact_a.id = `civicrm_group_contact_cache_11`.contact_id   LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  WHERE  ( 1 )  AND  ( `civicrm_group_contact_cache_11`.group_id = 11 )   [nativecode=1054 ** Unknown column 'civicrm_group_contact-11.status' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT contact_a.id as contact_id,
                      civicrm_email.email as email, `civicrm_group_contact-11`.status as status  FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_11` ON contact_a.id = `civicrm_group_contact_cache_11`.contact_id   LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  WHERE  ( 1 )  AND  ( `civicrm_group_contact_cache_11`.group_id = 11 )   [nativecode=1054 ** Unknown column 'civicrm_group_contact-11.status' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT contact_a.id as contact_id,
                      civicrm_email.email as email, `civicrm_group_contact-11`.status as status  FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id  LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id  LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  LEFT JOIN civicrm_phone ON (contact_a.id = civicrm_phone.contact_id AND civicrm_phone.is_primary = 1)  LEFT JOIN civicrm_im ON (contact_a.id = civicrm_im.contact_id AND civicrm_im.is_primary = 1)  LEFT JOIN civicrm_worldregion ON civicrm_country.region_id = civicrm_worldregion.id   LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_11` ON contact_a.id = `civicrm_group_contact_cache_11`.contact_id   LEFT JOIN civicrm_option_group option_group_gender ON (option_group_gender.name = 'gender') LEFT JOIN civicrm_option_value gender ON (contact_a.gender_id = gender.value AND option_group_gender.id = gender.option_group_id)  WHERE  ( 1 )  AND  ( `civicrm_group_contact_cache_11`.group_id = 11 )   [nativecode=1054 ** Unknown column 'civicrm_group_contact-11.status' in 'field list']"]
)


[/code]

I've recreated this issue on my 2.2 local install and filed an bug report for 2.2 here:

http://issues.civicrm.org/jira/browse/CRM-4112