Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby Thamesvalley » Fri Aug 21, 2015 6:23 am

Hi,
Files are uploaded.
I have no more files before backup. Already deleted.
See the link to dl the current files :
https://mega.nz/#!2JMiWRKb!kAJmMkYN8_MG ... 40d-FDdxbA
And also a video showing directly this bug :
https://mega.nz/#!aF1liK7R!tXLmzqQn_Lc0 ... IeRikrj5Co

I hope you will find.
Thank you for your help
Thamesvalley
 
Posts: 21
Joined: Sat Jul 05, 2014 7:14 am
Location: BE

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby ZvezdanD » Fri Aug 21, 2015 9:38 am

Thamesvalley wrote:Files are uploaded.
I have no more files before backup. Already deleted.
See the link to dl the current files

Thanks for posting this, but that is completely another bug then that that you reported in your last post and completely another problem that we already talked on the previous page of this thread. As I already said to you before and as I already mentioned in the Important section of the first post of this thread: "This add-on could only restore data from/to some backup file, it cannot restore the current database with itself. You need to have already made the backup file before you get some problem with the current database - nothing can be done if you don't have it."

I already explained to you that you should not specify your current database file in the Backup database file text box of this add-on's dialog box. So, could you tell me what did you specify as the Backup database file when you got the error mentioned in your previous post ("Type mismatch: 'CLng' on the 2804 line)? If you specified the current database as you did on the uploaded video you would get the "database is locked" error instead, but not "type mismatch".
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7/4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3/2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 3017
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby Thamesvalley » Fri Aug 21, 2015 12:10 pm

Everything started with the replacement of my raid 1 array. I have one disk crashed.
So, made some manipulations and then, I saw my tracks were seen but I could not launch any of them anymore. They all were faded.
I tried to import the db, but failed. I dropped the library and rebuilding it; then retry to import db but failed.
Obviously, before posting, I tried to re-import the db from the default directory. How can I guess I couldn't ?
What do I have to do to restore efficienttly and quickly ? Does it work or not ?
Thamesvalley
 
Posts: 21
Joined: Sat Jul 05, 2014 7:14 am
Location: BE

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby ZvezdanD » Fri Aug 21, 2015 1:01 pm

Thamesvalley wrote:Everything started with the replacement of my raid 1 array. I have one disk crashed.
So, made some manipulations and then, I saw my tracks were seen but I could not launch any of them anymore. They all were faded.

If you have retained the same folder structure for media files as before crash, maybe you could use my Update Location of Files in Database add-on instead.

Thamesvalley wrote:I tried to import the db, but failed. I dropped the library and rebuilding it; then retry to import db but failed.

You still didn't answer to my question. What did you specify as the Backup database file when you got the "Type mismatch: 'CLng'" error seen in the screenshot? Could you upload that file to the file server instead of your current database?

Thamesvalley wrote:I tried to re-import the db from the default directory. How can I guess I couldn't ?
What do I have to do to restore efficienttly and quickly ? Does it work or not ?

Yes, the restore works, but only if you have a backup database file. You cannot import data from the current (active) database into itself, there is no point for such thing.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7/4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3/2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 3017
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby Thamesvalley » Fri Aug 21, 2015 1:27 pm

I changed the defect hdd and no datas were lost.
However I had to backup to an intermediate hdd. So, I replaced the datas with the same drive letter. No dammage encountered for my files.
I got the type mismatch clng with the same file mm.db
I've never had any other file than mm.db. Consequently, I cannot upload any other file.

The backup were made with Backup utility. See capture.
Image
Thamesvalley
 
Posts: 21
Joined: Sat Jul 05, 2014 7:14 am
Location: BE

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby ZvezdanD » Fri Aug 21, 2015 3:10 pm

Thamesvalley wrote:I changed the defect hdd and no datas were lost.
However I had to backup to an intermediate hdd. So, I replaced the datas with the same drive letter. No dammage encountered for my files.

As I said, it seems that you should use the Update Location of Files add-on instead.
Thamesvalley wrote:I got the type mismatch clng with the same file mm.db

OK, I have fixed that problem. Thanks for the report.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7/4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3/2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 3017
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby Thamesvalley » Fri Aug 21, 2015 3:19 pm

I don't understand.
What do you mean by update location ?
What should I do to solve my problem ?
Thamesvalley
 
Posts: 21
Joined: Sat Jul 05, 2014 7:14 am
Location: BE

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby ZvezdanD » Fri Aug 21, 2015 3:48 pm

Thamesvalley wrote:What do you mean by update location ?

You said before that you "made some manipulations and then, I saw my tracks were seen but I could not launch any of them anymore. They all were faded." Such problem exists after upgrading drive that has different serial number and because of that the location of files in the database is different and consequently all files in the tracklist are grayed. So, the mentioned Update Location of Files in Database add-on could be used in such cases.

The Update Location add-on is mentioned in the Important section in the first post of this thread as an alternative to the Restore/Synchronize Database add-on that could be used in specified cases. It is mentioned on the download page of this add-on as well.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7/4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3/2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 3017
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby shanemorales » Wed Sep 09, 2015 6:31 pm

Does this even work? I can select the database but the export and import buttons are greyed out.
shanemorales
 

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby ZvezdanD » Thu Sep 10, 2015 2:56 am

shanemorales wrote:Does this even work? I can select the database but the export and import buttons are greyed out.

Yes, it works. The export and import buttons are enabled only if you have at least one matched track between the active and backup databases. This add-on currently cannot import tracks from the backup into the active database, but only their data (metadata, playlists, playing history...). However, you need to have matched tracks to be able to do that.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7/4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3/2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 3017
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby martialartsguy » Fri Oct 16, 2015 9:04 am

Request for Script GUI:

Would it be possible to add "Select All," "Select None," "Invert Choices" on the main window for the choices under "Restore metadata in Songs & other tables"? I had to do a number of import because of a crashed HDD and this would have eased my speed of using the script.

Thanks for an awesome script that has saved my butt quite a few times. :D
MM 4.1.10.1778
martialartsguy
 
Posts: 263
Joined: Mon Apr 03, 2006 9:11 am
Location: Denver, CO

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby StephenSmith » Wed May 04, 2016 11:14 am

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
StephenSmith
 
Posts: 6
Joined: Thu Mar 17, 2016 6:55 am

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby ZvezdanD » Wed May 04, 2016 2:34 pm

StephenSmith wrote: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.

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...)."
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7/4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3/2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 3017
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby StephenSmith » Thu May 05, 2016 4:58 am

Thanks for that, when you say their data do you mean, title, artist, album etc
StephenSmith
 
Posts: 6
Joined: Thu Mar 17, 2016 6:55 am

Re: Restore/Synchronize Database 3.1.2 (2013-08-31) [MM3+]

Postby ZvezdanD » Thu May 05, 2016 6:03 am

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.
Magic Nodes 4.3.2/5.1 RegExp Find & Replace 4.4.8/5.1  Invert Selection/Select None 1.5.1  Export/Create Playlists for Child Nodes 4.1/5.3.6  Expand Child Nodes/Expand All 1.1.2  Event Logger 2.7  Filtered Statistics Report 1.6  Track Redirection & Synchronization 3.4.2  Restore/Synchronize Database 3.1.7/4.0  Find Currently Playing Track 1.3.2  Queue List 1.2.1  Add to Library on Play 1.0.1  Tree Report for Child Nodes 1.1.1  Update Location of Files in Database 1.4.3/2.2.2  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 3017
Joined: Thu Jun 08, 2006 7:40 pm

PreviousNext

Return to Need Help with Addons?

Who is online

Users browsing this forum: No registered users and 13 guests