Failed email, endless loop...

Solutions for other advanced phplisters

Postby CS » 6:57pm, Thu 28 Aug, 2008

Try the following query:

Code: Select all
SELECT * FROM phplist_usermessage WHERE status = "invalid email";


It should return a list of users with invalid emails.
CS
 

Postby revista » 7:16pm, Fri 12 Sep, 2008

me neither, this should be a function within php list. Such a simple and necessary thing
revista
PL Geek
 
Posts: 54
Joined: 3:41am, Sat 14 Jun, 2008

PHPList emails failed solution

Postby Guest » 6:44pm, Thu 25 Dec, 2008

PHPList has a feature to mark the failed emails unconfirmed, so it doesn't go in the endless loop giving you the "xx emails failed (will retry later)", but it comes turned off. To activate it go to /lists/admin/processqueue.php and edit comment out this two lines with "//":

Code: Select all
# make sure it's not because it's an invalid email
# unconfirm this user, so they're not included next time
//if (!$throttled && !validateEmail($useremail)) {
logEvent("invalid email $useremail user marked unconfirmed");
Sql_Query(sprintf('update %s set confirmed = 0 where email = "%s"',
$GLOBALS['tables']['user'],$useremail));
//}
Guest
 

Postby jackbremer » 2:52pm, Mon 29 Dec, 2008

lokushara, you star - this worked a treat.

To clarify, you need to add in the // on the two lines that lokushara showed - they won't be there when you first look.

This unconfirmed a load for me (125) of bad data such as:

email1@domain.com ; email2@domain.com (you'll have to split these manually into two subscribers)
email@my_domain.com (I guess underscores aren't allowed - fix these by changing to - instead)
email@domain@domain.com (difficult to search for before importing as the @@ aren't together)

If PHPList could add these sorts of error checking to the import function that would be awesome - no more messed up data!

Thanks to all for the fix and discussion - we got there in the end!
jackbremer
PL Geek
 
Posts: 100
Joined: 10:28am, Thu 22 Jun, 2006

Re: Failed email, endless loop...

Postby houseofcakes » 4:36pm, Thu 29 Oct, 2009

Thanks for that "comment out lines" tip! It worked! I got stuck in the endless "reloading and resending messages". . .

Then I can check the unconfirmed and see if their emails are valid. . .
houseofcakes
PL Nut
 
Posts: 17
Joined: 4:35pm, Wed 17 Jun, 2009

Re: Failed email, endless loop...

Postby a7med » 5:18pm, Thu 10 Jun, 2010

Guest wrote:PHPList has a feature to mark the failed emails unconfirmed, so it doesn't go in the endless loop giving you the "xx emails failed (will retry later)", but it comes turned off. To activate it go to /lists/admin/processqueue.php and edit comment out this two lines with "//":

Code: Select all
# make sure it's not because it's an invalid email
# unconfirm this user, so they're not included next time
//if (!$throttled && !validateEmail($useremail)) {
logEvent("invalid email $useremail user marked unconfirmed");
Sql_Query(sprintf('update %s set confirmed = 0 where email = "%s"',
$GLOBALS['tables']['user'],$useremail));
//}

not sure this works, i've checked the emails it has marked unconfirmed, they're actually valid emails, the significant thing about them is they're in this format abc@xyz.net.xx, they're actually valid, they're just not the typical abc@xyz.com, can that be fixed?
a7med
phpList newbie
 
Posts: 4
Joined: 5:14pm, Thu 10 Jun, 2010

Previous

Return to Advanced Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest