Activity Mail DB Error: syntax error

[ericross]

Sending mail to a contact fails in 4.5.8.

The select statement fails when with @ in the email address.

Code: [Select]

SELECT contact_a.id as contact_id, contact_a.sort_name as `sort_name`, contact_a.display_name as `display_name`, contact_a.do_not_emailas `do_not_email`, contact_a.preferred_mail_format as `preferred_mail_format`, contact_a.is_deceased as `is_deceased`, civicrm_email.idas email_id, civicrm_email.email as `email`, civicrm_email.on_hold as `on_hold` FROM civicrm_contact contact_a LEFT JOIN civicrm_emailON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1) WHERE ( ( contact_a.id IN(102,statecoordinators@ndpny.org ) ) ) LIMIT 0, 2
WHERE needs quotes around the email address.

Code: [Select]

SELECT contact_a.id as contact_id, contact_a.sort_name as `sort_name`, contact_a.display_name as `display_name`, contact_a.do_not_emailas `do_not_email`, contact_a.preferred_mail_format as `preferred_mail_format`, contact_a.is_deceased as `is_deceased`, civicrm_email.idas email_id, civicrm_email.email as `email`, civicrm_email.on_hold as `on_hold` FROM civicrm_contact contact_a LEFT JOIN civicrm_emailON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1) WHERE ( ( contact_a.id IN(102,'statecoordinators@ndpny.org' ) ) ) LIMIT 0, 2

Code: [Select]

backTrace

#0 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(191): CRM_Core_Error::backtrace() #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error)) #2 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error)) #3 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...") #4 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...") #5 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...", "DB_Error", TRUE) #6 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...") #7 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError() #8 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...") #9 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...") #10 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...") #11 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...") #12 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...", TRUE) #13 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Query.php(4427): CRM_Core_DAO::executeQuery("SELECT contact_a.id as contact_id, contact_a.sort_name  as `sort_name`, conta...") #14 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Token.php(1159): CRM_Contact_BAO_Query::apiQuery((Array:2), (Array:7), NULL, NULL, 0, 2) #15 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Task/EmailCommon.php(221): CRM_Utils_Token::getTokenDetails((Array:2), (Array:7), FALSE, FALSE) #16 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Task/Email.php(163): CRM_Contact_Form_Task_EmailCommon::buildQuickForm(Object(CRM_Contact_Form_Task_Email)) #17 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(455): CRM_Contact_Form_Task_Email->buildQuickForm() #18 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(122): CRM_Core_Form->buildForm() #19 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contact_Form_Task_Email), "upload") #20 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Task_Email), "upload") #21 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(356): HTML_QuickForm_Page->handle("upload") #22 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run() #23 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(308): CRM_Utils_Wrapper->run("CRM_Contact_Form_Task_Email", "Activities", (Array:1)) #24 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(79): CRM_Core_Invoke::runItem((Array:14)) #25 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4)) #26 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm.php(525): CRM_Core_Invoke::invoke((Array:4)) #27 [internal function](): CiviCRM_For_WordPress->invoke("") #28 /home/ndpnyorg/public_html/wp-includes/plugin.php(496): call_user_func_array((Array:2), (Array:1)) #29 /home/ndpnyorg/public_html/wp-admin/admin.php(212): do_action("toplevel_page_CiviCRM") #30 {main}

[JonGold]

Eric,

Is this replicable on the demo database?  If so, this is a pretty serious bug and should be filed on issues.civicrm.org.

[ericross]

Works fine on the demo site.


My "Send an Email" dialog box doesn't populate the 'To' email address from the contact and I don't see the 'AddCC' and 'AddBCC' entries. Also, I have 'Send Email' at the top and bottom left. The demo site has it bottom only right.


It looks like the demo site is 4.5.9. Has that been released?

[ericross]

I found that Email duration (com.uniqueadvisers.emailduration) was not tested with 4.5.8 and disabled it. That was the problem.

[JonGold]

Aha!  I was going to say, I'm caught up on the issues queue and haven't seen any bugs relating to this screen since 4.5.8 was released - and the cc/bcc reminded me of an issue I saw once that dealt with a jQuery version mismatch.  Glad you found the issue!