Queue not processing

Hi,

I recently upgraded to PHPLIST 3.2.4.

Now, I am trying to send a campaign and it is just sitting in the process queue. I have hit “send campaign” many times. The queue has been sitting there for 5 days. Every time I log in to admin dashboard, the job is listed, I hit “process the queue”, some black text appears for a fraction of a second, it’ then says “all done”, but the campaign stays in the queue and nothing happens. I’ve tried setting the “timer” to 15 or 30 min ahead, and leaving it queued, … nothing.

What am I doing wrong? I’ve used this app for years without a problem.

any help would be appreciated … (my Christmas greeting message is held hostage… ) :frowning:

thanks

gary

php version = 5.3.29

Try upgrading your version of PHP, phpList 3.2.x really needs PHP 5.4+ to work correctly.

@Gary101 Is anything reported in the event log? If not then try enabling verbose in your config file

define('VERBOSE', 1);

thanks for suggestions.
will try the “verbose” option…
my server is webmin based, so upgrading the php is something I have to pay the owners to do; would rather avoid that for now if I can.
here is the event log from the last few send attempts:

1646 2015-12-25 00:42:23 Found them: 1986 to process page: pageaction

1645 2015-12-25 00:42:23 Looking for subscribers
page: pageaction

1644 2015-12-25 00:42:23 Processing message 37
page: pageaction

1643 2015-12-25 00:42:23 Fetching [url’s not allowed in this post…] success
page: pageaction

1642 2015-12-25 00:42:23 Report of processing will be sent by email
page: pageaction

1641 2015-12-25 00:42:23 Please leave this window open. phpList will process your queue until all messages have been sent. This may take a while
page: pageaction

1640 2015-12-25 00:42:23 One campaign to process.
page: pageaction

1639 2015-12-25 00:42:23 Processing has started,
page: pageaction

1638 2015-12-25 00:42:20 Found them: 1987 to process
page: pageaction

1637 2015-12-25 00:42:20 Looking for subscribers
page: pageaction

1636 2015-12-25 00:42:20 Processing message 37
page: pageaction

1635 2015-12-25 00:42:20 Fetching [url’s not allowed in this post…] success
page: pageaction

1634 2015-12-25 00:42:20 Report of processing will be sent by email
page: pageaction

1633 2015-12-25 00:42:20 Please leave this window open. phpList will process your queue until all messages have been sent. This may take a while
page: pageaction

1632 2015-12-25 00:42:20 One campaign to process.
page: pageaction

1631 2015-12-25 00:42:20 Processing has started,
page: pageaction

1630 2015-12-25 00:40:46 Found them: 1988 to process
page: pageaction

1629 2015-12-25 00:40:45 Looking for subscribers
page: pageaction

1628 2015-12-25 00:40:45 Processing message 37
page: pageaction

1627 2015-12-25 00:40:45 Fetching [url’s not allowed in this post…] success

Hello

I tried the “verbose” suggestion and this is the output…
(URL’s had to be masked in this post and email names were changed)

It seems to be sending only 1 email every time I hit the “process queue” button…

1786 2015-12-25 09:38:18 Sending 37 to user31@domain1.com page: pageaction

Del

1785 2015-12-25 09:38:18 Found them: 1976 to process
page: pageaction

Del

1784 2015-12-25 09:38:18 User select query select distinct u.id from phplist_listuser as listuser inner join phplist_user_user as u ON u.id = listuser.userid inner join phplist_listmessage as listmessage ON listuser.listid = listmessage.listid left join phplist_usermessage as um ON (um.messageid = 37 and um.userid = listuser.userid) where listmessage.messageid = 37 and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled
page: pageaction

Del

1783 2015-12-25 09:38:18 Looking for subscribers
page: pageaction

Del

1782 2015-12-25 09:38:18 Processing message 37
page: pageaction

Del

1781 2015-12-25 09:38:18 Fetching [url’s not allowed in this post…] success
page: pageaction

