Failed email, endless loop...

Solutions for other advanced phplisters

Failed email, endless loop...

Postby hksoftware » 1:23pm, Thu 03 Jan, 2008

Hi,
I'm very happy with phplist.
Unfortunately I have one small problem.

Somewhere in my list must be an invalid email address as it fails on one and keeps trying it when it gets to the end.
All of the other emails go out fine, but it gets stuck in an endless loop at the end repeatedly trying this email address. If there a table in my database where I can identify this email address?
Will its ID be stored in a 'progress' table or something so I can find it in the mail table?

Here's what my phplist progress window shows:

Started
Sending in batches of 34 emails
This batch will be 31 emails, because in the last 900 seconds 3 emails were sent
Sent in last run: 0
Skipped in last run: 0
Processing has started, 1 message(s) to process.
Please leave this window open. You have batch processing enabled, so it will reload several times to send the messages. Reports will be sent by email to no@spam.co.uk
Processing message 20
Looking for users
Found them: 1 to process
Processed 1 out of 1 users
Script stage: 5
1 emails failed (will retry later)
Finished this run
Less than batch size were sent, so reloading imminently
hksoftware
phpLister
 
Posts: 6
Joined: 1:16pm, Thu 03 Jan, 2008

Postby FMP24060 » 7:39pm, Thu 03 Jan, 2008

For what it's worth, I had exactly this problem yesterday & would also love advice. It also generated a "report" email back to me for each iteration of the loop - if I had left it overnight (for example) I'd have come back to a very full mailbox...
FMP24060
phpLister
 
Posts: 6
Joined: 2:15pm, Sun 09 Dec, 2007

Postby hksoftware » 8:00pm, Thu 03 Jan, 2008

FMP24060 wrote:For what it's worth, I had exactly this problem yesterday & would also love advice. It also generated a "report" email back to me for each iteration of the loop - if I had left it overnight (for example) I'd have come back to a very full mailbox...


yes, that's just what mine does.
my isp pulls the plug on my site if I send more that 150 email in an hour so the report emails could break the limit.

its happening with every email I send out.

i'd like a code mod which tells me what email addys failed in the report, or one which tries erroneous emails x times then cancels them
hksoftware
phpLister
 
Posts: 6
Joined: 1:16pm, Thu 03 Jan, 2008

Postby FMP24060 » 8:21pm, Thu 03 Jan, 2008

Are you by chance getting the "magic quotes" warning about a PHP setting? I've just started getting that warning due to some underlying changes I've made and I was chalking up this looping behavior to the warning, pending my debugging/fixing the warning (which is in progress). Would be interesting to know if you can eliminate that possible cause, if you aren't operating under that warning.
FMP24060
phpLister
 
Posts: 6
Joined: 2:15pm, Sun 09 Dec, 2007

Postby hksoftware » 1:11pm, Sat 05 Jan, 2008

FMP24060 wrote:Are you by chance getting the "magic quotes" warning about a PHP setting? I've just started getting that warning due to some underlying changes I've made and I was chalking up this looping behavior to the warning, pending my debugging/fixing the warning (which is in progress). Would be interesting to know if you can eliminate that possible cause, if you aren't operating under that warning.


Thanks for your reply.
I can confirm that I am NOT getting that warning, and my magic_quotes is set correctly (on I think)
hksoftware
phpLister
 
Posts: 6
Joined: 1:16pm, Thu 03 Jan, 2008

Postby hksoftware » 5:12pm, Tue 08 Jan, 2008

Somebody must be able to help!

When I run the batch again, the email address is remembered and it keeps trying that.

Which table in the database keeps track of which addresses have not received an email for each list?
hksoftware
phpLister
 
Posts: 6
Joined: 1:16pm, Thu 03 Jan, 2008

Postby krisdepaepe » 11:33pm, Sun 20 Jan, 2008

check this out (for MySQL):

Code: Select all
SELECT *
FROM `phplist_eventlog`
WHERE entry LIKE '%Error sending message%'


all errors come into the eventlogtable...

but the strange thing about it, is that the addresses who failed are correct.
Anyone?
krisdepaepe
phpList newbie
 
Posts: 2
Joined: 11:30pm, Sun 20 Jan, 2008

Postby hksoftware » 7:16pm, Tue 22 Jan, 2008

Excellent, got it!

the dodgy email address was:
fdasjd;as@fdjald.com

Is there a way to get PHPList to check if an email exists? or even to screen for the semicolon?

Thanks
hksoftware
phpLister
 
Posts: 6
Joined: 1:16pm, Thu 03 Jan, 2008

Postby krisdepaepe » 7:30pm, Tue 22 Jan, 2008

manage users > reconcile users > find users who have an invalid email

other possibility in PHPMyAdmin:
SELECT * FROM `phplist_user_user`
WHERE email LIKE '%;%';

instead of '%;%', you can choose to use other non-valid chars.
krisdepaepe
phpList newbie
 
Posts: 2
Joined: 11:30pm, Sun 20 Jan, 2008

Postby hksoftware » 7:49pm, Mon 28 Jan, 2008

Thanks very much for your help, I didn't know you can find invalid email addresses from within PHPList.

Hopefully I'll now be able to leave PHPList running overnight without fear of my mailbox filling with error emails!
hksoftware
phpLister
 
Posts: 6
Joined: 1:16pm, Thu 03 Jan, 2008

Postby revista » 12:57am, Thu 24 Jul, 2008

The same thing is happenning to me. I have not been able to find the emails with invalid caracters.
I have reconciled users every time I send my newsletter without success.

The message gets stuck in the last 8 or 10 emails and can not finish sending the message.

I have looked for invalid caracters like:
;:·$%&/()=?¿^*¨Ç etc etc and I can not find the bad users.

How else can I delete them?
If they are wrong they most have not recieved any message correct?
Where can I search for users with 0 messages?
Is there any other idea on how to find this bad users which are messing up my send?
revista
PL Geek
 
Posts: 54
Joined: 3:41am, Sat 14 Jun, 2008

Postby revista » 2:33am, Wed 27 Aug, 2008

This problem has been a pain in the ass. This problem should be very simple to solve just by being able to see which users on the list have recieved 0 messages.

Where on the mysql tables can I see the users which have recieved 0 messages?
revista
PL Geek
 
Posts: 54
Joined: 3:41am, Sat 14 Jun, 2008

Postby jaysprout » 1:47pm, Wed 27 Aug, 2008

The solution from krisdepaepe worked great! One thing to keep in mind is this: search for @@ symbol even though @ is a legitimate character! In my case, an email address had two of them!
jaysprout
PL Nut
 
Posts: 38
Joined: 6:00pm, Wed 02 Apr, 2008
Location: Bradenton, FL

Postby revista » 1:53pm, Wed 27 Aug, 2008

How do I see which users have not recieved any mails?
Its amazing in a OS like this you cant check users by recieved messages.
revista
PL Geek
 
Posts: 54
Joined: 3:41am, Sat 14 Jun, 2008

Postby jaysprout » 5:03pm, Wed 27 Aug, 2008

Can't you just run the above query in the event log? I'm sure you could run a query that would bring up users who have zero messages, too ... I just don't know how to write it.
jaysprout
PL Nut
 
Posts: 38
Joined: 6:00pm, Wed 02 Apr, 2008
Location: Bradenton, FL

Next

Return to Advanced Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest