The Music Manager for Serious Collectors
https://www.mediamonkey.com/forum/
chrisjj 写了：May I ask what indicates that?ZvezdanD 写了： You don't have "S:" in the database
chrisjj 写了：the dialog offers me only P:
Open your database in some SQLite editor like SQLiteSpy and execute next statement:ZvezdanD 写了：The Old path combo box of this add-on displays only paths/drives that are already stored in the database.
代码： 全选
SELECT Count(*) FROM Medias WHERE DriveLetter = 18No doubt that would be true if the program was working correctly. I'm suggesting there's a flaw.ZvezdanD 写了：chrisjj 写了：May I ask what indicates that?ZvezdanD 写了： You don't have "S:" in the databasechrisjj 写了：the dialog offers me only P:
Well, I think that too is faulty, because it displays P: and there is no P: in the media tree.ZvezdanD 写了：The Old path combo box of this add-on displays only paths/drives that are already stored in the database.
I get 1 : http://i.imgur.com/rqHNMZe.pngZvezdanD 写了：Open your database in some SQLite editor like SQLiteSpy and execute next statement:If you get some number greater than 0 as result then my add-on has a bug.代码： 全选
SELECT Count(*) FROM Medias WHERE DriveLetter = 18
OK, will do. Please keep the database confidential.ZvezdanD 写了：In that case please pack your database with Zip and upload it to some file server like Dropbox and send me link to it in PM.
It doesn't matter what is displayed in the tree but what is stored in the database. This add-on could update location for files that was located on the drive that doesn't exist anymore.chrisjj 写了：I've updated the report to show that S: is in the media tree.
...
Well, I think that too is faulty, because it displays P: and there is no P: in the media tree.
S: is in the tree, P: isn't. If you're suggesting P: is in the database and S: isn't... I'm surprised.ZvezdanD 写了：It doesn't matter what is displayed in the tree but what is stored in the database.
I did highlight the SUBST in my initial report.ZvezdanD 写了：... you have the same drive with two drive letters that you got using Subst.
I'd settle for a fix for a single drive with multiple lettersZvezdanD 写了：I will fix add-on to allow work with multiple drives with the same serial number as soon as possible.
I am not suggesting that S: is not in the database. As I said, you have 4 drive letters with 2 serial numbers stored in the database: P: and S: with one serial number and C: and P: with another one.chrisjj 写了：S: is in the tree, P: isn't. If you're suggesting P: is in the database and S: isn't... I'm surprised.
That still doesn't mean that both drives, physical and substituted are stored in the database. I needed your database to reveal that.chrisjj 写了：I did highlight the SUBST in my initial report.
Maybe in meantime you could try to specify P: in Old drive combo box even if you want to update S:, just make sure that it has the same label and serial number.chrisjj 写了：I'd settle for a fix for a single drive with multiple letters
OK, then I don't know what you meant by "You don't have "S:" in the database".ZvezdanD 写了：I am not suggesting that S: is not in the database.
And did it? Because I see no DB reference to the SUBST "P:".ZvezdanD 写了：That still doesn't mean that both drives, physical and substituted are stored in the database. I needed your database to reveal that.
As I said, that prevents me entering the correct path.ZvezdanD 写了：Maybe in meantime you could try to specify P: in Old drive combo box even if you want to update S:, just make sure that it has the same label and serial number.
Yes, I said that. But after that I said also:chrisjj 写了：OK, then I don't know what you meant by "You don't have "S:" in the database".
The bug is because my add-on assumes that a database cannot have stored two drives with the same serial number. In case that it has like your, the add-on displays only the first drive, which is P: in your case.ZvezdanD 写了：If you get some number greater than 0 as result then my add-on has a bug.
Try next SQL statement with your database and you will see that you have both P: and S: stored in it with the same serial number:chrisjj 写了：And did it? Because I see no DB reference to the SUBST "P:".ZvezdanD 写了：That still doesn't mean that both drives, physical and substituted are stored in the database. I needed your database to reveal that.
代码： 全选
SELECT SerialNumber, SubStr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', DriveLetter + 1, 1)
FROM Medias WHERE DriveLetter IS NOT NULLI suppose your substituted drive has the same paths as the physical one except the drive letter. But never mind, forget about that suggestion and wait for the next update of this add-on.chrisjj 写了：As I said, that prevents me entering the correct path.
Confirmed. And worse, P twice with different serial numbers.ZvezdanD 写了：Try next SQL statement with your database and you will see that you have both P: and S: stored in it with the same serial number:
Again Z you suppose wrong. It has a folder.chrisjj 写了：I suppose your substituted drive has the same paths as the physical one except the drive letter.
OK, thanks.ZvezdanD 写了：But never mind, forget about that suggestion and wait for the next update of this add-on.
Only drives that have files in Songs, Playlists or SynchLocation tables are shown:chrisjj 写了：how come only two drives are shown?
代码： 全选
SELECT SerialNumber, CASE WHEN DriveLetter IS NOT NULL THEN SubStr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', DriveLetter + 1, 1) ELSE 'net/url' END AS DrvLetter,
(SELECT Count(*) FROM Songs WHERE Songs.IDMedia = Medias.IDMedia COLLATE NOCASE) +
(SELECT Count(*) FROM Playlists WHERE Playlists.srcMedia = Medias.IDMedia COLLATE NOCASE) +
(SELECT Count(*) FROM SynchLocation WHERE SynchLocation.IDMedia = Medias.IDMedia COLLATE NOCASE) AS NumberOfFiles
FROM MediasI don't understand what you want to ask.chrisjj 写了：does that target set include Now Playing?
Location of files in Now Playing will be updated if they are already stored in the database into mentioned tables. You know that the name of this add-on is "Update Location of Files in Database", right?chrisjj 写了："files in Songs, Playlists or SynchLocation" is a target set Does it include files in Now Playing?
I do. Are you suggesting Now Playing tracks are not stored in the database?ZvezdanD 写了：. You know that the name of this add-on is "Update Location of Files in Database", right?