Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 6 of 6
  1. #1
    Senior Member
    Join Date
    Jun 2005
    Posts
    422

    "Clear library before rescan" does not completey clear the library

    "Clear library before rescan" seems not in all cases really clean the database. I changed for some file the filenames (removed accented characters) and after a rescan with cleaning the library there were two entries when I search for the song title. One was pointing to the old filename (which did no longer exist) and one to the new (correct) one.

  2. #2
    Perl Commando Dan Sully's Avatar
    Join Date
    Apr 2005
    Location
    Daly City, CA
    Posts
    2,865

    "Clear library before rescan" does notcompletey clear the library

    * dip shaped the electrons to say...

    >"Clear library before rescan" seems not in all cases really clean the
    >database. I changed for some file the filenames (removed accented
    >characters) and after a rescan with cleaning the library there were two
    >entries when I search for the song title. One was pointing to the old
    >filename (which did no longer exist) and one to the new (correct) one.


    Run with --d_sql - you'll see it dropping all of the tables in the database.

    There's something else going on. Do you have a playlist that refers to the old file?

    -D
    --
    Adobe Photoshop - When you want the truth. Real bad.

  3. #3
    Senior Member JJZolx's Avatar
    Join Date
    Apr 2005
    Location
    Colorado
    Posts
    11,531
    Quote Originally Posted by Dan Sully
    * dip shaped the electrons to say...

    >"Clear library before rescan" seems not in all cases really clean the
    >database. I changed for some file the filenames (removed accented
    >characters) and after a rescan with cleaning the library there were two
    >entries when I search for the song title. One was pointing to the old
    >filename (which did no longer exist) and one to the new (correct) one.


    Run with --d_sql - you'll see it dropping all of the tables in the database.

    There's something else going on. Do you have a playlist that refers to the old file?
    A 'clear library' actually drops the tables and then recreates them? Can't you just clear the table and then recover any unused space (in MySQL this would be an 'optimize table' statement)?

    I've had the idea of adding columns to some tables for my own use and doing a drop table would, of course, wipe out any changes.

  4. #4
    Perl Commando Dan Sully's Avatar
    Join Date
    Apr 2005
    Location
    Daly City, CA
    Posts
    2,865

    "Clear library before rescan" does notcompletey clear the library

    * JJZolx shaped the electrons to say...

    >A 'clear library' actually drops the tables and then recreates them?
    >Can't you just clear the table and then recover any unused space (in
    >MySQL this would be an 'optimize table' statement)?
    >
    >I've had the idea of adding columns to some tables for my own use and
    >doing a drop table would, of course, wipe out any changes.


    Yes. It was just a 'DELETE FROM...' before, but then got changed to a DROP
    when we were tracking down some issues. I'll investigate wether it's safe to
    go back.

    -D
    --
    Sir, are you classified as human?
    Uhh, negative, I am a meat popsicle.

  5. #5
    Senior Member
    Join Date
    Jun 2005
    Posts
    422
    I have no playlists but the library was definitely not completey cleared after the rescan. There were entries pointing to files which did not exist. Only after deleting the library manually (slimserversql.db) the entries were gone.

  6. #6
    Senior Member
    Join Date
    Jun 2005
    Posts
    422
    Shame on me...
    I finally found an old playlist created by another program not in the slimserver playlist directory but in an subdirectory to the slimserver music directory. This playlist contained entries pointing to non existing tracks and seems to be read by slimserver (which messed up the library). After deleting this playlist the wrong entries did no longer exist after the next rescan.

Posting Permissions

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