[x] I have checked the existing issues to avoid duplicates
[x] I have redacted any info hashes and content metadata from any logs or screenshots attached to this issue
Describe the bug
Torznab endpoint gives an error when trying to search with a tmdbid or imdbid parameter. season and ep parameters seem to work as expected.
The error is:
failed to search: ERROR: missing FROM-clause entry for table "content" (SQLSTATE 42P01)
To Reproduce
Steps to reproduce the behavior:
Setup Bitmagnet as normal
Visit one of the following paths on a Bitmagnet instance:
/torznab/api?t=tvsearch&tmdbid=1
/torznab/api?t=tvsearch&imdbid=tt1
/torznab/api?t=tvsearch&tmdbid=1&imdbid=tt1
See error
failed to search: ERROR: missing FROM-clause entry for table "content" (SQLSTATE 42P01)
Expected behavior
The endpoints should return results filtered to any of those specific TMDB/IMDb IDs, or an empty result set if there are no matches, instead of erroring.
Environment Information (Required)
Bitmagnet version: 0.7.12 but does not occur in 0.7.10
OS and version: Fedora 39 with podman
Browser and version (if issue is with WebUI): Firefox 123.0
Please specify any config values for which you have overridden the defaults: dht_crawler.scaling_factor=20
Describe the bug
Torznab endpoint gives an error when trying to search with a tmdbid or imdbid parameter. season and ep parameters seem to work as expected.
The error is:
failed to search: ERROR: missing FROM-clause entry for table "content" (SQLSTATE 42P01)
To Reproduce
Steps to reproduce the behavior:
failed to search: ERROR: missing FROM-clause entry for table "content" (SQLSTATE 42P01)
Expected behavior
The endpoints should return results filtered to any of those specific TMDB/IMDb IDs, or an empty result set if there are no matches, instead of erroring.
Environment Information (Required)
0.7.12
but does not occur in0.7.10
Fedora 39
with podmanFirefox 123.0
dht_crawler.scaling_factor=20
Additional context
None