Update Location of Files in Database 1.3 (2012-06-12) [MM2+]

[ZvezdanD]

You don't have "S:" in the database

May I ask what indicates that?

the dialog offers me only P:

The Old path combo box of this add-on displays only paths/drives that are already stored in the database.

Open your database in some SQLite editor like SQLiteSpy and execute next statement:

Código: Selecionar todos

SELECT Count(*) FROM Medias WHERE DriveLetter = 18

If you get some number greater than 0 as result then my add-on has a bug. 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.

[chrisjj]

You don't have "S:" in the database

May I ask what indicates that?

the dialog offers me only P:

No doubt that would be true if the program was working correctly. I'm suggesting there's a flaw.

I've updated the report to show that S: is in the media tree.

The Old path combo box of this add-on displays only paths/drives that are already stored in the database.

Well, I think that too is faulty, because it displays P: and there is no P: in the media tree.

Open your database in some SQLite editor like SQLiteSpy and execute next statement:

Código: Selecionar todos

SELECT Count(*) FROM Medias WHERE DriveLetter = 18

If you get some number greater than 0 as result then my add-on has a bug.

I get 1 : http://i.imgur.com/rqHNMZe.png

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.

OK, will do. Please keep the database confidential.

[ZvezdanD]

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.

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.

However, from your database it is obvious that there is a problem which was already reported by dtsig - you have 4 drives with 2 serial numbers. The difference is because he has two physical drives with the same serial number and you have the same drive with two drive letters that you got using Subst.

I will fix add-on to allow work with multiple drives with the same serial number as soon as possible. Thanks for the report and database.

[chrisjj]

It doesn't matter what is displayed in the tree but what is stored in the database.

S: is in the tree, P: isn't. If you're suggesting P: is in the database and S: isn't... I'm surprised.

... you have the same drive with two drive letters that you got using Subst.

I did highlight the SUBST in my initial report.

I will fix add-on to allow work with multiple drives with the same serial number as soon as possible.

I'd settle for a fix for a single drive with multiple letters

Thanks.

[ZvezdanD]

S: is in the tree, P: isn't. If you're suggesting P: is in the database and S: isn't... I'm surprised.

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.

I did highlight the SUBST in my initial report.

That still doesn't mean that both drives, physical and substituted are stored in the database. I needed your database to reveal that.

I'd settle for a fix for a single drive with multiple letters

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 am not suggesting that S: is not in the database.

OK, then I don't know what you meant by "You don't have "S:" in the database".

That still doesn't mean that both drives, physical and substituted are stored in the database. I needed your database to reveal that.

And did it? Because I see no DB reference to the SUBST "P:".

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.

As I said, that prevents me entering the correct path.

[ZvezdanD]

OK, then I don't know what you meant by "You don't have "S:" in the database".

Yes, I said that. But after that I said also:

If you get some number greater than 0 as result then my add-on has a bug.

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.

That still doesn't mean that both drives, physical and substituted are stored in the database. I needed your database to reveal that.

And did it? Because I see no DB reference to the SUBST "P:".

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:

Código: Selecionar todos

SELECT SerialNumber, SubStr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', DriveLetter + 1, 1)
FROM Medias WHERE DriveLetter IS NOT NULL

As I said, that prevents me entering the correct path.

I 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]

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:

Confirmed. And worse, P twice with different serial numbers.



Many to many. I'd say "What a mess", except that in the absence of any public documentation of these field, GOK what they are supposed to mean.

And Optimise doesn't clear this up.

I suppose your substituted drive has the same paths as the physical one except the drive letter.

Again Z you suppose wrong. It has a folder.

But never mind, forget about that suggestion and wait for the next update of this add-on.

OK, thanks.

[chrisjj]

Thanks for 1.4. It looks better:



but how come only two drives are shown?

[ZvezdanD]

how come only two drives are shown?

Only drives that have files in Songs, Playlists or SynchLocation tables are shown:

Código: Selecionar todos

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 Medias

[chrisjj]

OK, thanks.

BTW, does that target set include Now Playing?

[ZvezdanD]

does that target set include Now Playing?

I don't understand what you want to ask.

[chrisjj]

"files in Songs, Playlists or SynchLocation" is a target set Does it include files in Now Playing?

[ZvezdanD]

"files in Songs, Playlists or SynchLocation" is a target set Does it include files in 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]

. You know that the name of this add-on is "Update Location of Files in Database", right?

I do. Are you suggesting Now Playing tracks are not stored in the database?