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

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

woodyj13@gmail.com
Posts: 1
Joined: Mon Apr 24, 2017 11:58 am

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

Post by woodyj13@gmail.com »

Is anyone else getting an error when trying to use "Create Keep/Delete Suggestion Nodes"?

Error executing script event.

Error executing SQL "INSERT INTO 'TmpDelSuggCDS15' (tmpSongID, tmpGrp, tmpBitRate, tmpSampleRate, tmpLength, tmpSize, etc. etc.

SELECT Songs.ID, ongs.Artist||':?'||SongTitle, BitRate, SamplingFrequency, SongLength, FileLength, etc. etc. : no such column: ongs.Artist (1,1)
Mookie Man

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

Post by Mookie Man »

I only use the Copy/Paste Medatdata function, and everything has worked great until yesterday. Now, when I copy metadata for more than one track and try to paste it to other files, I receive the following errors:

Error #70 - Microsoft VBScript runtime error
Permission denied
File: "C:\[...]\Roaming\MediaMonkey\Scripts\Auto\AdvancedDuplicateFindFix.vbs", Line: 5294, Column : 10

[Click OK]

Error executing script event.
Permission denied

[Click OK]

When I look at the results, it seems to have successfully pasted the first, and sometimes second, tracks from the selection, but nothing else. It also removes that metadata from the copied tracks, which is expected.

I've uninstalled the script, restarted MM, restarted Windows, all to no effect. Has anyone else encountered this?

MM 4.1.16 (latest) on Windows 10 Pro (updated)
MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

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

Post by MMuser2011 »

How can it be that this Addon sometimes shows "Folders with same content" with only one matching track?
Example:
Image
The first folder contains 11 songs, the second folder contains 16 songs.

Why should this Addon present this two folders "with same content"?

Mostly the folders are really the same and I can delete one of them.

I can't find the reason why sometimes 1 track from a folder made it to this list.
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

Both folders contain "something" that is the same between them, not necessarily everything?
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

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

Post by MMuser2011 »

@MMFrLife: If that would be true, it should show a lot more of "Folders with same contents" with only 1 track.

After a short look I can say for sure, this single song is not the same in this two folders, not even similar:
First song with 9.7MB file size and track# 02
Image
Second song with 11.5MB file size and track# 06
Image

Any ideas?
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

Yeah, that's odd. I'd like to dig in deeper but I haven't used that script's duplicate function in quite some time and don't currently have anything analyzed
to look for the patterns you speak of/display.
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

Also, did you check that all your tags are synchronized first?
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
MMuser2011
Posts: 1308
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

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

Post by MMuser2011 »

Good idea.
Yes, my tags and the MM.DB are synchronized and the archive fully compacted.
Unfortunately I can't find the SQL-command behind "Folders with same content".
Do you know what command is executed?
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

No, sorry. :-?
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
boober
Posts: 58
Joined: Sat Mar 11, 2017 4:44 pm

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

Post by boober »

Mookie Man wrote: Error #70 - Microsoft VBScript runtime error
Permission denied
File: "C:\[...]\Roaming\MediaMonkey\Scripts\Auto\AdvancedDuplicateFindFix.vbs", Line: 5294, Column : 10

[...]

I've uninstalled the script, restarted MM, restarted Windows, all to no effect. Has anyone else encountered this?

MM 4.1.16 (latest) on Windows 10 Pro (updated)
Is anyone else getting this error? I've tried searching the thread, but couldn't find something similar.

(Sorry if this posted more than once.)
boober
Posts: 58
Joined: Sat Mar 11, 2017 4:44 pm

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

Post by boober »

boober wrote:
Mookie Man wrote: Error #70 - Microsoft VBScript runtime error
Permission denied
File: "C:\[...]\Roaming\MediaMonkey\Scripts\Auto\AdvancedDuplicateFindFix.vbs", Line: 5294, Column : 10

[...]

I've uninstalled the script, restarted MM, restarted Windows, all to no effect. Has anyone else encountered this?

MM 4.1.16 (latest) on Windows 10 Pro (updated)
Is anyone else getting this error? I've tried searching the thread, but couldn't find something similar.
In case this helps anyone else: After reading NewtonBoy's troubleshooting and Bex's response (below), I started troubleshooting with album art. After deleting any album art associated with a file, I was able to successfully copy/paste metadata for all files, including ones that had failed before. (I say this because NewtonBoy wasn't able to paste once a file had failed.) I kept the album art in the folders so I could transfer it manually. So, not a permanent fix, but helpful if you want to work around this error.

Thanks to both NewtonBoy and Bex!
NewtonBoy wrote: Results;
Once I have a problem with a file, I will always have a problem with that file, seemingly no matter what I do. I can't say the file is corrupt, because it works fine in other Applications, and MM. I can't say it's permissions, because they have no effect once it works. I can't say it's the script, because it works on other files. I ran a "Rebuild Full-Text..." and "Optimize database (Complete)," and the same files have the same problems. Reboot Windows, The Script error returns for one of the files "damaged," but other file pairs work perfectly.
Bex wrote:The line 5294 is about copying linked Album Art to the new location which it doesn't seem to have permission to. Is that of any help to solve the issue?
MMFrLife
Posts: 2894
Joined: Fri Oct 26, 2012 9:04 pm
Location: MM Forum

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

Post by MMFrLife »

Trix,
Can you add "Encoder" to Tags & DataBase Values Selection.
Can that be easily edited into the script on the user end?
Any metadata field that is written to tags should be included. Being that they write to tags,
they are good to use for extra custom fields when not using them for named purpose.
It's annoying to do a whole bunch of fields automatically, but then have to also do some separately.
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
😜
Bill Graves

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

Post by Bill Graves »

Recently found and like this add on, especially as I am re-recording my mp3's as flac's and heavily using the copy/paste metadata option. It may be the approach I am taking, but the while the copy source is in track # sequence, the paste source isn't always and I sometimes don't catch it. This leads to the wrong track name and classification among other issues, so I am forced to delete the flac version of the CD, reload the mp3 version and restart the whole process.

Is there a way to either have both the copy and paste sources checked to ensure the same track # number sequence and not allow the paste if not, or can it be made smart enough to ensure the Copy's track #3's metadata (for example) is being posted to the Paste's track #3 regardless of the display sequence? (Note, by track # I mean CD track #, not the sequence (position #) the track is shown under the CD listing?)

Regardless, many thanks for your time and effort!
travelgirl
Posts: 15
Joined: Wed Dec 09, 2009 3:33 pm

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

Post by travelgirl »

is there a way to not only port/copy metadata (added dates, genre, title, etc), but also INCREMENT the play stats and dates?

i currently have 240 files (120 originals, 120 dupes) where most have play stats/dates. it would be nice to be able to say "i'm keeping this one because it has an earlier ADDED date (seeing as how that cannot be changed, though i'm not sure who would die in the world were we allowed to change it), and because file A has 2 plays and file B has 3 plays, when all is said and done, the kept file would have 5 plays and each play would have correct play dates...

thank you!
Lowlander
Posts: 56465
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

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

Post by Lowlander »

Yes, it has an option to copy Play History along with other metadata.
Post Reply