Hi Chad,

After my latest attempt to send a newsletter and the module crashing again with database referential integrity error, I've been looking at some of the table to see what's going on with my data.

The table [DataSprings_OptInEmailPreviousNewsletter] contains a bunch of duplicates, each with a sentdatetime of 1753-01-01 00:00:00.000.

Is this right?

Thanks Rod.

Hi Rob,

Yes I believe that is ok... It sounds like all of these records are likely 'Draft' versions. If you save a draft version it will save the details with that sent date/time.

Thanks,

Chad

Thanks Chad,

The thing is, I have 1 draft that is visible from the Opt-In control panel, and 12 records in [DataSprings_OptInEmailPreviousNewsletter] that have a date of 1753-01-01 00:00:00.000. If these are drafts (and they look like they are), then I would expect them to either display where I can edit them, or be removed from the database.

Either way, I think there is an issue here.

Thanks,
Rod