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) »
  • CiviMail sending empty messages
Pages: [1]

Author Topic: CiviMail sending empty messages  (Read 3977 times)

buzz

  • Guest
CiviMail sending empty messages
June 04, 2010, 03:57:45 pm
Hello eyeryone!

Everything worked out quite well so far with CiviCRM and we really like it.

But since about 2 weeks CiviMail doesn't work anymore. We create new mailings but it sends out only completely empty messages. In the test mailing everything was still ok. We didn't changed anything with the database. So I don't know where to start searching.

This is the source from the mailing I received (no body, only headers...):
Code: [Select]
Return-Path: <newsletter+b+44+7746+ee6bfc333e71fe96@civimail.our-ngo.org>
X-Original-To: xxxx@xxxxx
Delivered-To: xxxx@xxxxx
Received: by xxxx (Postfix, from userid 5001)
id BF956A3B0072; Fri,  4 Jun 2010 22:27:46 +0000 (UTC)
X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on xxxxxxx
X-Spam-Level: ****
X-Spam-Status: No, score=4.6 required=4.8 tests=AWL,EMPTY_MESSAGE,
FROM_BLANK_NAME,MISSING_SUBJECT,TVD_SPACE_RATIO autolearn=no version=3.2.5
Received: from mail.our-ngo.org (www.our-ngo.org [x.x.x.x])
by xxxx (Postfix) with ESMTPS id B993CA3B0070
for <xxx@xxxxx>; Fri,  4 Jun 2010 22:27:45 +0000 (UTC)
Received: from our-ngo.org (localhost [127.0.0.1])
by mail.our-ngo.org (Postfix) with ESMTP id B2F7E11A0209
for <xxx@our-ngo.org>; Sat,  5 Jun 2010 00:27:44 +0200 (CEST)
MIME-Version: 1.0
Reply-To: newsletter+r+44+7746+ee6bfc333e71fe96@civimail.our-ngo.org
From: "" <contact@our-ngo.org>
Subject:
List-Unsubscribe: "" <mailto:newsletter+u+44+7746+ee6bfc333e71fe96@civimail.our-ngo.org>
To: "xxxx xxxx" <xxxx@our-ngo.org>
Precedence: bulk
X-CiviMail-Bounce: newsletter+b+44+7746+ee6bfc333e71fe96@civimail.our-ngo.org
Date: Sat, 05 Jun 2010 00:27:44 +0200
Message-Id: <20100604222744.B2F7E11A0209@mail.our-ngo.org>

The mail server log doesn't show anything unusual. It seems CiviMail doesn't generate the mails properly anymore.

