full text search media scan terminated unexpectedly

[Pommes]

Dear Forum,
i installed full text search, and now a rescan terminates unexpectedly at building fulltext index 3 of 7.
I deleted a file which showed in the log, but still the same problem.
could anybody please help?
attached is the scannerlog,
thank you:-)

[mherger]

Hmm...

DBD::SQLite::db do failed: malformed MATCH expression: [type:track mnt
Music Music VARIOUS ARTISTS NIGHTTIME LOVERS VOLUME 25 103 READY OR NOT
flac]

I wonder whether it somehow trips over the "OR NOT", not correctly
handling it as text instead of a query argument?!? But I bet there must
be many more users having that track out there... Does it always crash
on this one?

[Pommes]

Hmm...

DBD::SQLite::db do failed: malformed MATCH expression: [type:track mnt
Music Music VARIOUS ARTISTS NIGHTTIME LOVERS VOLUME 25 103 READY OR NOT
flac]

I wonder whether it somehow trips over the "OR NOT", not correctly
handling it as text instead of a query argument?!? But I bet there must
be many more users having that track out there... Does it always crash
on this one?

Thank you,
I deleted that one file already, did a rescan, then installed the full text search, and still it crashed, so I figured it must have been in one of my playlists. I deleted my playlists, and now everything worked flawlessly.
Weird, but I’m a happy camper now:-)

[slartibartfast]

Hmm...

DBD::SQLite::db do failed: malformed MATCH expression: [type:track mnt
Music Music VARIOUS ARTISTS NIGHTTIME LOVERS VOLUME 25 103 READY OR NOT
flac]

I wonder whether it somehow trips over the "OR NOT", not correctly
handling it as text instead of a query argument?!? But I bet there must
be many more users having that track out there... Does it always crash
on this one?

I have "Genesis - Like It or Not" and "The Lightning Seeds - Ready or Not" in my library with no issues .

Sent from my Pixel 3a using Tapatalk

[mherger]

> I deleted that one file already, did a rescan, then installed the full
> text search, and still it crashed, so I figured it must have been in one
> of my playlists. I deleted my playlists, and now everything worked
> flawlessly.

Oh... you wouldn't have a copy of the old database with the playlist in
it?...

[Pommes]

> I deleted that one file already, did a rescan, then installed the full
> text search, and still it crashed, so I figured it must have been in one
> of my playlists. I deleted my playlists, and now everything worked
> flawlessly.

Oh... you wouldn't have a copy of the old database with the playlist in
it?...

I dont have it, but i can send you the flac file if you would like to test? and i can also try to recreate a playlist with the same song and see if this reproduces the error?
i think i might even still have the playlist itself, but not sure. would this help?

[mherger]

> I dont have it, but i can send you the flac file if you would like to
> test? and i can also try to recreate a playlist with the same song and
> see if this reproduces the error?
> i think i might even still have the playlist itself, but not sure. would
> this help?

Best would be a library.db with the playlist, even if the scan didn't
complete. I wouldn't need the playlist or the flac themselves.

[Pommes]

> I dont have it, but i can send you the flac file if you would like to
> test? and i can also try to recreate a playlist with the same song and
> see if this reproduces the error?
> i think i might even still have the playlist itself, but not sure. would
> this help?

Best would be a library.db with the playlist, even if the scan didn't
complete. I wouldn't need the playlist or the flac themselves.

i tested with a library only containing this one album, and it quits unexpetedly.
I run LMS on Picoreplayer, could you please let me know, how to download the library.db? then i could send you that db.
Thank you

[Pommes]

> I dont have it, but i can send you the flac file if you would like to
> test? and i can also try to recreate a playlist with the same song and
> see if this reproduces the error?
> i think i might even still have the playlist itself, but not sure. would
> this help?

Best would be a library.db with the playlist, even if the scan didn't
complete. I wouldn't need the playlist or the flac themselves.

alright i figured out how to download tyhe database.
attached is the database with only one album, which crashes as soon as i have the playlist included

thank you

[mherger]

> attached is the database with only one album, which crashes as soon as i
> have the playlist included

Thanks, I'll let you know about my findings!