Advanced Duplicate Find & Fix 3.8.2 (2014-01-27)

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Mon Dec 11, 2006 9:11 pm

Well, I failed again. Other strange errors now pops up. I will remove the script for now and repost it when a proper bugfix has been done.
PM me if you want the script as is...

Sorry..
/Bex
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

MeMeMe
Posts: 263
Joined: Fri Dec 23, 2005 11:42 am
Location: In front of my computer

Post by MeMeMe » Tue Dec 12, 2006 4:44 am

Good luck with the script.
Bex wrote:@MeMeMe

The add to OK-list works for me. You do know that the feature isn't implemented in the custom search node? The reason for that is that I don't know how to deal with tag/file name changes after the track is added to a custom search OK-list.
I didn't realise that - that's where I was trying to use it from, so all is well.
The 8+2=16 thing can't happen. It's simply impossible, I just rechecked the code...
That's a relief. As I said, I wasn't sure.

Miki
Posts: 141
Joined: Sun Mar 19, 2006 7:01 am
Location: England

Post by Miki » Tue Dec 12, 2006 11:02 am

Thanks for having a go :)

Just got this error:
Image

Was after doing about 25 tracks, most of them with Access Violation errors.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Wed Dec 13, 2006 5:35 am

That shouldn't happen but simply press IGNORE on it and it will go away.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Thu Dec 14, 2006 5:36 pm

Bugfix release

After much testing I have found the cause of the drag&drop errors. It was the refreshing of the tree, which is a bit shaky used together with the drag&drop event. I have not found a 100% bugfree workaround to the problem but as it works now it's acceptable and a major enhancements compared to the last version. (If you get an error with drag&drop just press escape a couple of times.)

Btw, MM-staff is informed of the bug and I'm waiting for their reply.

Let me know if it's working OK for you!
Enjoy!
/Bex
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

MeMeMe
Posts: 263
Joined: Fri Dec 23, 2005 11:42 am
Location: In front of my computer

Post by MeMeMe » Fri Dec 15, 2006 1:46 pm

Great news.
The date in the code doesn't look like it's been updated, and should it be version 1.5 now? The last version I had was 1.4.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Fri Dec 15, 2006 2:24 pm

Fixed!
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Post by Teknojnky » Fri Dec 15, 2006 6:25 pm

What to do about tracks that show up as duplicate but there only seems to be one file?

I've tried removing the files from the library and rescanning, but they still show up as duplicates but with only 1 file listed (when rescanned in).

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Sat Dec 16, 2006 4:13 am

What node? How many are they? Do only one copy show up in the expanded tree as well?
This could be an old problem that Cowboy has made an topic about...
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Post by Teknojnky » Sat Dec 16, 2006 1:04 pm

They show up in the same content node and expanded:


#1 (2x) B.G. - Get Your Mind Right (0)
1. B.G. - Get Your Mind Right [Promo Only Urban Radio June]
PlayCount: 0, Added: 12/15/2006
File: Various - 2006 - Promo Only Urban Radio June - 20 - B.G. Get Your Mind Right.mp3
F:\Music\_Various\2006 - Promo Only Urban Radio June\

The added date is from removing from library and rescanning, I've had them awhile.

I don't know how long they have or haven't been in the duplicates, I just happened to notice them while having time to work on cleaning some dupes up.

What is really weird is that the whole album (promo only urban radio june) shows up as dupes with single files.

I've checked for dead links, and compacted the library multiple times with still no luck.

I just checked the database itself and the files all have different SignParts from themselves.

Further checking reveald some duplicate entries which didnt show up on dead links (probly from manually changing media id's at some point in the past but who knows).

Removing these entries and seemed to fix the problem.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Sat Dec 16, 2006 1:44 pm

Ok, then you actually have "ghost entries" of the files on that album in the db. The files only exists one time on your HD but they exists twice in the db with the exactly same path. It's on old problem which was caused by the filemonitor (I think) it also occurs if your HD has 0 as serialnumber but it was fixed in 2.5.2 or 2.5.3, I hope not this problem has returned in 2.5.5 RC2....

Anyway, to remove them you need to open up the db in access and paste this code into the sql window of a query:

Code: Select all

SELECT Songs.SongPath, Songs.ID, Songs.SongTitle, Songs.IDArtist, Songs.IDAlbum, Songs.PlayCounter, Songs.DateAdded
FROM Songs, [SELECT Songs.SongPath
FROM Songs
GROUP BY Songs.SongPath
HAVING (((Count(Songs.ID))>1))]. AS dups
WHERE (((Songs.SongPath)=[Dups].[SongPath]));
It will display all songs which exists with duplicate paths within the DB. You could just delete everything and the rescan the folder. But if the metadata and the statistic is important to you, you need to determine what is grouping the the two groups together and then delete the one you don't want.

I couldn't test this but it should work just fine. Let me know if it does!
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Post by Teknojnky » Sat Dec 16, 2006 6:30 pm

I tried the SQL and it appeared to find some dupe entries I wasn't aware of, but the query was read only.. I couldn't delete the records, is that to be expected?

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Sat Dec 16, 2006 7:37 pm

Actually no, does this work?

Code: Select all

SELECT Songs.SongPath, Songs.ID, Songs.SongTitle, Songs.IDArtist, Songs.IDAlbum, Songs.PlayCounter, Songs.DateAdded
FROM Songs
WHERE (((Songs.SongPath) In (SELECT Songs.SongPath
FROM Songs
GROUP BY Songs.SongPath
HAVING Count(Songs.ID)>1)));
Cant test since i don't have any..
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Teknojnky
Posts: 5533
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Post by Teknojnky » Sat Dec 16, 2006 8:01 pm

Ooops, I had already went and manually found the tracks and cleared out the dupes so I can't really test it now either lol.

Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Post by Bex » Sat Dec 16, 2006 8:09 pm

:lol: Nice to here that you don't have any left...
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts

Post Reply