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) »
  • Only New Contacts can be sent civimail
Pages: [1]

Author Topic: Only New Contacts can be sent civimail  (Read 541 times)

dtheweather9

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 1
    • Students for the Exploration and Development of Space, USA
  • CiviCRM version: 4.4.0
  • CMS version: WordPress 3.8.1
  • MySQL version: 5.1.56
  • PHP version: 5.4.11
Only New Contacts can be sent civimail
December 18, 2013, 02:08:36 pm
Greetings; I'm experiencing an odd problem;
Trying to send a mail message from civimail; I select a group of around 2000, and on the next screen only 3 show up as 'Total Recipients:'; 3/4 of the 2k have an email that works, and none are marked with a 'hold'.
These three who can get emails happen to be both members of the organization and persons who recently signed up for a 'membership', as opposed to the rest who were direct imports from our migration.
I also tried starting an email via searching the group and hitting send mass email to those search results and that didn't work either.
I've had this same group and have sent out a half dozen emails to the whole group.  This is the first time I've sent using 4.4.0 since upgrading and I'm a little baffled. 

Any ideas here?



Sidenote: At this time I'm unable to upgrade on this installation to 4.4.3; another forum thread


Civicrm 4.4.0

dtheweather9

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 1
    • Students for the Exploration and Development of Space, USA
  • CiviCRM version: 4.4.0
  • CMS version: WordPress 3.8.1
  • MySQL version: 5.1.56
  • PHP version: 5.4.11
Re: Only New Contacts can be sent civimail
December 29, 2013, 11:28:40 am
Has anyone experienced any issue similar or have any idea how to diagnose it?  This is making civimail unusable at the moment for our organization.

It appears only emails coming in from the profile/registration forms are being allowed at the moment

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: Only New Contacts can be sent civimail
December 31, 2013, 12:23:49 am

if you have the $$$ might be worth getting someone from the civicrm provider listing to take a look and investigate.

alternatively, you can take a look at mysql query logs and figure out what is happening and why civi is seeing only 3 contacts

a bit hard to debug via the forums :(

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

dtheweather9

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 1
    • Students for the Exploration and Development of Space, USA
  • CiviCRM version: 4.4.0
  • CMS version: WordPress 3.8.1
  • MySQL version: 5.1.56
  • PHP version: 5.4.11
Re: Only New Contacts can be sent civimail
January 03, 2014, 08:23:08 am
hmm; well I figured out the cause of our mailing issue

civimail wasn't adding everyone because they were marked as "is_deceased"="" when the sql query was looking for "is_deceased"="0"so I 'killed off' 3 people and brought them back to life, which got them to be added to the mailing list. 

I then ran "UPDATE civicrm_contact SET is_deceased = 0 WHERE 1 = 1" and updated our known dead contacts manually...

no idea how it got to be "" instead of "0", but that appears to have resolved the issue.

bslash

  • I’m new here
  • *
  • Posts: 8
  • Karma: 1
  • CiviCRM version: 4.4.3
  • CMS version: drupal 7
  • MySQL version: 5.1.63
  • PHP version: 5.3.3
Re: Only New Contacts can be sent civimail
January 04, 2014, 08:23:46 am
Had the same after importing a lot of contacts. The new individuals are Zombies: their 'is_deceased' status was NULL (or undefined), whereas CiviMail does not send mail to zombies...

A quick UPDATE civicrm_contact SET `is_deceased`='0' WHERE (`contact_type`="Individual" AND `is_deceased` IS NULL) fixed it
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Only New Contacts can be sent civimail

This forum was archived on 2017-11-26.