Magento – Magento Order emails and the core_email_queue table

emailmagento-1.9.2.0

A quick question regarding this. I'm running Magento 1.9.2.0

Does the core_email_queue table contents get truncated after each cron or does it just fill up? Or does it clear every 24 hours or anything like that?

I've my cron set to 5 mins and appear to potentially have the a lot of emails being sporadicly sent, and clients customers saying they haven't received, though admittedly every test I've performed has went through fine. The processed_at column is being populated etc with relevant times.

I've not sure if mines just stuck? Whats the best way to clear it if it is and what other tables should I do at the same time, is it best to truncate?.

Thanks in advance

Chris

Best Answer

Ok it appears that yes, the core_queue_table and the core_email_queue_recipients tables get cleared, in what I assume to be the usual housekeeping that the cron job performs.

I think the problem that I was facing lies either with the deliverability of the email and / or a over zealous email server at the recipients end.

Related Solutions

Magento – Magento 1.9.1 Order emails not sent – cron checked – stuck in core_email_queue

Have you checked your Magento logs yet? We recently had a client who reported the same symptom on their 1.9.1 installation. When we checked the Magento logs, we discovered that their system was making calls to a PHP module called mb_string() which were failing.

Fatal error: Call to undefined function mb_convert_encoding() in /public_html/lib/Pelago/Emogrifier.php on line 556

That mb_string() function is used in Magento 1.9.1 to strip out CSS styles from your email templates and inline them into your outbound email HTML code for supporting Mail Clients that won’t render CSS 3 styles : http://www.myintervals.com/blog/2014/12/02/magento-and-the-intervals-emogrifier-class/

Their web host did not have this PHP module installed / enabled, so the function calls were throwing errors before the logic that sends the actual message can be executed, causing emails to not be sent.

If your logs show a similar error, you may need to contact your web hosting provider to see if they can enable support for mb_string()

If they don't support it, you'll need to find another host who offers support for it if you want to continue running 1.9.1

If this error isn't being thrown in your logs, you may find one of the answers submitted in this discussion may apply : New order email confirmation not being sent

Magento – Email not sending – core_email_queue not in the database

So as I understand, the tables are present, but there are no entries?

In the current 1.9.x version of MAgento, not all Mails are stored in those tables. Some of them are still sent directly.

Start over by placing an order, and re-validate you database.

If the tables are not created, check out the magento database repair tool. It compares two databases (original and possibly corrupted one) and creates missing table or rows.

cheers

Best Answer

Related Solutions

Magento – Magento 1.9.1 Order emails not sent – cron checked – stuck in core_email_queue

Magento – Email not sending – core_email_queue not in the database

Related Topic