Unable to authenticate.

[runic steppe]

Hello!

I noticed this morning that I was unable to access Overseerr. I run overseerr through a docker container on a syno 920+. When trying to access through web via port 5055, the page just never loads. When trying to access through my reverse proxy, im prompted to sign in via plex and get an "Unable to Authenticate" error. I also use doplarr in discord, and when trying it it also fails out.

I looked at the logs in the container folder, this is the error I see after trying to log in.

Something went wrong authenticating with Plex account {"errorMessage":"SQLITE_ERROR: no such column: user.movieQuotaLimit","ip":"::ffff:172.20.0.1"}

From the logs it looks like everything is still running / scanning.

Full log: https://gist.github.com/stayksauce/56253af7a30f36197a49f120d9fc3400

Any advice on what to try would be appreciated, thank you!

[shell prairie]

I was able to fix this issue by modifying the database files and adding
movieQuotaLimit movieQuotaDays tvQuotaLimit

columns. They were removed for some reason with an update

[queen tendon]

This happnes to me too. can you elaborate on how to fix this? im running overseerr on docker container

[shell prairie]

Look for db.sqlite3 where your Overseerr config is. I'm using docker and unraid so it was in the appdata\overseerr\db.

I stopped Overseerr's container.

I copied that file to another location and edited it with DB Browser. I modified the user table and added fields for movieQuotaLimit, movieQuotaDays , tvQuotaLimit, and (Not sure this last one is necessary) tvQuotaDays and made them all of the type varchar. After saving I copied the db.sqlite3 file I had back to the location of the original file. Started Overseerr again and it worked and allowed me to login

[normal solstice]

im having this issue but when i opened up the file i already had the fields you said you added so it must be something else for me

[worldly harness]

I’m seeing the same issue.

If you’re using the Hotio image that might be the issue. Here are the instructions to fix #645999498203627546 message

[pale light]

@worldly harness I'm having this same issue, but your link #unknown isn't working for me.

[worldly harness]

You need to join Hotio’s Discord

[pale light]

Thanks, I wasn't sure where it was linking