Newznab API not working on sqlite DB

[WCAve]

Not sure if this is a docker-spotweb issue or a spotweb issue itself:

when querying the API on the docker configured with sqlite as the database, it will crash on some types of query.

For example the following query:

http://[ip]:[port]/api?t=search&cat=5000,5020,5030,5040,5050,5060,5070,2000,2030,2040,2050,2060&extended=1&apikey=a897c261ba0f0e7cdfdee263091eba73&offset=0&limit=100&q=lubach

This works query fine when using PostgreSQL on my setup, but throws the following error on SQLite

SpotWeb v0.68.39.34 on PHP v8.4.5 crashed HY000: 1: fts5: syntax error near "+"

[KoalaBear84]

I guess it's the inner workings of Spotweb and should be logged on https://github.com/spotweb/spotweb

[KoalaBear84]

Just for reference, issue is created I see: https://github.com/spotweb/spotweb/issues/893

[edv]

Good to see they fixed it upstream. I will close this issue.