Contact Action Send an Email fails 4.5.1,4.5.5

[ericross]

When I try to send an email from the Contact screen I get the syntax error below.


The query will process when the email address is surrounded by quotes so this looks like a simple issue.
         'no~...@...~cuny.edu' and not as it is no~...@...~cuny.edu

I had not unchecked the "Enable CiviMail to create activities on delivery" so didn't have the Bulk Mail tab for contacts. When I made this change, the pop-up email form doesn't populate the To" address of the Contact and I get the same error on send.

Manually adding '' to the email address does process a little further but then errors out with an erroneous message: Selected contact(s) do not have a valid email address, or communication preferences specify DO NOT EMAIL, or they are deceased or Primary email address is On Hold.

So no work around that I can see.

Array( [callback] => Array (

• => CRM_Core_Error [1] => handle )

Code: [Select]

=> -2 [message] => DB Error: syntax error [mode] => 16 [debug_info] => 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_email  as `do_not_email`, contact_a.preferred_mail_format  as `preferred_mail_format`, contact_a.is_deceased  as `is_deceased`, civicrm_email.id as email_id, civicrm_email.email as `email`, civicrm_email.on_hold as `on_hold`  FROM civicrm_contact contact_a LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  WHERE  (  ( contact_a.id IN (120,no~...@...~cuny.edu ) )  )   LIMIT 0, 2  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@...~cuny.edu ) )  )   LIMIT 0, 2' at line 1] [type] => DB_Error




[/li]

[petednz]

Hi eric - sorry i don't have any specific insights in to your problem but i suspect anyone who does will still recommend that you upgrade to the latest 4.5 version and retest. It may not fix the issue but a lot of other bugs have been fixed since then

[ericross]

Upgraded to 4.5.5 and get the same errors when I Send an Email from the Contact Actions menu.


Tried a different format in the "To" box but same result.


"N~..." <no~...@...~cuny.edu> fails with syntax error. Running the failed query with '"N~..." <no~...@...~cuny.edu>' returns the expected Contact record.


4.5.5 upgrade had one glitch - couldn't create the CiviCase log table but I don't think that has any bearing here. Logging has been off and I had disabled CiviCase before the upgrade.

[petednz]

what happens when you send test mail from civicrm/admin/setting/smtp?reset=1 - is that all working fine?

[ericross]

Hmm,

After the 4.5.5 upgrade I was able to set outgoing mail back to SMTP (only mail() was working in 4.5.1). After your response, I checked again and it failed. Something isn't right. No email, Code 535. Looks like a secondary issue with SMTP.

My test mail goes to a gmail address but that has never been an issue.


Oops, I had left CiviCase enabled so... Civicase and (see below) Configure extension are disabled.
ran this  http://ndpny.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/clearcache and cleared all
using SMTP at http://ndpny.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/smtp&reset=1 and code: 535


switch to mail() and it successfully sends






When I went back to :
http://ndpny.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/extensions&reset=1


it responded with the API Profile screen I've seen before from CiviConfigure extension so I went to disable that extension and get this error.



Database Error Code: Unknown column 'cleanup' in 'field list', 1054
Additional Details:

Array ( [callback] => Array ( 

•  => CRM_Core_Error [1] => handle ) 

Code: [Select]

=> -19 [message] => DB Error: no such field [mode] => 16 [debug_info] => INSERT INTO civicrm_managed (module , name , entity_type , entity_id , cleanup ) VALUES ('civicrm' , 'civicase:act:ADC Referral' , 'OptionValue' ,  1088 , 'unused' )  [nativecode=1054 ** Unknown column 'cleanup' in 'field list'] [type] => DB_Error [user_info] => INSERT INTO civicrm_managed (module , name , entity_type , entity_id , cleanup ) VALUES ('civicrm' , 'civicase:act:ADC Referral' , 'OptionValue' ,  1088 , 'unused' )  [nativecode=1054 ** Unknown column 'cleanup' 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 INTO civicrm_managed (module , name , entity_type , entity_id , cleanup ) VALUES ('civicrm' , 'civicase:act:ADC Referral' , 'OptionValue' ,  1088 , 'unused' )  [nativecode=1054 ** Unknown column 'cleanup' in 'field list']"] )

[/li]

[petednz]

doubt i can help further but hopefully puts you and others on right track - perhaps update the Subject of this ticket too now