MediaMonkey forum

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)

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)

How can it be that this Addon sometimes shows "Folders with same content" with only one matching track?
Example:

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.

Both folders contain "something" that is the same between them, not necessarily everything?

@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

Second song with 11.5MB file size and track# 06


Any ideas?

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.

Also, did you check that all your tags are synchronized first?

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?

No, sorry.

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 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?

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.

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!

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!

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