Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TYPE civicrm
- DATE Tuesday, 28 April 2020 - 11:10am
- LOCATION ***civicrm/ajax/rest
- REFERRER ***/civicrm/a/
- MESSAGE $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -2 [message] => DB Error: syntax error [mode] => 16 [debug_info] => REPLACE INTO civicrm_tmp_e_inrecipient_cc33eb2a357542a3388ca2999a2bc10f (contact_id, email_id) SELECT civicrm_contact.id as contact_id, civicrm_email.id as email_id FROM civicrm_email INNER JOIN civicrm_contact ON civicrm_email.contact_id = civicrm_contact.id INNER JOIN civicrm_group_contact gc ON gc.contact_id = civicrm_contact.id INNER JOIN civicrm_mailing_group mg ON gc.group_id = mg.entity_id AND mg.search_id IS NULL LEFT JOIN civicrm_tmp_e_exrecipient_e99e42844bd735bc289da06e185e91db temp ON civicrm_contact.id = temp.contact_id WHERE (gc.group_id IN (4) AND gc.status = "Added") AND (civicrm_contact.do_not_email = 0) AND (civicrm_contact.is_opt_out = 0) AND (civicrm_contact.is_deceased <> 1) AND ((civicrm_email.location_type_id != )) AND (civicrm_email.email IS NOT NULL) AND (civicrm_email.email != '') AND (civicrm_email.on_hold = 0) AND (mg.mailing_id = 355) AND (temp.contact_id IS NULL) GROUP BY civicrm_contact.id, civicrm_email.id ORDER BY civicrm_email.is_bulkmail, civicrm_email.is_primary [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (civicrm_email.email IS NOT NULL) AND (civicrm_email.email != '') AND (ci' at line 8] [type] => DB_Error [user_info] => REPLACE INTO civicrm_tmp_e_inrecipient_cc33eb2a357542a3388ca2999a2bc10f (contact_id, email_id) SELECT civicrm_contact.id as contact_id, civicrm_email.id as email_id FROM civicrm_email INNER JOIN civicrm_contact ON civicrm_email.contact_id = civicrm_contact.id INNER JOIN civicrm_group_contact gc ON gc.contact_id = civicrm_contact.id INNER JOIN civicrm_mailing_group mg ON gc.group_id = mg.entity_id AND mg.search_id IS NULL LEFT JOIN civicrm_tmp_e_exrecipient_e99e42844bd735bc289da06e185e91db temp ON civicrm_contact.id = temp.contact_id WHERE (gc.group_id IN (4) AND gc.status = "Added") AND (civicrm_contact.do_not_email = 0) AND (civicrm_contact.is_opt_out = 0) AND (civicrm_contact.is_deceased <> 1) AND ((civicrm_email.location_type_id != )) AND (civicrm_email.email IS NOT NULL) AND (civicrm_email.email != '') AND (civicrm_email.on_hold = 0) AND (mg.mailing_id = 355) AND (temp.contact_id IS NULL) GROUP BY civicrm_contact.id, civicrm_email.id ORDER BY civicrm_email.is_bulkmail, civicrm_email.is_primary [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (civicrm_email.email IS NOT NULL) AND (civicrm_email.email != '') AND (ci' at line 8] [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="REPLACE INTO civicrm_tmp_e_inrecipient_cc33eb2a357542a3388ca2999a2bc10f (contact_id, email_id) SELECT civicrm_contact.id as contact_id, civicrm_email.id as email_id FROM civicrm_email INNER JOIN civicrm_contact ON civicrm_email.contact_id = civicrm_contact.id INNER JOIN civicrm_group_contact gc ON gc.contact_id = civicrm_contact.id INNER JOIN civicrm_mailing_group mg ON gc.group_id = mg.entity_id AND mg.search_id IS NULL LEFT JOIN civicrm_tmp_e_exrecipient_e99e42844bd735bc289da06e185e91db temp ON civicrm_contact.id = temp.contact_id WHERE (gc.group_id IN (4) AND gc.status = "Added") AND (civicrm_contact.do_not_email = 0) AND (civicrm_contact.is_opt_out = 0) AND (civicrm_contact.is_deceased <> 1) AND ((civicrm_email.location_type_id != )) AND (civicrm_email.email IS NOT NULL) AND (civicrm_email.email != '') AND (civicrm_email.on_hold = 0) AND (mg.mailing_id = 355) AND (temp.contact_id IS NULL) GROUP BY civicrm_contact.id, civicrm_email.id ORDER BY civicrm_email.is_bulkmail, civicrm_email.is_primary [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (civicrm_email.email IS NOT NULL) AND (civicrm_email.email != '') AND (ci' at line 8]"] )
- SEVERITY error
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement