WordPress.org

1. mo0
   Member
   Posted 4 months ago #

   hey there. seeking to delete Scheduled posts. the SQL query i *believe* i'm after is as follows (but i'm worried about orphaned tables):

   DELETE FROM wp_posts WHERE post_date < '2010-01-01 17:00:00' AND post_status = 'what string here??'

   i tried it, but no rows are deleted.

   essentially, am looking to speed up my blog due to the following problems:

   All (31,885) |
   Published (29,953) |
   Scheduled (1,829) |
   Drafts (100) |
   Private (3) |
   Trash (118)

   - Bulk Delete plugin = times out
   - Showing 999 posts then deleting = server fail

   any SQL query help i can ram into PhPMyAdmin to help out would be excellent!

   thank you in advance.

2. fonglh
   Member
   Posted 4 months ago #

   I think scheduled posts are just posts with a post_date in the future.Perhaps you could just change the post_date condition.

   Do backup your database before trying.

3. mo0
   Member
   Posted 4 months ago #

   hm, i attempted to put 'future' in there as a condition - but no luck. the scheduled posts are all ones that have missed their schedule (as they're feeds).

   appreciate the reply. any other thoughts??

4. fonglh
   Member
   Posted 4 months ago #

   By 'future' I meant post_date > NOW().

   But since you say they've missed their schedule that probably won't work. Is there anything their database entries have in common?

5. mo0
   Member
   Posted 4 months ago #

   hm, nothing beyond their dates being in the past, which is why the string of the date being < 2010 was in there.

   what would post_status be? i looked into the raw post table, which is where i got the 'future' status from.

6. fonglh
   Member
   Posted 4 months ago #

   delete from wp_posts where post_status='future'

   Did you try something like the above?

Reply

You must log in to post.