I have simple html newsletters which I'm sending with simplenews + mimemail, and everything seems to be working fine, but in /admin/content/simplenews/sent under the "sent" column the last two newsletter still show the icon for "currently being sent by cron". Nothing is actually being sent as I can tell from my watchdog log. As I said at the beginning, as far as I can tell, the newsletters are being sent OK to a list of 700 subscribers.

CommentFileSizeAuthor
#7 Screenshot.png16.19 KBwagafo

Comments

darrellhq’s picture

darrellhq commented

I am having this problem as well. My list of 9k+ member is stuck but another list of 500 member works perfectly. I wonder if I set something wrong.

sutharsan’s picture

sutharsan commented

This is by design, yes realy. I have built the basics, simplenews has a database in which the status of outgoing emails are logged. But no interface has been built. Still I hope for someone to step forward to deliver code for a better interface or someone who likes to fund the development. Intill then you guys have to live with this.

wagafo’s picture

wagafo commented
Title: "Currently being send by cron" is still shown in my sent newsletters despite having been sent » "Currently being sent by cron" is still shown in my sent newsletters despite having been sent

This means that I can safely assume all emails have been sent, or that some of the last emails in the list of subscriptions are not sent and that's why it shows "Currently been sent by cron"?

sutharsan’s picture

sutharsan commented

There are emails not sent. The simplenews_mail_spool table holds pending and recently sent mail adresses. Status = 1 is pending. The will be (re)sent during next cron.

wagafo’s picture

wagafo commented

In my case the table is empty but it still shows the "Currently being sent..." and the blue icon in /admin/content/simplenews/sent

sutharsan’s picture

sutharsan commented

Perhsos nothing was put into the table. But that is strange. The status should be updated by cron.

wagafo’s picture

wagafo commented
StatusFileSize
new Screenshot.png16.19 KB

I have four cron runs programmed to run each night, so there have been a lot of cron runs. It shows for the last two issues of my newsletter. I attach a screenshot, it's localized but you'll get the picture. If I can help debugging in any way please let me know.

sutharsan’s picture

sutharsan commented

simplenews_send_status_update() should update the sent status of the newsletters. This function is called when cron is activated.
It is known that cron ran from command line, from a url in the browser and from Drush has different effects due to different permissions.

wagafo’s picture

wagafo commented

In my case it runs from a system cron run programmed to run each night. So I guess it is equivalent to "command line" run. I just did a "manual" run, but the messages are still there. I don't use Drush so I can't try that.

sutharsan’s picture

sutharsan commented

Try to run simplenews_send_status_update() manually. If that does not work you may have a database problem.

wagafo’s picture

wagafo commented

I did it, and nothing, the messages are still there. The simplenews_mail_spool table looks OK as far as i can tell, but it has 0 rows.

sutharsan’s picture

sutharsan commented

Do you have any other simplenews modules enabled? Disable them and try again. If the problem persists you must debug your code. Can't help you further.

wagafo’s picture

wagafo commented

No, I don't have any other simplenews module installed. I use mime mail though to send html newsletters. I'll take a look at the code and try to figure out why it doesn't update the sent status despite the table being empty.

darrellhq’s picture

darrellhq commented

I have this problem too it only seems to happen when sending more then 500 emails anything above that appears to be stuck as it shows "Currently being sent..." However the emails have been sent but the status is not updated and does not give Feedback in newsletter statistics.

UNarmed’s picture

UNarmed commented

I have the same problem and i sent my email to 520 people ... i think the emails ended up at the subscribers but now there is no way to check the emails statistics because of this "Currently being sent by cron" issue =/

wagafo’s picture

wagafo commented

The emails ARE sent, I have more than 700 subscribers and I checked randomly in the list and the mails are sent correctly. I also checked the logs of the servers and everything is fine there, I see the email being sent. The problem is that the s_status field in the simplenews_newsletter is not changed to "2" when cron finishes sending the emails.

wagafo’s picture

wagafo commented
Status: Active » Closed (fixed)

It seems that the last update of simplenews has fixed this, my last newsletter now shows as sent in the status column after being actually sent.