Help! Can someone please tell me how to delete unsent newsletters out of the admin panel in Magento? I want to get rid of all of these except the one that is sent. Thanks much.
Magento – Delete Newsletters out of queue in admin panal
cronnewsletter
Related Solutions
It would appear that you have it rendering in two places: left.newsletter and footerNewsLetter.
So try
<checkout_cart_index>
<remove name="footerNewsletter"/>
</checkout_cart_index>
<checkout_cart_index>
<remove name="left.newsletter"/>
</checkout_cart_index>
local.xml belongs under a theme in your package like so:
app\design\frontend\my-theme\default\layout\local.xml
You also should reference the parent block the newsletter was declared in.
<checkout_cart_index>
<reference name="footer">
<remove name="footer.newsletter"/>
</reference>
</checkout_cart_index>
UPDATE
Magento looks first for files in here app/design/frontend/custom_package/custom_theme/
then it looks for files in here app/design/frontend/custom_package/default
then it looks in here app/design/frontend/base/default
It will also look in the currently configured theme hierarchy for a local.xml
UPDATE
In your local.xml you are giving the block an alias footerNewsletter, you could also use that in your remove statement. Also like Amit says in his more precise answer, you should be using the cart controller in your layout update.
<checkout_cart_index>
<reference name="footer">
<remove name="footerNewsletter"/>
</reference>
</checkout_cart_index>
UPDATE
If you are unsure of how Magento's Theme Hierarchy works, I would suggest reading through the knowledge base article on the subject
You can set your package to be live on the site by going to System -> Configuration -> Design. Then use your custom_package name
Ok, i think i have got the solution for the double IDs in the table core_email_queue_recipients of the Magento DB.
I don't exactly know which one of the three extensions is responsible, but i am now sure that it was one of them.
I deactivated the following Modules (which i never really needed) in the Magento configuration:
Aschroder_SMTPPro,
Mage_Advancedsmtp,
Mage_Advancesmtp
One of these 3 Extension ist responsible for "sending" something like an "Insert Ignore".
After that i cleaned the cache and now i have ongoing Message Ids and no more wrong recipients of order confirmations! Hope that works for others with the same problem too! Thx
Best Answer
Try this code. You need to create a new php file in the root directory of magento. Let it me
NLqueueResetter.php
.By default script will delete all queue items except that are already sent. If you need to keep any other type queue, just comment corresponding if statement.
Now load this file by requesting
www.domain.com/NLqueueResetter.php
. I didnt try this code before. But it would work I think.[This answer is a part of #mageStackDay. It is an event conducted by Magento Community members as part of increasing the question-answer ratio. For more information http://www.magestackday.com/]