I have 2000 scheduled posts in WordPress. I want to change the schedule dates and update mysql database.
update wp_posts SET post_date = FROM_UNIXTIME(
UNIX_TIMESTAMP() + FLOOR(0 + (RAND() * 31557600)))
WHERE post_status = 'future';
update wp_posts SET post_modified = post_date
WHERE post_status = 'future';
update wp_posts SET post_modified_gmt = post_date
WHERE post_status = 'future';
update wp_posts SET post_date_gmt = post_date
WHERE post_status = 'future';
I’m currently getting an error on WordPress admin panel. it is “Missed schedule”.
How can I solve it? Thanks.