CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • eMails not being sent with CiviMail - Solved
Pages: [1]

Author Topic: eMails not being sent with CiviMail - Solved  (Read 1040 times)

ibhola

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Drupal v7.22
  • MySQL version: 5.5.23
  • PHP version: 5.3.27
eMails not being sent with CiviMail - Solved
October 26, 2013, 02:03:13 pm
Recently upgrade to 4.3.7

I have checked the forum for the last 2 days and can't seem to find anything that helps - double checked installation guides to confirm I did not miss anything.

When tested from "Settings - Outbound Mail" the email is sent ok - so I assume the settings are correct.

When a mailing is done the cron job reports success but in the bounce report all the recipients show up with bounce type as "SYNTAX"

When using the test function for mailing the error response is mail() returned failure

When testing  sending a receipt (this was working with version 4.1) the error is
    Sorry but we are not able to provide this at the moment.
    No such message template: option group msg_tpl_workflow_contribution, option value contribution_offline_receipt.
    Return to home page.

forum suggestions for other similar error did not apply (duplicate entries in options tables etc)

Any help would be appreciated greatly appreciated.
« Last Edit: November 12, 2013, 02:36:04 pm by ibhola »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: eMails not being sent with CiviMail
October 26, 2013, 02:25:04 pm

can u run the following query:

Code: [Select]
select v.* from civicrm_option_value v, civicrm_option_group g where v.option_group_id = g.id and g.name = 'msg_tpl_workflow_contribution' and v.name = 'contribution_offline_receipt';

it should return 1 record. if not, your db is inconsistent and i'd investigate that first and ensure the upgrade from 4.1 did not return any errors etc

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ibhola

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Drupal v7.22
  • MySQL version: 5.5.23
  • PHP version: 5.3.27
Re: eMails not being sent with CiviMail
October 26, 2013, 05:25:51 pm
Only one row returned

id   option_group_id   label                                                value   name   
538         60                  contributions - Receipt (off-line)   2   contribution_offline_receipt

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: eMails not being sent with CiviMail
October 27, 2013, 08:23:43 am

that entry contradicts the error message. so a bit strange

sorry, dont know whats happening and why. please do post back once u figure out the issue

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ibhola

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Drupal v7.22
  • MySQL version: 5.5.23
  • PHP version: 5.3.27
Re: eMails not being sent with CiviMail
October 29, 2013, 02:21:26 pm
I have been able to resolve the send receipt functionality. The issue was that the template.php that join between the option id for the template and the workflow id in the msg_template table did not match. in the option table the id was 538 and the workflow id for the template was 631. I changed the msg_template table workflow id to 538 to match the option id for that template and the receipt was emailed successfully.

Would this mismatch of data between the option table and the template table be caused by the upgrade script?


I will start troubleshooting the bounces from the Bulk emails.

ibhola

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Drupal v7.22
  • MySQL version: 5.5.23
  • PHP version: 5.3.27
Re: eMails not being sent with CiviMail
November 12, 2013, 02:35:27 pm
Was able to resolve the issue with bulk email by following the suggestions in http://forum.civicrm.org/index.php/topic,24242.15.html

commented out the following in mail.php at /sites/all/modules/civicrm/packages/Mail at line 156 and bulk mail started working :D

        // use Return-Path for SMTP envelope’s FROM address (if set), CRM-5946
       
        /* commented out as per forum http://forum.civicrm.org/index.php/topic,24242.15.html
         * on Nov 12 2013
        if (!empty($headers['Return-Path'])) {
            $from = $headers['Return-Path'];
        }
        */
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • eMails not being sent with CiviMail - Solved

This forum was archived on 2017-11-26.