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.

Read more here: WordPress Scheduled Post Error : "Missed schedule"


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.

Related Wordpress search:

, , , , ,

Wordpress related questions and answers: