SMF Support > SMF 2.0.x Support

How to empty planty of spam posts

(1/2) > >>

fmben:
1.I have more than 200000 threads, how to empty them, and it's all belong to one period like the lastest 6 months, i just want to delete all of them with this period.

2.And i find that some of the table have planty of data, how to empty them, because the smf becomes slow now.
like:
log_actions
log_boards
log_digest
log_notify
log_search_subjects

can the above table just empty them? especially the the log_search_subjects, has 2,086,639 records!!

Thanks. And someone know how to block all the post that have links within the thread content?

ziycon:
I would suggest looking in the mod site for anti-spam mods (http://custom.simplemachines.org/mods/).

Are there topics you would like to keep or do you want to just remove everything?

fmben:

--- Quote from: ziycon on August 09, 2012, 06:54:25 AM ---I would suggest looking in the mod site for anti-spam mods (http://custom.simplemachines.org/mods/).

Are there topics you would like to keep or do you want to just remove everything?

--- End quote ---

I want to keep topics. Just like i want to delete all the topics post in 2012-10-1 to 2012-10-10

Arantor:
Well, you can do that manually with a query - but the odds are it'll break something else because of all the cross joins there are everywhere.

You could, as a simpler alternative, go into your profile and select 'quick moderation as checkboxes', then you can select lots of topics at once from the list of topics and delete them all conveniently.

ahrasis:
I thought we can clean old topics via Administration Center » Forum Maintenance » Topics?

Navigation

[0] Message Index

[#] Next page