Question Size of kunena/attachments

I manage a Joomla/Kunena that is 15 years old. The size of the media/kunena/attachments folder is over 800M.
Any strategies on how one would reduce the size, delete attachments, or whatever?

Rob

An excellent question, my website has had a Kunena forum for 12 years now and it would be useful to clear out not just old attachments, but old messages too, to reduce the size of the website. It would be useful to be able to sort messages old to new and all categories at the same time.

In the Backend -> Kunena -> Attachments let display multiple attachments (e.g. 300). Sort the attachments by ascending ID. The lower the ID, the earlier the attachment was uploaded. If you select and delete all attachments as in this example, 300 old attachments will have removed.
Or in the Backend -> Kunena -> Tools -> Prune Categories you can select a time frame up to which older topics should be deleted. This deletes older topics including attachments.

> Or in the Backend -> Kunena -> Tools -> Prune Categories
Yes, I have used this to remove archive categories. However, it does result in errors when running diagnostic.  Correcting the diagnostic errors does not seem to cause any problems.
> Backend -> Kunena -> Attachments
Yes, one can do this but there is no way to tell what the impact is, what broken links happen.  I did try this and it generated a bunch of diagnostics.

> Or in the Backend -> Kunena -> Tools -> Prune Categories
Yes, I have used this to remove archive categories. However, it does result in errors when running diagnostic.  Correcting the diagnostic errors does not seem to cause any problems.

I have tested it and cannot confirm diagnostic errors. However, it may happen that orphaned entries or dependencies remain in the database. This will be displayed in the diagnostics. Clicking the "Repair" button will remove these entries. You should always have a database backup before performing this action!

> Backend -> Kunena -> Attachments
Yes, one can do this but there is no way to tell what the impact is, what broken links happen.  I did try this and it generated a bunch of diagnostics.

This action should also remove the links to the attachments from the message. But if the message only contains an image without text, an empty response remains.