lm_sendp - how to force LMP to re-send Dailymail reports?

[BGSWebDesign]

Hi,

Ok, as you know I'm having problems with the queue, and I thought it was a stalled queue or other problem.  

I just had a look at: lm_sendp and found 4 records there including the last 4 days Dailymail report.

Can you please tell me HOW to get LMP to re-send those reports, and then should I flush out that table - by deleting all of the records, optimize the table and then repair the table?

Is there something wrong with LMP that it keeps sticking on sending out the Dailymail reports?

Your thoughts DW?

[DW]

The stored reports are usually sent after the queue completes.  If you cancelled the queue then the reports will be inaccurate and remain unsent.

You should be able to safely remove all entries from the lm_sendq and lm_sendp tables as long as there are no mailings in progress.

Regards

[BGSWebDesign]

DW,

The stored reports are usually sent after the queue completes. If you cancelled the queue then the reports will be inaccurate and remain unsent.

Yes, I understand that, but there were reports there for 3 days, the others would be ok.... Here's the problem now - this morning - the send queue was empty - AND - lm_sendp has one record in it - the current Dailymail report - which was not sent?

The record looks fine - like a normal record (unless you see something):
----------------------------------------------------------------------------------
id: 682
batid: cd4047
qtype: 2
formid: (empty)
started: 2007-04-04 04:15:16
lastact: 2007-04-04 04:54:37
report: (my dailymail report as normal)
completed: 1

Yesterday I deleted all the records in lm_sendp, optimized it, and everything looked fine, do you think I should try re-building the table as you suggest in another post?

Any other ideas on what is causing this - as I've said, I have ran LMP for years with no problems, just 4 days ago it started NOT sending out my Dailymail report, and it looks like all of the reports are there (in the lm_sendp table), just not getting sent?

Everything else seems to be working properly - bounce processing, etc..

[DW]

Hi Brett,

Sorry for the delay - I was out on a day trip visiting family.

Since it used to work and the process is fairly straightforward it doesn't seem there is a code or database problem.

The dailymail report is sent with PHP mail().  Could there be a problem with PHP mail() (welcome, confirm, some notifications) delivering to your admin email address?

Could you, perhaps, be mistakenly filtering the dailymail report in your receiving email client, or could it be happening at the server level? (ie. SpamAssassin or other spam fighting tool enabled on your domain)

Could your ListMail server be blacklisted by your admin email server?

Regards

[BGSWebDesign]

DW,

Since it used to work and the process is fairly straightforward it doesn't seem there is a code or database problem.

The dailymail report is sent with PHP mail(). Could there be a problem with PHP mail() (welcome, confirm, some notifications) delivering to your admin email address?

Could you, perhaps, be mistakenly filtering the dailymail report in your receiving email client, or could it be happening at the server level? (ie. SpamAssassin or other spam fighting tool enabled on your domain)

Could your ListMail server be blacklisted by your admin email server?

No, it was none of those as the report was never emailed from what I can tell - apparently a problem with the lm_sendp table itself?  

Yesterday I removed all of my bounced emails (about 20MB) from a table, then just to be sure I did a DROP on lm_sendp, and then re-created it using the command found in another thread in the forum.  This morning all seems to work, I have my Dailymail report as usual?

So, it seems a problem maybe related to the size of the overal MySQL database, it was growing quite large, or a problem with the lm_sendp table itself, not sure.

Also, I noticed this morning, even though the report went out as normal, there is still 1 record in the lm_sendp table (with my Dailymail report in it).  

Is it normal for that record to still be there after the report was sent?

[DW]

Brett,

Yesterday I removed all of my bounced emails (about 20MB) from a table

Did you remove these from a table or from a mailbox (using mailbox bounce processing?) With a large number of messages in a bounce mailbox the script could be choking there... however this processing happens -before- scheduled mailings and followup processing, so if you get those and they show up in the (stored) report this may not be the case....

Items will remain in lm_sendp and are removed by dailymail.php:

  // delete queues older than 3 days that are no longer queued

Hmm - still no clear explanation as to why you experienced what you did....

Regards

[BGSWebDesign]

Hi,

For reference, here is the thread that includes instructions on rebuilding lm_sendp:
http://listmailpro.com/forum/index.php?topic=1693.0