diff options
| author | Samantaz Fox <coding@samantaz.fr> | 2022-01-05 19:58:24 +0100 |
|---|---|---|
| committer | Samantaz Fox <coding@samantaz.fr> | 2022-01-05 19:58:24 +0100 |
| commit | bf0a48847c9f4ab0de002d28a65968e4c44352a2 (patch) | |
| tree | 8c9edcc57daaec6bbcae505684533086833c2bf8 | |
| parent | 3bb7fbb2f119790ee6675076b31cd990f75f64bb (diff) | |
| download | invidious-bf0a48847c9f4ab0de002d28a65968e4c44352a2.tar.gz invidious-bf0a48847c9f4ab0de002d28a65968e4c44352a2.tar.bz2 invidious-bf0a48847c9f4ab0de002d28a65968e4c44352a2.zip | |
DB: fix subscription not being cleared
Fixes https://github.com/iv-org/invidious/issues/2764
| -rw-r--r-- | src/invidious/database/users.cr | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/invidious/database/users.cr b/src/invidious/database/users.cr index 71650918..53724dbf 100644 --- a/src/invidious/database/users.cr +++ b/src/invidious/database/users.cr @@ -143,11 +143,11 @@ module Invidious::Database::Users def clear_notifications(user : User) request = <<-SQL UPDATE users - SET notifications = $1, updated = $2 - WHERE email = $3 + SET notifications = '{}', updated = $1 + WHERE email = $2 SQL - PG_DB.exec(request, [] of String, Time.utc, user) + PG_DB.exec(request, Time.utc, user.email) end # ------------------- |