There is a new very important update of this add-on v3.1.8 that has fixed a serious bug:
* Fixed: error on export/import playlists to/from MM4.1+ databases when the option [i]Clear Playlists & PlaylistSongs tables first[/i] is turned off.

[quote="Mekare"]I receive the following error messages when trying to run this script[/quote]
Thanks for the report and sorry for the late replay, but I got the e-mail notification about your post just now. There is available the new fixed version of the add-on.

Good morning,

I receive the following error messages when trying to run this script (after selecting my backup database, and it states that all 2,121 tracks match). The second error comes up after I hit OK on the first error. My version of MediaMonkey is 4.1.16.8136. I cleared my database first and reimported all the tracks. They play fine (nothing grayed out). Path names are the same, since the files were not moved. I left the default options checked. After I hit okay on the second error, nothing noticeable happens. No data is restored, and according to Task Manager, Media Monkey is using 0% CPU. I'm using the latest free version of this add-on.

[url]https://www.dropbox.com/s/8ol8usbc0gmnahi/MediaMonkey%20Error%201.png?dl=0[/url]
[url]https://www.dropbox.com/s/zuyrhvz2vc9f9ed/MediaMonkey%20Error%202.png?dl=0[/url]

As I test, I copied my database from before I cleared it, and put that back in the Roaming folder and started up Media Monkey, and everything was normal - all tracks were available and all play data was there. So I know that there is valid play data for the add-on to restore.

The reason I'm trying to re-create my database is because I bought an SSD for my C: Drive and then had to reformat the drive with my music on it, in order to recover the space from the partition that was my C: Drive. And now if i hit the Add/Rescan tracks, it re-finds all my music, adds duplicates of every one, and then over the course of a few minutes somehow determines that they're duplicates and removes them all. But this never used to happen before I formatted, so I thought starting my database over would be a good idea. I even tried using a database from before I formatted (which had less music, but the add-on did match the 2079 files), and that database also didn't work with this add-on. So I'm not sure if the add-on is the problem, or my database.

[img]https://c1.staticflickr.com/1/412/30974596333_113dc70e05_o.png[/img]
There is a new donation-only version v4.0:
* Added: option [i]Add unmatched files[/i] which allows import/export of database records about files that are missing in the current/backup database;
* Added: option [i]Only if physically exist[/i] that determines which records of unmatched files will be imported/exported;
* Added: option [i]Copy media files[/i] which allows to physically copy unmatched files from/to the specified Backup/Current location;
* Added: option [i]Overwrite files[/i] that determines if files with the same names will be overwritten in the target location when copying media files;
* Added: option [i]Restore data only for - Unmatched files[/i] that is enabled if [i]Add unmatched files[/i] option is turned on, so the data in matched files will not be restored;
* Added: [i]Matched criteria[/i] combo box that allows choosing of criteria that was available in the previous versions only through the manual edit of MediaMonkey.ini file using the ExtraMatchTests key;
* Added: criterion [i]only corresponding files at specified locations[/i] to match files between backup and current database;
* Added:[i] Backup/Current location of files[/i] text boxes which could be used to specify source and destination base folders if they are different;
* Renamed: option [i]Clear Played table & Playcount/LastTimePlayed fields first[/i] to [i]Clear existing playhist. of matched files first[/i];
* Added: option [i]Use Played table to get Play counter[/i] which determines how the Play Counter field will be calculated when restoring play history;
* Renamed: option [i]Clear Playlists & PlaylistSongs tables first[/i] to [i]Clear all pls. first[/i];
* Added: option [i]Replace equiv. pls.[/i] that should be set if you want to replace playlists with the same names (within the same parent playlist) when restoring playlists;
* Added: option [i]Only on last level[/i] that should be set if you want to replace playlists with the same names only if they are on the last (rightmost) level of playlists, i.e. they don't have child playlists;
* Renamed: option [i]Clear Filters table first (also Views & NodeViews for MM4 db)[/i] to [i]Clear related tables first[/i];
* Added: option [i]Replace equivalent collections with the same names[/i] that should be set if you want to replace collections with the same names;
* Added: combo box [i]All[/i] which could be used to tick on/off all check boxes for metadata (Title, Artist, ...);
* Added: button with combo box which allow showing/selecting of matched/unmatched files in the main filelist;
* Changed: dialog box that is now resizable;
* Improved: speed of many SQL operations;
* Improved: restoring data of duplicate source files combining their playing history into the target files.

