Loading...
 
Features / Usability

Features / Usability


How do I remove a large number of spam forum posts?

posts: 84
How can I remove a large number of spam forum posts without having to individually select each post to delete? I currently have Tiki 8.2 installed. Thanks.
posts: 84

xavi,

I don't see how to mass delete. I went to forums >> list forums. Then what? I can click on the name of the forum. From there I can individually delete posts. But I have to do it individually, and I am only shown ten posts at a time.


posts: 214

I think what xavi meant was to use the Image "Delete Selected Topics" option, after checking all the boxes in front of the titles you wanted to delete.

The number of forum posts displayed can be changed in Admin > Forums, "Default number per page:".

If you did not allow attachments, then you could use phpmyadmin to delete all the posts by a user. The forum posts are kept in the tiki_comments table. In the SQL tab enter:

Copy to clipboard
delete from tiki_comments where userName = "the user name of the spammer";

If you allowed attachements, I am not sure what would happen to the orphaned attachments if you deleted the posts that way.

Tom


posts: 1817 Catalan Countries

Thanks Tom. Yes, I meant that.
Xavi


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting