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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

Re: Restore PlayHistory/Playlists/Metadata 2.1 (2011-11-15[M

Postby ZvezdanD » Sun Sep 07, 2014 9:50 am

chrisjj wrote:This puzzles me. "Property Get isAutoplaylist As Boolean" so why would anyone test IsAutoPlaylist for a numeric rather than bool?

I was not talking about MM API, but about SQLite database field. SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true): http://www.sqlite.org/datatype3.html
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.1  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.1  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 2992
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore PlayHistory/Playlists/Metadata 2.1 (2011-11-15[M

Postby chrisjj » Sun Sep 07, 2014 10:02 am

ZvezdanD wrote:I was not talking about MM API, but about SQLite database field.


Meaning the script peeks the DB direct rather than use the API?
Chris
chrisjj
 
Posts: 4926
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

Re: Restore PlayHistory/Playlists/Metadata 2.1 (2011-11-15[M

Postby ZvezdanD » Sun Sep 07, 2014 10:12 am

chrisjj wrote:Meaning the script peeks the DB direct rather than use the API?

Exactly.
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.1  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.1  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 2992
Joined: Thu Jun 08, 2006 7:40 pm

Re: Restore PlayHistory/Playlists/Metadata 2.1 (2011-11-15[M

Postby chrisjj » Sun Sep 07, 2014 10:26 am

ZvezdanD wrote:
chrisjj wrote:Meaning the script peeks the DB direct rather than use the API?

Exactly.


Ah, now I see that the script does both.

In one place it uses the API, testing TRUE and FALSE.

In others it reads the DB direct, guessing what numeric values might represent TRUE and FALSE. This is asking for trouble, surely.
Chris
chrisjj
 
Posts: 4926
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

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

Postby jvondelft » Fri Oct 10, 2014 4:26 am

Hello,

I tried to use your add-on for synchronizing a local MM database on my notebook and a database stored on a NAS . (The notebook needs its own database to be portable.) The NAS version is used on my desktop computer.
But when new tracks are added to the notebook-DB the addon does not copy these records to the backup file. (The audio files were already copied to the NAS via the FreeFileSync-Tool.)
I already studied the posts about the add-on in the forum. Is it right that your add-on cannot do this? Do you plan to implement ths feature? Or do I have to I select a special option?

Thank you very much!
jvondelft
 
Posts: 1
Joined: Fri May 01, 2009 7:07 am

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

Postby ZvezdanD » Fri Oct 10, 2014 9:54 am

jvondelft wrote:when new tracks are added to the notebook-DB the addon does not copy these records to the backup file.

You are right, currently this add-on cannot do that. It could synchronize only data from the database that I mentioned in the first post of this thread, i.e. playilsts, playing info, metadata, ... It synchronizes those data only for tracks that already exist in both databases (although they could have different paths and/or some other tags).

I though to add copying of records about tracks to the Songs table, but nobody asked about that before so I just postponed that. Anyway, if you want to have identical databases with only difference in paths of contained tracks, then maybe it would be easier to use the Update Location of Files in Database add-on instead.
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.1  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.1  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 2992
Joined: Thu Jun 08, 2006 7:40 pm

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

Postby Thamesvalley » Mon Oct 27, 2014 7:20 pm

Hi, I encountered an issue with the plugin when restoring the db
In some posts in another section I got first a problem with nested items which disappeared. So, I tried to restore the db to recover the items but I failed.
Here is a copy of the last post and the screencapture. Thank you for your help
Plugin installed. It does not work. MM says database locked. No track was played in the same time of the backup process.
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 » Tue Oct 28, 2014 2:10 am

Thamesvalley wrote:Hi, I encountered an issue with the plugin when restoring the db
In some posts in another section I got first a problem with nested items which disappeared. So, I tried to restore the db to recover the items but I failed.
Here is a copy of the last post and the screencapture. Thank you for your help
Plugin installed. It does not work. MM says database locked. No track was played in the same time of the backup process.
Image

That message could mean that some another program or even some another instance of the MediaMonkey is accessing the same database in the same time. If you didn't start another instance of MediaMonkey, you should check with the Task Manager if some MediaMonkey process is left in the memory which causes that locking and kill it, or you could just restart the computer.

However, after reading the mentioned thread I am not sure if you already have some backup of the database. If you don't have it, then you cannot restore your missing playlists. You didn't specify the current database in the "Backup database file" text box, right? If you specify your current (active) database instead of the backup, I suppose that you could get the mentioned error message as well. Please read the first post of this thread and the section about the limitations and requirement for this add-on.
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.1  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.1  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 2992
Joined: Thu Jun 08, 2006 7:40 pm

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

Postby Thamesvalley » Tue Oct 28, 2014 6:44 am

Yes MM is on memory since I need it to use the add-on.
I have a database file made by a plug-in named "backup" I specified the current database in the "Backup database file" text box
Image
So, my problem consists to restore the nested items. I have not lost any audio datas. This is just for the nested items.
I dont know the reason it disappeared. The problem appeared from nowhere.
The plugin mentioned above is setted to make automatically a backup at shutdown.
So, If I could not specify the active database, what can I do ? The program asks : would you restore in the active database and that's all. Either I accept, nor I cancel.
What is the solution ?
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 » Tue Oct 28, 2014 8:23 am

Thamesvalley wrote:Yes MM is on memory since I need it to use the add-on.

I am not talking about the active instance of the program in which you started the add-on. You could have two instances in the memory, e.g. if the last one crushed in which case it is not visible, but still left in the memory accessing the same database.

Thamesvalley wrote:I specified the current database in the "Backup database file" text box

As I said, you should not do that. Here is the excerpt from 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."

Thamesvalley wrote:The plugin mentioned above is setted to make automatically a backup at shutdown.
So, If I could not specify the active database, what can I do ?

I am not using the mentioned Backup add-on, but I think that it stores the database file and other settings into some Zip archive. So you could open that Zip file, unpack MM.DB file to some temporary folder and then you should specify that file in the "Backup database file" text box.
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.1  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.1  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 2992
Joined: Thu Jun 08, 2006 7:40 pm

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

Postby Thamesvalley » Tue Oct 28, 2014 11:55 am

The zip funcitonality is disabled. There is no zip file created.
I already a file named mm.db
I have to specify, the backup is setted to be done at the program shutdown.
So, I did not realize the problem at once and so, the last backups were made with the problem.
I suppose, restore to db file will not solve my issue.
I will not risk to create again new playlist knowing they can disappear anytime with no reason.
Could that be possible for you to access my computer through Teamviewer ?

PS : I added a location and everything is ok. I see the nested items.
Thamesvalley
 
Posts: 21
Joined: Sat Jul 05, 2014 7:14 am
Location: BE

How to restore a .DB file ?

Postby Thamesvalley » Thu Aug 20, 2015 12:53 pm

Hi,
I need to restore a large .DB file which is 130MB.
I always get the error messge.
Could you help me please ? I really need to restore this one.
Image
Thank you very much in advance.
Last edited by Lowlander on Thu Aug 20, 2015 1:21 pm, edited 1 time in total.
Reason: Merged with existing post
Thamesvalley
 
Posts: 21
Joined: Sat Jul 05, 2014 7:14 am
Location: BE

Re: How to restore a .DB file ?

Postby Lowlander » Thu Aug 20, 2015 1:04 pm

Are you using an Addon to restore? The error is from an Addon.
Lowlander (MediaMonkey user since 2003)
Lowlander
 
Posts: 43169
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: How to restore a .DB file ?

Postby Thamesvalley » Thu Aug 20, 2015 1:19 pm

Hi,
Yes, I use an addon. See screenshot here-after
Image
Thamesvalley
 
Posts: 21
Joined: Sat Jul 05, 2014 7:14 am
Location: BE

Re: How to restore a .DB file ?

Postby ZvezdanD » Fri Aug 21, 2015 4:58 am

Thamesvalley wrote:I need to restore a large .DB file which is 130MB.
I always get the error messge.

Strange, that error should not be there on that line. The only thing that comes to my mind about it is that you have broken backup database file.

If you want that I fix this bug, please pack your backup and current (before import) database files with Zip, upload that archive to some file server like Dropbox and send me a link to it in PM, so I could try to reproduce the problem by myself.
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.1  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.1  Inherit Child Playlists 1.0.2  Add Currently Playing/Selected Track(s) to Playlist 1.1.2
ZvezdanD
 
Posts: 2992
Joined: Thu Jun 08, 2006 7:40 pm

PreviousNext

Return to Need Help with Addons?

Who is online

Users browsing this forum: Majestic-12 [Bot], Yahoo [Bot] and 9 guests