getfider / fider

Open platform to collect and prioritize feedback
https://fider.io
GNU Affero General Public License v3.0
2.75k stars 620 forks source link

[BUG] The information in the DB is not purged after deleting from the WebUI #1149

Open SmartPhoneLover opened 9 months ago

SmartPhoneLover commented 9 months ago

Fider Cloud or Self Hosted

Describe the bug When a user creates an issue/suggestion, and then the post (or the file attached) is removed, the attachments are not deleted/purged from the database. So, the DB will grow over time with unlinked attachments. It also applies to comments and posts.

The tables: attachmanets, comments, blobs and posts, maybe others are affected.

Expected behavior The associated data from all the tables are purged from the DB when something is deleted from the WebUI. Or a scheduled (automated) clean up from inside Fider.