Please read to the end before starting.
This workaround worked for me !!
Step 1= Copy your hole hard drive to an external 1+ terabyte external hard drive for safety/backup. You should have done this anyway as we are all professionals and know what it's like to loose Data lmao. Also make a note of how many tracks there are in your collection because this will give you an idea of how many duplicate tracks there actually was later in the process.
Mine was 35,678 ffs will let you know what the difference is when it's completed as I'm writing this as I go along.
Step 2= in Rekordbox in collection press ctrl A so all your tracks are highlighted then on the same external drive make a file called full collection and drag the full collection onto that folder.
ALL this will take hours so just leave it to do it's thing. But when it gets close to finishing it will say to you that there is x amount of files with the same name.
Over 12,000 in my case lol click replace then it will only copy one copy of the duplicated files.
Step 3= once all this has finished copying over and this is the scary part but you have backed them all up so close Rekordbox then delete from your PC all your music. Yes I know that sounds mental but you have it all now backed up twice.
Step 4= now copy the file named full collection back over to you PC.
Step 5= Once and only when the files have completed copying your collection back to you PC unplug the external drive and open Rekordbox.
Step 6= Now don't worry Recordbox can't find any of you files/tracks (this is ment to happen) Now we have to let it search for them by opening in Rekordbox , File , display missing files. then all your tracks should show as missing. Now click relocate and find the file with all your collection in and find the first file it's wanting to relocate. DON'T USE THE SEARCH OPTION or it will not work , scroll down It should be in alphabetical order click on the relivant track and click open. Missing file manager will then ask if you want to use this files location to search for all missing files. Click yes and it's will search for all your tracks. Again this will take some time.
Now all being well your Rekordbox will have found all your tracks and you should now have NO duplicate tracks on you PC or in you Rekordbox collection.
Plus saving you space on your PC
You can all thank me later DJMT.ONLINE
WARNING !!!!
You might loose any hot cues loops or gridsync for some of the duplicated files as I'm not yet sure if it keeps the most recent edited file or not.
Please also remember all your tracks will now be in one file on your PC but your playlists will still be in tact.
