newsletter not sent: node does not exist (nid = ; vid = ).

wimds - March 24, 2009 - 15:35
Project:Simplenews
Version:6.x-1.0-rc6
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

After creating a new newsletter issue I try to 'Save & send' the node.
As a result I get the message that my newsletter is being sent and my newsletter issue is created

I want CRON to be executed immediatly thus start it manually (throug status report page) but it gives me a white blanc screen.
I return to the admin/reports page and look in the 'recent logs' and there I see the folowing error:

"Nieuwsbrief niet verzonden: node bestaat niet (nid = ; vid = )."
or "Newsletter not sent: node does not exist (nid = ; vid = )." in English.

Also CRON reports a warining that it has stopped because the maximum duration is exceeded

Thanks for your help,
Wim

#1

mogtofu - March 31, 2009 - 09:55

I got the same problem and it came from simlenews_template. Try to desinstall it.
regards.
Mog

#2

wimds - March 31, 2009 - 19:27

Hi Mog,

thanks for your reply.
I just checked but I haven't installed the Simplenews_Template module; so it seems something else is causing this.

Any help is welcome.
Regards,
Wim

#3

wimds - April 1, 2009 - 11:33
Component:Documentation» Code
Category:support request» bug report

#4

s.Daniel - April 2, 2009 - 10:20

Confirm the same issue with rc4 & rc6.

The table simplenews_mail_spool still holds entrys of nodes to be sent after the nodes are deleted resulting in this error.
After manually deleting all entrys of deleted nodes (or in my cases all entrys except the node I wanted to send) newsletters are beeing sent again.

>> Entrys in simplenews_mail_spool should be deleted when the accociated node is deletet.
>>> Extremle awsome would be to show a warning at the node delete confirmation page that the newsletter hasn't been fully sent to all recipients.

#5

Sutharsan - April 2, 2009 - 11:02

@s.Daniel: You are right with the first request. Your second request is a duplicate of: #392956: Deleted newsletter node during sending procedure

#6

Ylan - April 8, 2009 - 17:47

I can confirm this issue. s.Daniels instructions worked for me.

#7

wimds - April 15, 2009 - 08:56

Hi,

indeed, after deleting the entries in the simplenews_mail_spool table the error messages dissapeared.

Now, when I create a new 'newsletter' issue and I try to send a (test) newsletter the website returns a blanc white page (when I click on 'Save & Send test mail'). After refreshing, the page comes up again with a warning: The content is being changed by another user; the changes can not be saved.

Allthough the newsletter is created, I don't receive a (test) mail. I don't receive any error messages also.

The newsletter appears in the list of 'sent newsletters', its status is 'Is currently being sent by CRON'.
I also tried to send it withouth CRON, but its status (in the 'sent newsletters' list) remains 'Is currently being sent by CRON'.

I turned on the logging for email, but I do not receive any input in the log,

Any help would be much appreciated.

#8

towndwarf - June 16, 2009 - 21:55

I can confirm this issue too.
Probably problem goes from updates in taxonomy tables...

#9

MWildermuth - July 14, 2009 - 04:41

Sorry, but I am new to this, and I have the same problem. Where do I find the simplenews_mail_spool table, where I can delete the entries?

Thanks.

#10

s.Daniel - July 16, 2009 - 08:07

Usuall you should be able to access your database using phpmyadmin if you are on a shared host. Take a look in your hosts backend and you should find something like "database administration".

#11

MWildermuth - July 17, 2009 - 01:04

Thanks. I found it, and deleted the entries. That seemed to fix it for me. Thanks again.

#12

bmblack - October 7, 2009 - 13:55

Sorry - I'm confused. I'm not that familiar with phpmyadmin.

I am running across the same error: "Newsletter not send: node does not exist (nid = ; vid = )."

I'm able to get into phpmyadmin and I clicked on "simplenews_mail_spool" on the left side of my screen. Now, what exactly do I delete?

If I click "Browse", I see a list of Email addresses. If I click "Structure" I see a list: msid, mail, nid, vid, tid, status, timestamp.

I'm sorry for such a simple question - but I'd really appreciate any help.

Thanks

=====
Update: I figured it out. Works great now, no errors. For those of you who may have the same question I did - You just hit the browse button and delete that whole list of email addresses that you see.

#13

s.Daniel - October 11, 2009 - 17:27

as an aditional note: Do not delete the table! Look for "trucate" or something in your language wich says something like "empty tables data".

#14

pharoz - October 23, 2009 - 17:21

I had the same problem and deleted the offending entries per #12 comment. Thanks!

#15

MacDennis - November 9, 2009 - 11:38

I've got the same issue!

But I don't have any entries in the table simplenews_mail_spool
What's the problem?

 
 

Drupal is a registered trademark of Dries Buytaert.