Welcome Guest! To enable all features please Login or Register.
Options
View
Go to last post Go to first unread
Offline thx1200  
#1 Posted : Friday, July 28, 2017 9:57:50 PM(UTC)
thx1200


Rank: YAF Camper

Reputation:

Joined: 8/27/2007(UTC)
Posts: 10

I had a flood of spam and I killed the users and the topics got marked as deleted -- that was easy.

But the DB has grown a bit and I want to just nuke the spam posts permanently. How do I do that? I couldn't find a way within the settings. I looked at the DB and can see the flags indicating the topics and messages were deleted, but I want them permanently purged from the DB to reclaim space.

Thanks.
Sponsor
Offline tha_watcha  
#2 Posted : Saturday, July 29, 2017 9:50:41 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,736
Germany

Thanks: 70 times
Was thanked: 1149 time(s) in 979 post(s)
The easiest way would be via sql

Code:
delete FROM [{databaseOwner}].[{objectQualifier}Message] WHERE IsDeleted = 1
Offline thx1200  
#3 Posted : Saturday, July 29, 2017 7:01:22 PM(UTC)
thx1200


Rank: YAF Camper

Reputation:

Joined: 8/27/2007(UTC)
Posts: 10

Thanks! I had no idea it would be that easy. Smile
Offline Juan hernandez  
#4 Posted : Thursday, September 14, 2017 5:15:25 PM(UTC)
Juan hernandez


Rank: YAF Forumling

Reputation:

Joined: 9/14/2017(UTC)
Posts: 2
Man

Awesome, thanks. ive had that issue in the past.
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error