Unable to toggle Seasons

[north shale]

I was told to come here for troubleshooting.
"This is related to a corrupted user quotas in your db. Please hop onto discord for troubleshooting. This is not a bug but a db record corruption."

If there's instructions on how to fix it, I'm pretty sure I can follow it.

Thanks

[ember citrus]

Hello

Are you comfortable with running sqlite queries?

[north shale]

Yes I am! 🙂

[ember citrus]

Great! Let me give you some instructions hold on

Could you stop seerr

Then run

sqlite3 /path/to/your/db.sqlite3 "SELECT id, email, typeof(movieQuotaLimit), movieQuotaLimit, typeof(tvQuotaLimit), tvQuotaLimit FROM user WHERE typeof(movieQuotaLimit) = 'text' OR typeof(tvQuotaLimit) = 'text';"

Show me what it returns

[ember citrus]

Yup as i suspected

@north shale deleted your message as it contained emails. I forgot to remove that from query

But as I suspected

You need to run the following queries in your db

UPDATE user SET movieQuotaLimit = NULL WHERE typeof(movieQuotaLimit) = 'text';

UPDATE user SET movieQuotaDays = NULL WHERE typeof(movieQuotaDays) = 'text';

UPDATE user SET tvQuotaLimit = NULL WHERE typeof(tvQuotaLimit) = 'text';

UPDATE user SET tvQuotaDays = NULL WHERE typeof(tvQuotaDays) = 'text';

After that rerun

sqlite3 /path/to/your/db.sqlite3 "SELECT id, typeof(movieQuotaLimit), movieQuotaLimit, typeof(tvQuotaLimit), tvQuotaLimit FROM user WHERE typeof(movieQuotaLimit) = 'text' OR typeof(tvQuotaLimit) = 'text';"

^ this query will not return emails now. When you paste in output always use ``` so its easier for me to read

[north shale]

Thanks for that tip. It returned no output. Is that what's expected?

Hey that seems to have worked! Thank you so much! Also I really appreciate your guys' work on the software. ❤️

[ember citrus]

Yes

[ember citrus]

Glad it worked!

[winged obsidian]

was this broken by an update or user error? i’m getting same issue for managed accounts.

[ember citrus]

It was broken by overseerr bug so migration did that. Fresg overseerr -> 3.2.0 wont do that as we added an extra thing to clean that up

[ember citrus]

Just run the queries above.

[winged obsidian]

oic