I think the only thing we really changed is setting CiviCRM to multi-language. (But I'm quite sure we sent at least one other mailing afterwards...)

Maybe someone has hints or can point out how to debug this issue properly.

Thank you!
buzz

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: CiviMail sending empty messages
June 05, 2010, 01:56:47 pm
Quote from: buzz on June 04, 2010, 03:57:45 pm
But since about 2 weeks CiviMail doesn't work anymore. We create new mailings but it sends out only completely empty messages. In the test mailing everything was still ok.

I’m pretty sure this is what you mean, but just to reiterate: in your current (bad) situation, tests work, but real mailings don’t?

What is the exact version of CiviCRM you’re running? Is it 2.1.2 as your profile information suggests?

Quote
The mail server log doesn't show anything unusual. It seems CiviMail doesn't generate the mails properly anymore.

Did you verify it’s CiviMail that generates empty mails (rather than, say, your SpamAssassin misbehaving)?

Quote
I think the only thing we really changed is setting CiviCRM to multi-language. (But I'm quite sure we sent at least one other mailing afterwards...)

One that worked?
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

buzz

  • Guest
Re: CiviMail sending empty messages
June 07, 2010, 04:35:59 am
Quote from: Piotr Szotkowski on June 05, 2010, 01:56:47 pm
I’m pretty sure this is what you mean, but just to reiterate: in your current (bad) situation, tests work, but real mailings don’t?

Did you verify it’s CiviMail that generates empty mails (rather than, say, your SpamAssassin misbehaving)?
Exactly. The CiviMail sends mails when using the "Send test mailing" in the Mailing wizard. But the real mailings fail (they are all empty).

Quote
What is the exact version of CiviCRM you’re running? Is it 2.1.2 as your profile information suggests?
It's 3.1.4. The profile information is outdated.

Quote
Quote
I think the only thing we really changed is setting CiviCRM to multi-language. (But I'm quite sure we sent at least one other mailing afterwards...)
One that worked?
Yeah, one that worked. But I couldn't swear on it since it is about 3 weeks ago. But I know that changing to multi-language support does (unrevertible) major changes in the database and is considered somehow beta. Maybe this could be a problem? I don't know really were to start debugging. I think the problem is somewhere in CiviMail.

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: CiviMail sending empty messages
June 07, 2010, 11:11:46 am
Quote from: buzz on June 07, 2010, 04:35:59 am
Quote from: Piotr Szotkowski on June 05, 2010, 01:56:47 pm
I’m pretty sure this is what you mean, but just to reiterate: in your current (bad) situation, tests work, but real mailings don’t?

Did you verify it’s CiviMail that generates empty mails (rather than, say, your SpamAssassin misbehaving)?
Exactly. The CiviMail sends mails when using the "Send test mailing" in the Mailing wizard. But the real mailings fail (they are all empty).

Hm, this is very strange (I just sent myself a test and a real mailing from my multilingual sandbox and both worked). Can you send me (shot@civicrm.org) a test mailing and a ‘real’ mailing so that I can compare the headers?
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

buzz

  • Guest
Re: CiviMail sending empty messages
June 08, 2010, 03:02:05 am
Quote from: Piotr Szotkowski on June 07, 2010, 11:11:46 am
Hm, this is very strange (I just sent myself a test and a real mailing from my multilingual sandbox and both worked). Can you send me (shot@civicrm.org) a test mailing and a ‘real’ mailing so that I can compare the headers?

It is indeed strange. As I said everything used to work just fine before.

Sure I will send both mailings to you. It has nothing to do with SpamAssassin or our mail system. But maybe you spot something I didn't.

It seems CiviMail just happily sends out thousands of empty mails :(

buzz

  • Guest
Re: CiviMail sending empty messages
June 08, 2010, 04:18:21 am
An update for the records:

I would rather debug the issue but we have got an event to announce. So I loaded a database backup from before I enabled Multi-language support. And now CiviMail works again!

But it's still not really resolved as we actually need the multi-language support.

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: CiviMail sending empty messages
June 08, 2010, 07:10:56 am
Quote from: buzz on June 08, 2010, 04:18:21 am
I loaded a database backup from before I enabled Multi-language support. And now CiviMail works again!

Hm, this is very strange. Once you’re done with the mailing, it would be good to re-enable multilingual setup and see whether it indeed does break CiviMail again.

I got your email, and it doesn’t seem like the clue is in there. :| If the problem reappears after going multilingual again, is there a chance you can share the database? I’ll be only used to track down this issue and deleted afterwards, of course.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

buzz

  • Guest
Re: CiviMail sending empty messages
June 08, 2010, 12:10:26 pm
A mailing is sent Wednesday or Thursday. Afterwards I am going to reenable multi-language and report. Let's see if this really is the cause for the empty mails. Maybe it was just something else happening in this period.

For a database dump I don't really see a chance since there are all our NGO contacts in it. But maybe I am able to create a database version without our contacts that still includes the empty mailing bug. I'll figure out!

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: CiviMail sending empty messages
June 10, 2010, 03:36:25 am
Quote from: buzz on June 08, 2010, 12:10:26 pm
For a database dump I don't really see a chance since there are all our NGO contacts in it.

Sure thing, fully understood.

Quote
But maybe I am able to create a database version without our contacts that still includes the empty mailing bug. I'll figure out!

Exactly what I was going to ask for next. :)
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

buzz

  • Guest
Re: CiviMail sending empty messages
June 11, 2010, 03:31:40 pm
I changed now to multi-lang mode again and sent a quick mailing (only to myself). Everything worked fine so I don't really know what the cause was now...  ???

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: CiviMail sending empty messages
June 14, 2010, 04:27:58 am
Hm, I can’t really help in that case… Maybe if you have some free time you can try comparing the database dumps (but it might be a tedious work).
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: CiviMail sending empty messages
February 17, 2011, 01:31:02 pm
Sorry for reviving an old thread, but I am pretty sure I have run into the exact same bug, but in CiviCRM 3.3.5:

* contacts have their "preferred language" set
* the admin writes a mailing in her language (ex: French)
* those who have set another language (ex: English) get an empty message

I checked in the DB, and the view civicrm_mailing_en_US has an entry with NULL values for that mailing, which may explain why they get a blank message.

Piotr: what should be the expected value? How does CiviMail handle the "if alternate language is empty, use the other language"?

Matt / bgm
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

sussdorff

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 4
  • CiviCRM version: 3.4
  • CMS version: Drupal 6
Re: CiviMail sending empty messages
March 16, 2011, 01:31:40 am
I ran into exactly the same issue. Multilanguage English & German enabled, I got empty E-Mails (when I write in my German language). Turning on single language mode has enabled us to send the mailings again.

I would love to hear what is actually supposed to happen, as the Admin has no option (at least I could not find it) to define the language of the Mailing or provide multiple language versions.

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: CiviMail sending empty messages
March 16, 2011, 08:16:21 am
In theory, an ON INSERT trigger should populate all language versions when one is added.

I filed CRM-7786 to track and fix this.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • CiviMail sending empty messages

This forum was archived on 2017-11-26.