Zurmo non-sent e-mails

When I do massive use of a campaign, I have sometimes the problem that some e-mails are not sent.

There is not user report that enables you to get them, so I have gone through phpMyAdmin to find and analyze them. The table used are:

1.- e-mail messages not sent:

SELECT * FROM `emailmessage` WHERE `sentdatetime` is null

2.- Select specific campaign items:

SELECT * FROM `campaignitem` WHERE `campaign_id`=’27’

I have removed the emailmessages without sentdatetime and its respective campaignitem.

Campaigns status values

  • Active = 2
  • Processing = 3
  • Completed = 4

Leave a Comment