thx1200
  •  thx1200
  • 61.4% (Friendly)
  • YAF Camper Topic Starter
2017-07-29T03:57:50Z
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
tha_watcha
2017-07-29T15:50:41Z
The easiest way would be via sql

delete FROM [{databaseOwner}].[{objectQualifier}Message] WHERE IsDeleted = 1

UserPostedImage
thx1200
  •  thx1200
  • 61.4% (Friendly)
  • YAF Camper Topic Starter
2017-07-30T01:01:22Z
Thanks! I had no idea it would be that easy. 🙂
Juan hernandez
2017-09-14T23:15:25Z
Awesome, thanks. ive had that issue in the past.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved