Home of the Squeezebox™ & Transporter® network music players.
Page 1 of 2 12 LastLast
Results 1 to 10 of 16
  1. #1
    Senior Member
    Join Date
    Dec 2017
    Location
    PARIS, Fr
    Posts
    233

    full text search media scan terminated unexpectedly

    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:-)
    Attached Files Attached Files
    The Earth Has Music For Those Who Listen

  2. #2
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,719

    full text search media scanterminated unexpectedly

    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?

  3. #3
    Senior Member
    Join Date
    Dec 2017
    Location
    PARIS, Fr
    Posts
    233
    Quote Originally Posted by mherger View Post
    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:-)
    The Earth Has Music For Those Who Listen

  4. #4
    Senior Member
    Join Date
    Jan 2010
    Location
    Hertfordshire
    Posts
    8,923
    Quote Originally Posted by mherger View Post
    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

  5. #5
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,719

    full text search media scanterminated unexpectedly

    > 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?...

  6. #6
    Senior Member
    Join Date
    Dec 2017
    Location
    PARIS, Fr
    Posts
    233
    Quote Originally Posted by mherger View Post
    > 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?
    The Earth Has Music For Those Who Listen

  7. #7
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,719

    full text search media scanterminated unexpectedly

    > 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.

  8. #8
    Senior Member
    Join Date
    Dec 2017
    Location
    PARIS, Fr
    Posts
    233
    Quote Originally Posted by mherger View Post
    > 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
    The Earth Has Music For Those Who Listen

  9. #9
    Senior Member
    Join Date
    Dec 2017
    Location
    PARIS, Fr
    Posts
    233
    Quote Originally Posted by mherger View Post
    > 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
    Attached Files Attached Files
    The Earth Has Music For Those Who Listen

  10. #10
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,719

    full text search media scanterminated unexpectedly

    > 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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •