have you cleared your cache ?
Twice before I posted, but I went back now and they’re gone (of course – that’s my luck).
no problem – that’s computers for you !
I currently have 36,000 topics in my pending folder and another 3,000 in the bin. I have tried deleting 250 at a time and i get 504 Gateway error. I’ve reduced it down to 150 and it works. Only problem is that it will take me 72 hours straight with the process lag time, so that a pointless exercise. Is there a way of getting this spam data than using the dashboard option? I have created a dupe forum and moved all data I want and left the old forum with the rubbish in it, however, 39,000 topic entries takes up valuable space I dont have.
Does anyone have a solution other than the above?
you could try this
How To Delete All WordPress Pending Posts
it will delete the posts, but not the post meta, but will tidy up what wordpress displays and make it run faster
yo could then use this to clear out the post meta
Advanced Database Cleaner
Thanks for the quick reply. I tried to run the SQL option to delete the ‘pending’ post etc but it came back with a red box with ERROR in it and ‘#1046 – No database selected’ which I cant work out why.
I’d guess you haven’t clicked the database on the left hand side to get a list of tables in the middle