XF 2 Clear mail queue from xf_job

[Maa]

Version: Latest version of XF.

Hello,

I am looking for some assistance in helping clear the xf_job table with mail queued.

For this, I am willing to pay $15.

Thank you.

 

[Rom]

Version: Latest version of XF.

Hello,

I am looking for some assistance in helping clear the xf_job table with mail queued.

For this, I am willing to pay $15.

Thank you.

truncate xf_mail_queue in phpmyadmin. it's a known issue and if you are still paying for support xenforo will do it for you.

 

[Maa]

truncate xf_mail_queue in phpmyadmin. it's a known issue and if you are still paying for support xenforo will do it for you.

I appreciate your help, however, on the latest version of XF they removed the xf_mail_queue and it is now processed in the xf_job table.

Having it separate was a lot better than incorporating it with xf_job

Ref: https://xenforo.com/community/threa...17243/#-generically-queued-and-retryable-jobs - "..but instead of queueing mails to be sent in their own table, they are now queued directly into the xf_job table."

 

[Chris D]

DELETE FROM xf_job
WHERE execute_class = 'XF\Job\MailSend'

 

[Maa]

DELETE FROM xf_job
WHERE execute_class = 'XF\Job\MailSend'

Thank you!

 

[Chris D]

It's okay

Don't feel that you have to pay money for fairly insignificant changes like that. Just post a thread and usually there's someone who will know what to do.

If it's a more complex issue, someone will usually say, and then you can decide to seek out an add-on, custom development, or some other service.

 

[PASS]

DELETE FROM xf_job
WHERE execute_class = 'XF\Job\MailSend'

I am utilizing AWS SES for sending forum emails. Initially, I forgot to update the email addresses for notifications and 'contact us' to the verified ones on the AWS account, which led to expected errors in the log. Since correcting the email addresses, outgoing emails have been functioning properly.

However, the forum continues to attempt resending emails with the non-verified address, resulting in errors in the log with each cron job execution. How can I clear this from the queue?

I contacted official support via ticket but was basically told there is no official support or fix for this. All I did was saved info in the wrong order in the admin CP.

PS: I don't seem to have a xf_mail_queue table.

Server error log
Symfony\Component\Mailer\Exception\TransportException: Email to removed@outlook.com from removed@outlook.com failed: Expected response code "250" but got code "554", with message "554 Message rejected: Email address is not verified. The following identities failed the check in region US-EAST-1: removed@outlook.com, <removed@outlook.com>, "removed (Testing)" <removed@outlook.com>". src/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php:307
Generated by: Unknown account Dec 10, 2024 at 7:30 AM
Stack trace
#0 src/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(182): Symfony\Component\Mailer\Transport\Smtp\SmtpTransport->assertResponseCode('554 Message rej...', Array)
#1 src/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(218): Symfony\Component\Mailer\Transport\Smtp\SmtpTransport->executeCommand('
.
', Array)
#2 src/vendor/symfony/mailer/Transport/AbstractTransport.php(72): Symfony\Component\Mailer\Transport\Smtp\SmtpTransport->doSend(Object(Symfony\Component\Mailer\SentMessage))
#3 src/vendor/symfony/mailer/Transport/Smtp/SmtpTransport.php(136): Symfony\Component\Mailer\Transport\AbstractTransport->send(Object(Symfony\Component\Mailer\SentMessage), Object(Symfony\Component\Mailer\DelayedEnvelope))
#4 src/XF/Mail/Mailer.php(305): Symfony\Component\Mailer\Transport\Smtp\SmtpTransport->send(Object(Symfony\Component\Mime\Email))
#5 src/XF/Job/MailSend.php(37): XF\Mail\Mailer->send(Object(Symfony\Component\Mime\Email))
#6 src/XF/Job/Manager.php(275): XF\Job\MailSend->run(6.15196)
#7 src/XF/Job/Manager.php(205): XF\Job\Manager->runJobInternal(Array, 6.15196)
#8 src/XF/Job/Manager.php(89): XF\Job\Manager->runJobEntry(Array, 6.15196)
#9 job.php(46): XF\Job\Manager->runQueue(false, 8)
#10 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(29) "https://removed/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[PASS]

Got it all fix. Thanks to the members who contacted me. Seems like an oversite by XF not to includes a tool in the admin CP to clear the mail queue or at least add a warning message about making sure you have verified emails for the Default email address and Contact email address prior to adding or updating SMTP details in the admin CP. Simply doing it out of order causes this problem.