Del

1780 2015-12-25 09:38:18 fetched [url’s not allowed in this post…] status 200
page: pageaction

Del

1779 2015-12-25 09:38:18 [url’s not allowed in this post…] fetching with curl
page: pageaction

Del

1778 2015-12-25 09:38:18 sending of this campaign will stop, if it is still going in 176 days 19 hours 21 minutes 42 seconds
page: pageaction

Del

1777 2015-12-25 09:38:18 Report of processing will be sent by email
page: pageaction

Del

1776 2015-12-25 09:38:18 Please leave this window open. phpList will process your queue until all messages have been sent. This may take a while
page: pageaction

Del

1775 2015-12-25 09:38:18 One campaign to process.
page: pageaction

Del

1774 2015-12-25 09:38:18 Processing has started,
page: pageaction

Del

1773 2015-12-25 09:38:18 select id from phplist_message where status not in (“draft”, “sent”, “prepared”, “suspended”) and embargo
page: pageaction

Del

1772 2015-12-25 09:38:16 Sending 37 to user32@domain.com
page: pageaction

Del

1771 2015-12-25 09:38:16 Found them: 1977 to process
page: pageaction

Del

1770 2015-12-25 09:38:16 User select query select distinct u.id from phplist_listuser as listuser inner join phplist_user_user as u ON u.id = listuser.userid inner join phplist_listmessage as listmessage ON listuser.listid = listmessage.listid left join phplist_usermessage as um ON (um.messageid = 37 and um.userid = listuser.userid) where listmessage.messageid = 37 and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled
page: pageaction

Del

1769 2015-12-25 09:38:15 Looking for subscribers
page: pageaction

Del

1768 2015-12-25 09:38:15 Processing message 37
page: pageaction

Del

1767 2015-12-25 09:38:15 Fetching [url’s not allowed in this post…] success
page: pageaction

Del

1766 2015-12-25 09:38:15 fetched [url’s not allowed in this post…] status 200
page: pageaction

Del

1765 2015-12-25 09:38:15 [url’s not allowed in this post…] fetching with curl
page: pageaction

Del

1764 2015-12-25 09:38:15 sending of this campaign will stop, if it is still going in 176 days 19 hours 21 minutes 45 seconds
page: pageaction

Del

1763 2015-12-25 09:38:15 Report of processing will be sent by email
page: pageaction

Del

1762 2015-12-25 09:38:15 Please leave this window open. phpList will process your queue until all messages have been sent. This may take a while
page: pageaction

Del

1761 2015-12-25 09:38:15 One campaign to process.
page: pageaction

Del

1760 2015-12-25 09:38:15 Processing has started,
page: pageaction

Del

1759 2015-12-25 09:38:15 select id from phplist_message where status not in (“draft”, “sent”, “prepared”, “suspended”) and embargo
page: pageaction

Del

1758 2015-12-25 09:38:14 Sending 37 to user33@domain.com
page: pageaction

Del

1757 2015-12-25 09:38:14 Found them: 1978 to process
page: pageaction

Del

1756 2015-12-25 09:38:14 User select query select distinct u.id from phplist_listuser as listuser inner join phplist_user_user as u ON u.id = listuser.userid inner join phplist_listmessage as listmessage ON listuser.listid = listmessage.listid left join phplist_usermessage as um ON (um.messageid = 37 and um.userid = listuser.userid) where listmessage.messageid = 37 and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled
page: pageaction

Del

1755 2015-12-25 09:38:14 Looking for subscribers
page: pageaction

Del

1754 2015-12-25 09:38:14 Processing message 37
page: pageaction

Del

1753 2015-12-25 09:38:14 Fetching [url’s not allowed in this post…] success
page: pageaction

Del

1752 2015-12-25 09:38:14 fetched [url’s not allowed in this post…] status 200
page: pageaction

Del

1751 2015-12-25 09:38:14 [url’s not allowed in this post…] fetching with curl
page: pageaction

