Hello,
I have been using PhpList for about 6 years and that’s how old is the installed app. I don’t know if that causes the problem since the database is very large by now but all of a sudden last Monday though everything else seems to be working fine it stopped sending emails. Below is the log I get …
Any help is greatly appreciated !..
phpList version 3.0.12 (c) 2000-2015 phpList Ltd, http://www.phplist.com
phpList - 0 out of 1 active processes
phpList - Recently sent : 0
phpList - Started [0.0024030000] (87)
phpList - Sending in batches of 200 emails [0.0001540000] (88)
phpList - select id from phplist_message where status not in ('draft', 'sent', 'prepared', 'suspended') and embargo [0.0026180000] (89)
phpList - Processing has started, [0.0034930000] (92)
phpList - One campaign to process. [0.0006090000] (94)
phpList - sending of this campaign will stop, if it is still going in 37 days 22 hours 22 seconds [0.0734670000] (111)
phpList - Processing message 2130 [0.0012190000] (114)
phpList - Looking for subscribers [0.0019100000] (119)
phpList - User select query select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled [0.0006890000] (122)
phpList - Found them: 0 to process [0.0007640000] (126)
phpList - 200 query -> select distinct u.id from phplist_listuser as listuser cross join phplist_user_user as u cross join phplist_listmessage as listmessage left join phplist_usermessage as um on (um.messageid = ? and um.userid = listuser.userid) where true and listmessage.messageid = ? and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled limit 0,200 [0.0006600000] (128)
phpList - Processing batch of: 0 [0.0025940000] (131)
phpList - Processed 0 out of 0 subscribers [0.0001300000] (132)
phpList - Hmmm, No subscribers found to send to [0.0005190000] (134)
phpList - It took very little time to send this message [0.0378140000] (141)
phpList - Script stage: 3 [0.0010050000] (144)
phpList - Finished, Nothing to do [0.0001220000] (145)
phpList - Finished, All done [0.0004010000] (148)