Every now and then something goes wrong on one of my blogs, and I want to resend an existing post in my next MailPress newsletter. Perhaps I mess up something in the server configuration and mail starts getting lost, but I don't notice for a few posts.
(Be warned, it involves hacking the WordPress database, which can destroy your site if you get it wrong...)
- On the dashboard, choose Posts → All Posts and Edit the post you want to (re)send
- Note the post id “post=n” in the URL
- In another browser window, go to your hosting provider's control panel and open phpMyAdmin
- Select the WordPress database for your blog. If you don't remember it's name, open wp-config.php in your site's root directory and look for the setting DB_NAME.
- Select the table wp_postmeta
- Select Sort By Key: post_id
- Find the entry with post_id “n” and meta_key “MailPress_published”
- Click Delete on that entry.
- Double-check that you're only deleting that entry, not the whole table. (Doing that would destroy your blog).
- Back in the Edit Post window, click Update.
Your post will now go out in the next newsletter.