After upgrading from 1.7 to 1.9.1 I have some challenges for the Cron Mail. Mail sends out as it should without any problem.
When the cron job
core/email_queue::cleanQueue is running, it only delete the e-mails (rows) in SQL table
processed_at got a time value indication mail have been sent.
Problem is that in SQL table
core_email_queue_recipients still keep the recipient's e-mail adresses and when new orders arrive, it add new mail addresses with same
recipient_id as previous sent e-mails. Then the new customer and previous (wrong) customer get same e-mail.
Solving: How can I delete any previous date of
core_email_queue_recipients that already got e-mails? Is there something wrong with the DataBase where these two tables should be linked so when e-mail is deleted the recipients should also be deleted? Or should it be an additional deleting process in one of the cron jobs like in
Looks like I only have seen one other person have this problem, so I am not sure how I ended up here. But I am no Magento Expert, so any good advices will be warmly welcome.