Post Mysql migration difficulty

[PiperMp3]

Summary

After migration to mysql, Ombi still displays entities correctly, but items which used to be "Available" is now no longer marked as Available.
Clicking on the entity, Ombi will now be trying to go url "/details/tv/0" instead of the proper "/details/tv/77169" (an example)
This seems to indicate an ID is now missing from somewhere.
This also occurs on "random" entities in search. I believed its mostly down to /tv/ as so far ive clicked random movie entities, and they all show up correctly, with a proper ID.

Some works as they always did, showing Processing or Available correctly.

Ive attempted a Clear Data and Resync against Plex, though this have not changed matters.

Any idea what might have gone wrong? Is there another clear or reset I should do elsewhere?

Ombi Version

4.44.1

What platform(s) does this occur on?

Docker

What database are you using?

MySQL

Relevant log output

2024-11-26 16:15:08.598 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/73982?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:08.907 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/70625?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:09.118 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/89393?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:19.173 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/36?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:19.340 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/127529?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:27.653 +00:00 [WRN] Episode Episode 0 has no episode number. Skipping.
2024-11-26 16:15:28.219 +00:00 [WRN] Episode Episode 0 has no episode number. Skipping.
2024-11-26 16:15:30.953 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/247518?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:31.111 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/155226?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:31.435 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/2458?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:31.714 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/130330?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:32.023 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/243006?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:32.197 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1486?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:32.404 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/62710?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:32.666 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/4177?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:32.889 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/90462?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:33.100 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/5500?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:15:33.328 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/66840?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 16:16:46.769 +00:00 [WRN] Episode Episode 0 has no episode number. Skipping.
2024-11-26 16:18:58.352 +00:00 [WRN] Episode Episode 0 has no episode number. Skipping.
2024-11-26 16:20:33.776 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/tv/245987/external_ids?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:52:26.070 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/118546?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:52:49.078 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1338?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:52:49.078 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1338?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:52:49.339 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/12301?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:52:49.339 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/12301?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:52:49.654 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/134373?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:52:49.654 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/134373?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:14.260 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/237478?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:14.567 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/212907?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:15.240 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/4607?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:15.507 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/66732?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:16.154 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/69500?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:16.330 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/114473?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:30.562 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/115278?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:30.565 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/115278?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:30.748 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1432?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:30.750 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1432?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:30.912 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/240920?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:30.915 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/240920?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:31.265 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/247721?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:31.268 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/247721?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:31.706 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1981?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:31.711 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1981?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:31.888 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/10826?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:31.889 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/10826?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:32.594 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1395?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:32.595 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/1395?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:32.748 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/135157?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:32.750 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/135157?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:33.790 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/93405?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:33.791 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/93405?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:34.009 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/12323?api_key=b8eabaf5608b88d0298aa189dd90bf00
2024-11-26 19:55:34.011 +00:00 [ERR] StatusCode: NotFound, Reason: Not Found, RequestUri: http://api.themoviedb.org/3/movie/12323?api_key=b8eabaf5608b88d0298aa189dd90bf00