Hi all,

when I try to send a custom template I get different errors and I can't really figure out why. I did a fresh install of the Newsletter Module Version is 7.x-1.0-beta9.
I've roundabout 3000 subscribers and configured the send rate per cron run to 600. Now when I run cron I get this:

The Message Notification:

Notice : Undefined index: 16 in newsletter_newsletter_load() (ligne 1023 in .../sites/all/modules/newsletter/newsletter.module).
Notice : Trying to get property of non-object in NewsletterCustom->updateNewsletter() (ligne 29 in .../sites/all/modules/newsletter/includes/newsletter.custom.inc).
Notice : Trying to get property of non-object in NewsletterCustom->updateNewsletter() (ligne 40 in .../sites/all/modules/newsletter/includes/newsletter.custom.inc).

In the reports:

PDOException : SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'entity_id' cannot be null: INSERT INTO {field_data_field_newsletter_body} (entity_type, entity_id, revision_id, bundle, delta, language, field_newsletter_body_value, field_newsletter_body_summary, field_newsletter_body_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => newsletter_newsletter [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => newsletter_newsletter [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => 
….
in field_sql_storage_field_storage_write() (ligne 448 dans/var/www/vhosts/lmdh.submedia.de/httpdocs/modules/field/modules/field_sql_storage/field_sql_storage.module).

And another message is:
Notice : Trying to get property of non-object in NewsletterCustom->updateNewsletter() (ligne 40 dans.../sites/all/modules/newsletter/includes/newsletter.custom.inc).

Is there a possibility to fix this by my self or do I have to reinstall the whole page (that would be a desaster...)

Greetings

ml

Comments

ParisLiakos’s picture

ParisLiakos CreditAttribution: ParisLiakos commented

Seems it tries to send a custom newsletter that is no longer there..quick solution delete the variable: newsletter_custom_for_next_cron either by running 

variable_del('newsletter_custom_for_next_cron');

or using devel module.
But be aware, this will cancel all outgoing custom newsletters

zrsagent’s picture

zrsagent CreditAttribution: zrsagent commented

Hi rootatwc,

thanks for your fast reply.
It was not totally clear what you mean with run

<?php

variable_del('newsletter_custom_for_next_cron');
?>

so I just copied the line in to the template.php and cleared all the caches.
Afterwards everything looked fine and I removed the line again.

Thanks so much.
You saved my ass ;-)

ParisLiakos’s picture

ParisLiakos CreditAttribution: ParisLiakos commented
Version: 7.x-1.0-beta9 » 7.x-1.x-dev
Assigned: zrsagent » Unassigned

great, now we need to actually fix this, by checking if newsletter exists before trying to send it

Patricia_W’s picture

Patricia_W CreditAttribution: Patricia_W commented

I'm getting a similar error;
Notice: Undefined index: 14 in newsletter_newsletter_load() (line 1023 of /home/****/public_html/***/sites/all/modules/newsletter/newsletter.module).
In my case, it appears that the newsletter gets sent to the first address (alphabetically by email address) in the list and all subsequent newsletters do not get sent.

I tried deleting the variable above. No change.

This newsletter is sent whether or not there are any nodes included.