How do I remove duplicate topics?

[larryhyman]

All the duplicates have the same subject, is there a fast easy way for me to remove them?

Thanks

[kat]

Er... Click "Remove" or "Remove topic"?

[larryhyman]

I want to do a mass removal.... I know I can to this with a MySql Query.... after that's done, do I run the:
Admin -> Recount all forum totals and statistics?

Thanks

[Mari-chi]

If I'm understanding you correctly, you just want to remove some topics, yeah? Try enabling the quick-moderation as checkboxes; that way you can select whatever topics you need to remove, then choose "Remove Topics" from the dropdown at the bottom of the topics page.

[larryhyman]

Topic Solved

1) Put forum in Maintenance mode
2) backed up topics & messages table
3) renamed both tables
4) copied both tables and renamed the copied tables to the original names
5) from navcat (I don't know the proper mysql name for this) ran empty table (on the copies with the original names)
6) ran this query on each table:

INSERT INTO `smfv2rc4_messages` SELECT DISTINCT * FROM `smfv2rc4_messages_old`;
INSERT INTO `smfv2rc4_topics` SELECT DISTINCT * FROM `smfv2rc4_topics_old`;

7) logged into admin, check db, recounted forum posts, check forums, all working, can not see dupes, reopened forums

PS: the reason I had to do this is that the RSSFEEDER Mod brought in 100's of dupes, this fix only took a few secs to do and I would of hated to delete messages one by one in the forums...