Jellyseer showing non-existing requests

[Joly0]

Description

Hey, i have a weird problem with the requests of my jellyseer instance:

Somehow it shows 2 requests, but there are no pending onces. Also no failed onces. There are just a lot of unavailable, available and and processing ones, but this is to be expected.
But where are those 2 are coming from? Can i somehow check this? Is this stored in a database somewhere?

Version

2.5.1

Steps to Reproduce

I have no clue

Screenshots

No response

Logs

Platform

desktop

Database

SQLite (default)

Device

None

Operating System

None

Browser

None

Additional Context

No response

Code of Conduct

• I agree to follow Jellyseerr's Code of Conduct

[fallenbagel]

Check the database. Could be two corrupted requests

[fallenbagel]

Could also be related to #1431

[Joly0]

Check the database. Could be two corrupted requests

Ok, so i was able to open the sqlite3 database using db browser for sqlite, but i am not sure what i should be looking for to figure out the problem. I do know how to work with sqlite3 databases, but i am not sure what i am looking for in there

[Makifun]

I also have this issue. I had it since Overseerr though but I migrated today and so I also migrated my "1" pending invisible request that I have had for a few years now.

I tried using sqlitebrowser and removed something that looked strange(no mediaId on one row) but it didn't make a difference.

Any hints of what could be a corrupted request? What it might look like? :)

[fallenbagel]

sct/overseerr#4100

[Joly0]

sct/overseerr#4100

Hey, this looks like the problem we are having. Is this also a thing in jellyseer and if so, will this be implemented aswell?

[fallenbagel]

sct/overseerr#4100

Hey, this looks like the problem we are having. Is this also a thing in jellyseer and if so, will this be implemented aswell?

The reason why i linked the pr means it's coming. Soon.