• Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Duplicate library entries created after organising.

    Scheduled Pinned Locked Moved
    Technical Help
    2
    3
    639
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      choobs
      last edited by

      Hi Folks,

      Doing a bit of consolidating of multiple music folders onto a new disk, using the organise files functionality. When I do this, multiple entries for each track appear in the library (all pointing at the same location (the new one). Rescanning songs and rebuilding the library doesn't help. Any ideas?

      Screenshot from 2020-05-11 10-18-31.png

      jonasJ 1 Reply Last reply Reply Quote 0
      • jonasJ
        jonas
        last edited by

        There is an option in the organize dialog to delete or keep original files. Did you select delete original files?
        Doing a full rescan should normally fix this if there were just duplicates in the DB that are not actually on disk, but you can check it with the following queries in Tools / Console:

        Check if there are songs with identical URL in the DB:

        select url, title, album, artist, count(*) from songs group by url having count(*) > 1 order by count(*) desc;
        

        Check if there are songs with the same artist, album and title in the DB:

        select title, album, artist, count(*) from songs group by title, album, artist having count(*) > 1 order by count(*) desc;
        

        Deleting all the collection directories and readding will delete everything from songs table so if they still appear even when doing that they are probably duplicates on disk.

        1 Reply Last reply Reply Quote 0
        • jonasJ
          jonas @choobs
          last edited by

          @choobs
          There was a bug when organizing songs and moving between different collection directories, it was duplicating the songs in the database. It is fixed now.
          https://github.com/strawberrymusicplayer/strawberry/commit/fb634bc2d41d40e55ecfa23dc39094c007b8e621

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Powered by NodeBB | Contributors