[wp-hackers] Help on editing MASSIVE draft posts

Mike Little wordpress at zed1.com
Sat Feb 6 20:58:12 UTC 2010

On 6 February 2010 20:41, Wayne Clayton <michianashopper at gmail.com> wrote:

> I have a client who just installed a plugin ( a week ago) that apparently
> scrapes article sites and Youtube (along with comments) and he has created
> a
> mess for himself. He plugged in about 30 keywords and (fortunately) set it
> to show as a dradt in his WP dashboard. He now has 322 articles as draft
> and
> over 8000 comments. He does want to keep a number of articles and videos
> that came up...but it waaaay to much to go theu screen by screen.
> I need to get this cleaned up for him somehow this weekend...is there any
> advice or steps you'd suggest I go thru to get the dashboard back in
> pre-scraper shape? I think I can edit it in phpMyAdmin..altho' I am not
> that
> familiar with it. Agian ANY advice ot help (short of bipping him in the
> head) would be greatly appreciated.

A couple of suggestions. Can you identify the ones he wants to keep with
search? If so, search for those (in the edit posts page) and publish them,
then you can just delete all the drafts. If you can't publish them yet, set
them all to a future date and publish. You just need to separate them from
the draft ones you don't want.

Or if that is not possible, remember you can specify the number of posts to
show on each page. Drop down the screen options, set it to 50 or 100, then
you only have 6 or 3 screens to go through. Usually it will be quicker to
check everything, then clear the check mark on the ones you want to keep.
Then mass delete/trash.
Presumably most of the comments will also be deleted when you delete the
posts you don't want.

Hope this helps.

Mike Little

More information about the wp-hackers mailing list