CC made 1000 Scheduled posts in WP, how to delete them?

sqlbyte

Junior Member

Sep 22, 2008

147

35

• Feb 13, 2009

• #1

So i thought to give a shot to autobloging thing, but i screwed the damn thing, it made 1000 Scheduled posts, i don't want them, HOW TO DELETE THEM ?
Is there any way to do that ? I tried deactivating plugin but it doesn't work (i mean it works, but thats what i don't want)
Please help me

 

mark9510

Regular Member

Feb 7, 2009

309

36

• Feb 13, 2009

• #2

which version of wordpress do you use?

 

sqlbyte

Junior Member

Sep 22, 2008

147

35

• Feb 13, 2009
• Thread Starter Thread Starter

• #3

2.6 why ? Is there an option like that in 2.7 ?

 

A

Alexanderia0007

Junior Member

Jan 7, 2009

102

22

• Feb 13, 2009

• #4

No, its how CC works, it schedules the posts.

I dont know if you should trust CC tbh.

 

sqlbyte

Junior Member

Sep 22, 2008

147

35

• Feb 13, 2009
• Thread Starter Thread Starter

• #5

Yes i know it schedules the post, i have 1000+ of those and every hour i am going to get one on my front page of, not so visited, blog :|
How to delete all of them at once ?

 

L

lord

Junior Member

Jan 21, 2009

176

253

• Feb 13, 2009

• #6

you can try directly from the database using phpmyadmin and some mysql knowledge

if you lack those, then you might have to spend some time deleting them


another solution is to delete them all (reinstall wordpress for example) and then re-post the few that have been already posted

 

B

blackhaze

Power Member

Jan 11, 2008

661

168

• Feb 13, 2009

• #7

uhm...deleting them does not get rid of them in the DB, at least the last time i tried.
CC still complaining about dupes, even if posts have been deleted in WP.

So..go to your CPanel, MYSQL databases, phpadmin.

Check your WP database, i think the table is called "wp_posts" or something.

Select this table and EMPTY everything in the table.

I know, its stupid, i actually miss a feature to *really* delete all posts from within WP.

 

mark9510

Regular Member

Feb 7, 2009

309

36

• Feb 13, 2009

• #8

maybe 2.6 doesn't have this but in 2.7 you can check the boxes for all of them and do a bulk delete

 

F

flybeta

Junior Member

Feb 7, 2009

191

15

• Feb 13, 2009

• #9

can just use navicat and connect to it?