• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Fixed deleting a forum doesn't delete its threads

Wootalyzer

Active member
#9
I'm surprised this bug is still around. I deleted a large forum today, and low and behold -- all the posts were still lying around in the database. What's the safest way to mass-delete them nowadays?
 

Carlos

Well-known member
#10
I don't want to delete posts while deleting a forum, so give us a prompt to move posts to another forum before deleting the forum.
 

Paul

Well-known member
#12
I have a forum that i wish to remove containing lots of posts - all of which I'm happy to loose - so i take it from the above that if i do this then it wont shrink the database size?

Is there any easy work around that would allow me to carry this out, removing the posts from the DB as would IMO be the "normal" operation?? There's around 100k posts, so it would need to be something simple and not involve deleting them one at a time... ;)

Cheers
Paul
 

Jake Bunce

XenForo moderator
Staff member
#14
Is there any easy work around that would allow me to carry this out
Not really. You could query the database but there are several tables involved. It would be difficult to avoid having orphaned records.

To delete 100k posts you really need a script to process them in batches. There is no utility like this in XenForo right now.
 

Paul

Well-known member
#15
so would my option be to export to IPB or vB, delete the offending forum, and then re-import??? Thats mad! (would that work, and what would i loose?!)
 

Jake Bunce

XenForo moderator
Staff member
#16
so would my option be to export to IPB or vB, delete the offending forum, and then re-import??? Thats mad! (would that work, and what would i loose?!)
Eww don't do that.

This thread is listed as a future fix. If you aren't hurting for space then just delete or hide the forum and wait for the devs to fix the issue.
 

Paul

Well-known member
#17
Eww don't do that.

This thread is listed as a future fix. If you aren't hurting for space then just delete or hide the forum and wait for the devs to fix the issue.
We're talking a large number of posts here, (it's actually well in excess of 1M posts), and it's currently stopping me from downsizing my server - my DB is currently over 1gig, so i want to reduce the size asap..!!
 

MGSteve

Well-known member
#18
I can't believe this is this still outstanding?

C'mon guys, deleting nodes needs to delete the threads within, its basic data relationship management, otherwise you get orphaned threads.

With 1.1 you'll get people with large board migrating over and its a great opportunity to do some tidying up (as I'm doing). We need XF to delete threads within the node that's being deleted.
 

MGSteve

Well-known member
#19
If you aren't hurting for space then just delete or hide the forum and wait for the devs to fix the issue.
I would point out deleting the node is not the answer, you'll end up with orphaned posts with no way to remove them until the devs write a function to find and remove orphaned threads & posts. It would be far easier for them to fix the bug in the first place so we don't get orphaned posts & threads!