WordPress

SQL To Change Scheduled Posts To Published

If you ever need to “bulk” change posts (or pages) from Scheduled to Published, you could of course try doing that by carrying out the following instructions.

This is a standard solution for this:

  1. Selecting Desired Posts/Pages.
  2. Click “Bulk Actions” Drop-down.
  3. Click “Edit.”
  4. Click “Apply” button.
  5. Change the “Status” from Scheduled to Published.
  6. Click “Update.”

However, I’ve found that sometimes that does not work, and posts/pages get “stuck” as Scheduled.

If you need to forcefully publish a page, you can do so by going into the install’s phpMyAdmin and…

Run an SQL statement instead:

  1. Click the proper database structure in the left sidebar.
  2. Go to the “SQL” Tab.
  3. Paste in the following code (below).
  4. Click “Go.”
UPDATE wp_posts SET post_status = 'publish' WHERE post_status = 'future';

Note: That will update ALL posts, pages, etc. to be published, if they previously were set to Scheduled.

Need Help?

Tell us about your project!

  • Date Format: MM slash DD slash YYYY
Previous Post
How To Find A Website’s Primary Domain
Next Post
Why We’re Moving All Client Websites to SSL Status

Related Articles

Menu
Google Rating
5.0
Based on 54 reviews
×
Get a Quote