Author Topic: smart group mailing crash (Read 642 times)

mikeney · April 03, 2010, 03:04:39 pm

Whenever I try to use a Smart Group (based on proximity search) I get the following error after adding the new Smart Group to the mailing recipients list. I'm not much of a programmer and I don't really understand the error. Could someone please help explain what the problem might be?

Code: [Select]

     Sorry. A non-recoverable error has occurred.

    DB Error: no such field

    Database Error Code: Unknown column 'civicrm_email.id' 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] => INSERT IGNORE INTO  I_1 (email_id, contact_id)
                    SELECT DISTINCT     civicrm_email.id as email_id,
                                        contact_a.id as contact_id 
                    
FROM      civicrm_contact contact_a
LEFT JOIN civicrm_address address ON ( address.contact_id       = contact_a.id AND
                                       address.is_primary       = 1 )
LEFT JOIN civicrm_state_province state_province ON state_province.id = address.state_province_id
LEFT JOIN civicrm_country country               ON country.id        = address.country_id

                    LEFT JOIN           X_1
                            ON          contact_a.id = X_1.contact_id
                    WHERE           
                                        contact_a.do_not_email = 0
                        AND             contact_a.is_opt_out = 0
                        AND             contact_a.is_deceased = 0
                        AND             (civicrm_email.is_bulkmail = 1 OR civicrm_email.is_primary = 1)
                        AND             civicrm_email.on_hold = 0
                                         AND address.geo_code_1  >= 38.081287641769  AND
address.geo_code_1  <= 39.880312358231  AND
address.geo_code_2 >= -78.094473326116 AND
address.geo_code_2 <= -75.780126673884 AND

IFNULL( ACOS( 0.22601719349055 * COS( RADIANS( -76.9373000 ) ) *
              ( 0.77735680510572 * COS( RADIANS( 38.9808000 ) ) +
                0.62905993160892 * SIN( RADIANS( 38.9808000 ) ) ) +
              -0.9741233126492  * SIN( RADIANS( -76.9373000  ) ) ), 0.00000 ) * 6357839.5156775
 <= 100000 
                        AND             contact_a.id NOT IN ( 
                                          SELECT contact_id FROM civicrm_group_contact 
                                          WHERE civicrm_group_contact.group_id = 16 AND civicrm_group_contact.status = 'Removed') 
                        AND             X_1.contact_id IS null
                    ORDER BY civicrm_email.is_bulkmail [nativecode=1054 ** Unknown column 'civicrm_email.id' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT IGNORE INTO  I_1 (email_id, contact_id)
                    SELECT DISTINCT     civicrm_email.id as email_id,
                                        contact_a.id as contact_id 
                    
FROM      civicrm_contact contact_a
LEFT JOIN civicrm_address address ON ( address.contact_id       = contact_a.id AND
                                       address.is_primary       = 1 )
LEFT JOIN civicrm_state_province state_province ON state_province.id = address.state_province_id
LEFT JOIN civicrm_country country               ON country.id        = address.country_id

                    LEFT JOIN           X_1
                            ON          contact_a.id = X_1.contact_id
                    WHERE           
                                        contact_a.do_not_email = 0
                        AND             contact_a.is_opt_out = 0
                        AND             contact_a.is_deceased = 0
                        AND             (civicrm_email.is_bulkmail = 1 OR civicrm_email.is_primary = 1)
                        AND             civicrm_email.on_hold = 0
                                         AND address.geo_code_1  >= 38.081287641769  AND
address.geo_code_1  <= 39.880312358231  AND
address.geo_code_2 >= -78.094473326116 AND
address.geo_code_2 <= -75.780126673884 AND

IFNULL( ACOS( 0.22601719349055 * COS( RADIANS( -76.9373000 ) ) *
              ( 0.77735680510572 * COS( RADIANS( 38.9808000 ) ) +
                0.62905993160892 * SIN( RADIANS( 38.9808000 ) ) ) +
              -0.9741233126492  * SIN( RADIANS( -76.9373000  ) ) ), 0.00000 ) * 6357839.5156775
 <= 100000 
                        AND             contact_a.id NOT IN ( 
                                          SELECT contact_id FROM civicrm_group_contact 
                                          WHERE civicrm_group_contact.group_id = 16 AND civicrm_group_contact.status = 'Removed') 
                        AND             X_1.contact_id IS null
                    ORDER BY civicrm_email.is_bulkmail [nativecode=1054 ** Unknown column 'civicrm_email.id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT IGNORE INTO  I_1 (email_id, contact_id)
                    SELECT DISTINCT     civicrm_email.id as email_id,
                                        contact_a.id as contact_id 
                    
FROM      civicrm_contact contact_a
LEFT JOIN civicrm_address address ON ( address.contact_id       = contact_a.id AND
                                       address.is_primary       = 1 )
LEFT JOIN civicrm_state_province state_province ON state_province.id = address.state_province_id
LEFT JOIN civicrm_country country               ON country.id        = address.country_id

                    LEFT JOIN           X_1
                            ON          contact_a.id = X_1.contact_id
                    WHERE           
                                        contact_a.do_not_email = 0
                        AND             contact_a.is_opt_out = 0
                        AND             contact_a.is_deceased = 0
                        AND             (civicrm_email.is_bulkmail = 1 OR civicrm_email.is_primary = 1)
                        AND             civicrm_email.on_hold = 0
                                         AND address.geo_code_1  >= 38.081287641769  AND
address.geo_code_1  <= 39.880312358231  AND
address.geo_code_2 >= -78.094473326116 AND
address.geo_code_2 <= -75.780126673884 AND

IFNULL( ACOS( 0.22601719349055 * COS( RADIANS( -76.9373000 ) ) *
              ( 0.77735680510572 * COS( RADIANS( 38.9808000 ) ) +
                0.62905993160892 * SIN( RADIANS( 38.9808000 ) ) ) +
              -0.9741233126492  * SIN( RADIANS( -76.9373000  ) ) ), 0.00000 ) * 6357839.5156775
 <= 100000 
                        AND             contact_a.id NOT IN ( 
                                          SELECT contact_id FROM civicrm_group_contact 
                                          WHERE civicrm_group_contact.group_id = 16 AND civicrm_group_contact.status = 'Removed') 
                        AND             X_1.contact_id IS null
                    ORDER BY civicrm_email.is_bulkmail [nativecode=1054 ** Unknown column 'civicrm_email.id' in 'field list']"]
)

[/code]

Donald Lobo · April 03, 2010, 07:53:32 pm

the proxiimity custom search does not implement a few functions that are required so it can be used in a civicrm mailing

if this is important to you please consider submitting a patch or hiring a developer (http://civicrm.org/professional/) to make the needed changes. Please submit your changes back to the code base so others can benefit

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: smart group mailing crash (Read 642 times)

mikeney

smart group mailing crash

Donald Lobo

Re: smart group mailing crash