@jonas said in SQL error when searching for any song/artist since last week?:

@RallyDarkstrike said in SQL error when searching for any song/artist since last week?:

songs_fts

Newer versions do not use songs_fts, did you downgrade strawberry to an old release?

That did the trick! Downloaded the latest Ubuntu deb file (I'm running Linux Mint) and installed it and all is well now!

There must've been a package downgrade when I did the upgrade from Mint 21.3 to Mint 22.1. I believe it does sometimes downgrade packages t what is in the Mint Repos to help prevent issues so that must be what happened.

Thanks for the prompt reply!

@jonas Not that I am aware of...I did do an upgrade from Mint 21.3 to Mint 22.1 not long back, so maybe Linux downgraded the package as part of the upgrade?

I'll try upgrading Strawberry if it needs it and see if that solves the issue and report back later this evening!

Title says it all - now getting the following SQL error when doing any searches by album/artist/song title in my MP3 collection:

Unable to execute collection SQL query: no such table: songs_fts Unable to execute statement

Failed SQL query: SELECT DISTINCT effective_albumartist FROM songs INNER JOIN songs_fts AS fts ON songs.ROWID = fts.ROWID WHERE fts.songs_fts MATCH ? AND +compilation_effective = 1 AND unavailable = 0 LIMIT 1

Unable to execute collection SQL query: no such table: songs_fts Unable to execute statement

Failed SQL query: SELECT DISTINCT effective_albumartist FROM songs INNER JOIN songs_fts AS fts ON songs.ROWID = fts.ROWID WHERE fts.songs_fts MATCH ? AND unavailable = 0

How would I go about getting things back to normal? I love Strawberry and have been using it for years on my Linux Mint machines and this is the first major hurdle I've ever come across! To my knowledge, I've not changed or altered anything that should affect it?

Thanks for any suggestions!