NC 21. Files Retention not displaying current rules

🍱 Features & apps
1

HELP. My Files Retention app doesnt show the current rules anymore. I need to edit/delete some rules but they are missing… How do I get them back??

2

Fixed. I just cleared out the SQL, nextcloud install and nextcloud data directory and re-installed. Works now!

3

Hi!
Same issue here with NC 23.0.2.
Solved by following these hints: https://github.com/nextcloud/files_retention/issues/118

login to sql:
mysql nextcloud_db -u root -p

SELECT * FROM oc_systemtag;
±—±--------------------±-----------±---------+
| id | name | visibility | editable |
±—±--------------------±-----------±---------+
| 4 | auto-delete-1-day | 1 | 1 |
| 3 | auto-delete-1-week | 1 | 1 |
| 2 | auto-delete-2-weeks | 1 | 1 |
±—±--------------------±-----------±---------+
3 rows in set (0.000 sec)

SELECT * FROM oc_retention;
±—±-------±----------±------------±-----------+
| id | tag_id | time_unit | time_amount | time_after |
±—±-------±----------±------------±-----------+
| 1 | 1 | 1 | 2 | 0 |
| 2 | 2 | 1 | 2 | 0 |
| 3 | 3 | 0 | 7 | 0 |
| 4 | 4 | 0 | 1 | 0 |
±—±-------±----------±------------±-----------+
4 rows in set (0.001 sec)

DELETE FROM oc_retention WHERE id = 1;