#Users can't request TV unless I grant them 'Manage Users' permission.

15 messages · Page 1 of 1 (latest)

hybrid oyster
#

Good afternoon all! Nice to meet you.

When troubleshooting this issue I came across this issue on GitHub which seems to describe my exact situation: https://github.com/seerr-team/seerr/issues/1964. In that issue one of your collaborators suggested jumping on discord for further troubleshooting, so I'm following suit.

I'm on version 3.1.0 on the Stable channel. Pulled from ghcr.io/seerr-team/seerr. It's running in a k3s cluster accessed by myself and other users via reverse proxy. The issue seems to exist both on mobile devices (android and ios) and multiple browsers.

In the series request dialog for users without 'Manage Users' (everyone but me) the switches are not clickable and do not enable. I see nothing in the logs around the time that a user last tried to request TV.

Thanks for your help!

astral junco
#

Which option would you like?

hybrid oyster
#

Hey! how hard's the db tweak? Do I just need to run a query?

astral junco
hybrid oyster
#

cool! let me know what to run

astral junco
#

sqlite3 /path/to/db/db.sqlite3 "SELECT id, email, permissions FROM user;"

#

I need to see your permission bitmask

hybrid oyster
#
╰─# seerr-db "SELECT id, permissions FROM user;"
┌─────────┬────┬─────────────┐
│ (index) │ id │ permissions │
├─────────┼────┼─────────────┤
│ 0       │ 1  │ 2           │
│ 1       │ 2  │ 16777504    │
│ 2       │ 3  │ 16777504    │
│ 3       │ 4  │ 16777504    │
│ 4       │ 5  │ 16777504    │
│ 5       │ 6  │ 16777504    │
│ 6       │ 7  │ 16777504    │
│ 7       │ 8  │ 16777504    │
│ 8       │ 9  │ 16777504    │
│ 9       │ 10 │ 16777504    │
│ 10      │ 11 │ 16777504    │
│ 11      │ 12 │ 16777504    │
└─────────┴────┴─────────────┘
#

I assume you don't need the emails haha

hybrid oyster
#

Evening! It took a bit of work, but I found and resolved this bug. On the user table the 'tvQuotaLimit' and 'movieQuotaLimit' columns all had the column name as the value for each user (i.e. each user had the literal string "tvQuotaLimit" as the tvQuotaLimit value).

That makes quota?.tv.limit truthy, which causes an early return on the toggle handler.

Not exactly sure how my DB ended up like that... I guess it was caused by the migration from Overseerr or something.

astral junco
#

So far about only 2-3 people iirc had that quota migration issue

#

Ill still take a look at it later

#

Cc: @velvet sandal