Blank/Empty Request Card

[JohnnyGrey86]

Describe the bug
A blank, pulsing request card appears on the home screen, as well as the requests page. After some Discord discussion, we discovered this is from a deleted TMDB page. The movie in question now appears under a different number, resulting in this card endlessly attempting to "load."

What version of Overseerr are you running?
develop-d00e470b55327489b49d770144b7cfdb24045be6

You can find it under: Settings -> About -> Version

To Reproduce
Not applicable.

Expected behavior
As sct mentioned in Discord, a proper error message should show, along with the presence of a delete button.

Screenshots

Desktop (please complete the following information):

• OS: Win10 Pro
• Browser Chrome
• Version 87.0.4280.88 (Official Build) (64-bit)

[dirtycajunrice]

For those that are experiencing the issue currently, if you would like to remove the entry, and that is the only item that is in requested status:

docker exec -it <name of container> sh
apk add sqlite
DB="/app/config/db/db.sqlite3"
BAD=$(sqlite3 ${DB} "SELECT id FROM media_request WHERE status=1 LIMIT 1; ")
sqlite3 ${DB} "DELETE FROM season_request WHERE requestId=${BAD};"
sqlite3 ${DB} "DELETE FROM media_request WHERE id=${BAD};"

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[sct]

We good stalebot.

[github-actions]

🎉 This issue has been resolved in version 1.23.0 🎉

The release is available on:

• v1.23.0
• GitHub release

Your semantic-release bot 📦🚀