I have uninstalled MM completely (keeping of course DB and INI), and reinstalled it from scratch. All is fine now, and also your add-on works as expected.
Thanks for you advise!
Regards, Willy

Sub OnStartUp()
    SDB.MessageBox SDB.Database.Path, mtInformation, Array(mbOK)
End Sub

[quote="willyvds"]I have a lot of addons. They are all installed by admin for all users.[/quote]
I was specific, I am interested only in type 0 scripts that could be found in the Tools / Scripts menu. Could you name at least one that you are using which is not included with the program? Could you post the content of the Scripts.ini file from your Scripts sub-folder of the program?

[quote="willyvds"]What I mean is that when I run MM as admin, MM doesn't show my music in the normal way. All songs are listed in a grey color (normal is black).[/quote]
This is not normal behavior and I think that you have some serious problem with your configuration beside of this add-on. Greyed/inaccessible state of the tracks should not be different when you run the program as admin.

Are you sure that you are starting the same instance of the program when run as admin? Are you sure that you are opening the program with the same database when run as admin?

Here is one short script which could tell you the location of the active database during startup, just save that code to the Test.vbs file and put it in the Scripts\Auto sub-folder of the program:
[code]Sub OnStartUp()
SDB.MessageBox SDB.Database.Path, mtInformation, Array(mbOK)
End Sub
[/code]

I have a lot of addons. They are all installed by admin for all users.
What I mean is that when I run MM as admin, MM doesn't show my music in the normal way. All songs are listed in a grey color (normal is black). It means you cannot play the song.
This usually happens when the drive is not accessable. I don't know why this happens too when I run MM as admin.

Well anyway, this is what I did. I installed MM on an old laptop, with your add-on, I also copied the corrupt database as well as the most recent backup correct DB to that laptop. The music is on a network drive so that works fine.
I then ran MM as admin starting with the backup DB and imported all playhistory and playlists from the corrupt (but more recent) DB. And it worked!
Somehow the MM DB got corrupted but your add-on can still read it. This is what I hoped!

I still don't understand why it doesn't work on my normal PC. If I have a bit of time I may dive into that. For the moment, I am over the moon!
Thanks for looking into this, and for your marvelous add-on!
Regards, Willy

Do you have only this add-on in the Scripts menu installed as admin for all users?
Is the same problem happening when you install it "for the current user only"?
What do you mean by "all my music is grayed out"? What has that with this add-on?
Could you get it to work when started as admin at least?
Could you install the another instance of MM program in portable mode and install this add-on to it just to see if the same happens?

Only with this add-on. I don't see it at all in the scripts menu as normal user. By the way: it is in the overview of extensions, and I can look for an update. When I run mm as admin, the add-on is in the menu, as it should. But all my music is grayed out.
I think I have the problem for quite some time, but first I thought it was my mistake. But now I really need the add on because my database is corrupt. And now I notice that I cannot get it to work anymore.

[quote="willyvds"]when I run MM as normal user - I simply don't see the add-on.[/quote]
Do you have that problem only with this add-on?
Do you see its item in the Scripts menu when run as normal user?
Do you see it at all when run as admin?

I have a question. I have used this add-on many times but now it doesn't work anymore.
First, I simply did not see the add-on. I only saw it when I ran MM as admin.
So I uninstlled the add-on and installed it again (as admin) making sure it was installed for all users.
But still, when I run MM as normal user - I simply don't see the add-on.

As I said, this has worked in the past for many years. What am I doing wrong???
Thanks for your attention.

Yes, of course. The mentioned metadata include title, artist, album etc. Please read the first message of this thread and you will see what data you could import/export.

Thanks for that, when you say their data do you mean, title, artist, album etc

[quote="StephenSmith"]Am I right in thinking that this will merge two DB's into one. The reason I am asking is that my main DB is on my laptop at my place of work, but there are times that I have time at home to add some newer files and what I would like to do is then take the home DB and merge it into my main DB.[/quote]
http://www.mediamonkey.com/forum/viewtopic.php?p=413758#p413758
"This add-on currently cannot import tracks from the backup into the active database, but only their data (metadata, playlists, playing history...)."

Hiya

Am I right in thinking that this will merge two DB's into one. The reason I am asking is that my main DB is on my laptop at my place of work, but there are times that I have time at home to add some newer files and what I would like to do is then take the home DB and merge it into my main DB.

If so what settings would I need to do that please

Thanks in advance

Steve