OR in quicksearch generates SQL error [#9195]

This forum is for reporting bugs in MediaMonkey for Windows 4. Note that version 4 is no longer actively maintained as it has been replaced by version 5.

Moderator: Gurus

acid_g

OR in quicksearch generates SQL error [#9195]

Post by acid_g »

When I want to search for
"*stringA* OR *stringB"
in quicksearch and am not typing fast enought (only
"*stringA* OR"
is typed), the engine already starts searching with second part of the OR condition as an empty string, which causes the following error:
Could not retrieve data "SELECT Songs.*
FROM Songs WHere Songs.ID IN (SELECT rowid FROM SongTest WHERE SongsTest MATCH ' *stringA* OR ')" : SQL logic error or missing database (1, 1)

Best,
acid_g
Post Reply