SQL: [MyMusic82.db] SQLite error SQLITE_ERROR (a JOIN clause is required before ON)

entropyagent · December 23, 2022 at 11:29 AM

I have encountered the above error in my Rpi 3B+ nightly-20221205-ae18370 LibreELEC Kodi setup, used mostly for music. I reported it on the Kodi forum, in this thread

and it was suggested it might be polite to mention it here.

frakkin64 · December 23, 2022 at 7:06 PM

Looks like SQL is poorly formatted in Kodi. It appears it was introduced in PR #19578 upstream. There may be other SQLs that were reformatted with similar issues.