Del

1750 2015-12-25 09:38:14 sending of this campaign will stop, if it is still going in 176 days 19 hours 21 minutes 46 seconds
page: pageaction

Del

1749 2015-12-25 09:38:14 Report of processing will be sent by email
page: pageaction

Del

1748 2015-12-25 09:38:14 Please leave this window open. phpList will process your queue until all messages have been sent. This may take a while
page: pageaction

Del

1747 2015-12-25 09:38:14 One campaign to process.
page: pageaction

Del

1746 2015-12-25 09:38:14 Processing has started,
page: pageaction

Del

1745 2015-12-25 09:38:14 select id from phplist_message where status not in (“draft”, “sent”, “prepared”, “suspended”) and embargo
page: pageaction

Del

1744 2015-12-25 09:38:13 Sending 37 to user34@domain.com
page: pageaction

Del

1743 2015-12-25 09:38:13 Found them: 1979 to process
page: pageaction

Del

1742 2015-12-25 09:38:13 User select query select distinct u.id from phplist_listuser as listuser inner join phplist_user_user as u ON u.id = listuser.userid inner join phplist_listmessage as listmessage ON listuser.listid = listmessage.listid left join phplist_usermessage as um ON (um.messageid = 37 and um.userid = listuser.userid) where listmessage.messageid = 37 and listmessage.listid = listuser.listid and u.id = listuser.userid and um.userid IS NULL and u.confirmed and !u.blacklisted and !u.disabled
page: pageaction

Del

1741 2015-12-25 09:38:13 Looking for subscribers
page: pageaction

Del

1740 2015-12-25 09:38:13 Processing message 37
page: pageaction

Del

1739 2015-12-25 09:38:13 Fetching [url’s not allowed in this post…] success
page: pageaction

Del

1738 2015-12-25 09:38:13 fetched [url’s not allowed in this post…] status 200
page: pageaction

Del

1737 2015-12-25 09:38:13 [url’s not allowed in this post…] fetching with curl
page: pageaction

What are the batch settings?
It’s not very clear what is happening after phplist selects one email to be sent, between 09:38:16 and 09:38:18

1773    2015-12-25 09:38:18    select id from phplist_message where status not in ("draft", sent", "prepared", "suspended") and embargo
1772    2015-12-25 09:38:16    Sending 37 to user32@domain.com

1771    2015-12-25 09:38:16    Found them: 1977 to process

Are you pressing the process queue button again, or just letting it continue?

The most reliable way of sending is to use a cron job, so I suggest setting-up as described in the online documentation https://www.phplist.org/manual/ch036_setting-up-your-cron.xhtml

hi Duncan,

What I normally always do, is never touch the “timer” that sets the queue to go off at a future time, but always just “send now”, by pushing that corresponding button. Lately though, the queue is not processing, it’s just sitting there, perhaps sending one email every time I re-attempt the “send queue” button.

To experiment to see if the queue would send if I “timed” a “future” send, i set the timer, twice I believe, for 15 min ahead of current time. I don’t know which log event corresponds to the “timed queues” and which corresponds to my pressing the “process queue” button. If the timed event didn’t work, I might have pressed the “process queue” button several times out of frustration.

I’m not really adept at the intricacies of PHP, so I’m not good at deciphering what goes on in the background. I’ve used this app for years without encountering this problem.

thanks again,

Gary

I don’t know what you mean by “timer”? Do you mean setting the embargo time to be in the future?

I asked what the batch settings are in your config.php file. Those might be affecting what is happening.

When you send through the browser, by clicking the button or link to process the queue, you need leave the browser open on that page. if you navigate away then the processing will stop.

But the most effective way is to use a cron job that runs directly on the web server. If you are not able to create cron jobs with your hosting company then you can try the remote queue processing that is offered by phplist.com see https://www.phplist.org/manual/ch035_methods-of-sending-browser-cron-command-line.xhtml