Have been following the forum for years, but this is my first posting.
Describe the problem you’re having:
After running on a shared host for years (since 2015) with and old version with simpleupdate mode, I have now moved to a new VPS server. Now running on git download version.
The database dump was over 110 MB, and it did take some time to get it imported on the new server.
I found a lot of record in ttrss_enclosures, that referred to deleted records in ttrss_entries.
No problem updating the database to the new version.
After running the new setup for around a week, I analyzed the database again, and found lot of orphaned records in 3 tabels: ttrss_enclosures, ttrss_tags and ttrss_user_labels2. More than 240000 orphaned records in total, 230000 of them in ttrss_enclosures.
I have searched the code and there don’t seems to be any delete statements handling these orphaned records.
There is code for deleting orphaned record in ttrss_entries table in function purge_orphans() in article.php, and I think this could be expanded to handle orphaned record in ttrss_enclosures, ttrss_tags and ttrss_user_labels2 also.
If possible include steps to reproduce the problem:
Missing cleanup after deleting records in ttrss_entries. Only visible after long time use of Tiny Tiny Rss.
tt-rss version (including git commit id):
Tiny Tiny RSS v19.2 (6825aaf)
Platform (i.e. Linux distro, PHP, PostgreSQL, etc) versions:
VPS server running Ubuntu 18.4, PHP 7.2, MySQL MariaDB 10.1.40