Number of Queued E-Mails

[helmer.co]

In my admincp it shows Number of Queued E-Mails 20.

How do I clear this?

I have all emails turned off except for notify admin on new user signup and send email on PM. I am receiving email fine except I have had this que display for a month now.

[kh99]

If you don't want those emails sent, you can truncate the mailqueue table in the database.

[helmer.co]

If you don't want those emails sent, you can truncate the mailqueue table in the database.

Thank you for the reply. is there a way to have the system change them? I changed the que from 60 to 5 and went to the timed task to send them and no differce. I actually do not want any que at all, what should I change it too?

[Lynne]

You can turn off queuing in AdminCP > Settings > Options > email options > Use Cron Based Sending > No

[helmer.co]

You can turn off queuing in AdminCP > Settings > Options > email options > Use Cron Based Sending > No

Thank you for your reply. I already had that option set to no. I wonder if that is why I still show emails in the que. Since it was only 20 and I had the que set to 60 "don't know why". I wonder if when I disabled the cron job it left them stuck in the que?

I am currently getting email right away without problems.

[Lynne]

If you didn't empty the queue first and then turned off email queuing, then you will still have the emails sitting in the queue.

[helmer.co]

If you didn't empty the queue first and then turned off email queuing, then you will still have the emails sitting in the queue.

I tured the que back on and went to the cron job to send email. Did not make a difference, still shows 20 in ques. Any ideas?

[ozzy47]

Run this query:

TRUNCATE TABLE mailqueue;

[helmer.co]

Thanks Ozzy!

[ozzy47]

Actually kh99 said to do that in post #2 but just forgot to provide the code. :)