[GH-ISSUE #1128] deleting user doesn't delete corresponding topics which remain stale in database #793

New issue

Open

opened 2026-05-07 00:27:36 +02:00 by BreizhHardware · 0 comments

BreizhHardware commented

2026-05-07 00:27:36 +02:00

Owner

Originally created by @tolap22 on GitHub (Jun 5, 2024).
Original GitHub issue: https://github.com/binwiederhier/ntfy/issues/1128

🐞 Describe the bug
execute following commands:

ntfy user add phil
ntfy access phil mytopic rw
ntfy user del phil
ntfy access --reset phil mytopic

response:

reset access for user phil
user phil does not exist

what happened is that deleting user phil deleted it from sqlite3 user.db table "user" but didn't reset the corresponding topics in table "user_access" which will keep stale lines for topics associated to non existing users.

Originally created by @tolap22 on GitHub (Jun 5, 2024). Original GitHub issue: https://github.com/binwiederhier/ntfy/issues/1128 :lady_beetle: **Describe the bug** execute following commands: ntfy user add phil ntfy access phil mytopic rw ntfy user del phil ntfy access --reset phil mytopic response: reset access for user phil user phil does not exist what happened is that deleting user phil deleted it from sqlite3 user.db table "user" but didn't reset the corresponding topics in table "user_access" which will keep stale lines for topics associated to non existing users.