Skip to content

Change Back to Original Posted Date (Old Post Promoter)

If you used the Old Post Promoter WordPress plugin, here are the SQL DB queries to revert/rollback the date changes:

UPDATE wp_posts, wp_postmeta
SET wp_posts.post_date_gmt = wp_postmeta.meta_value
WHERE wp_posts.ID = wp_postmeta.post_id and
wp_postmeta.meta_key = ‘bte_opp_original_pub_date’;

UPDATE wp_posts, wp_postmeta
SET wp_posts.post_date = wp_postmeta.meta_value
WHERE wp_posts.ID = wp_postmeta.post_id and
wp_postmeta.meta_key = ‘bte_opp_original_pub_date’;

You need to run both queries.

Tested on WP 4.6 and Old Post Promoter (by BTE) 1.9.3