View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011029 | MMW v4 | DB/FileMonitor | public | 2013-07-03 12:47 | 2013-09-21 04:07 |
| Reporter | peke | Assigned To | |||
| Priority | urgent | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.1 | ||||
| Target Version | 4.1 | Fixed in Version | 4.1 | ||
| Summary | 0011029: When scanning Duplicate location entries are created for some users | ||||
| Description | For some long time user of MMW he is experiencing Duplicate Location creations after Scanning/Adding new files to library. Ther is no Specific files but rather creation of Full Duplicate Location (Same serial under new name) with Newly added/updated files in library. But if new location is deleted user loose same tracks on old location too. Full Logs and User DB (500k+ of tracks) is Uploaded onto FTP. | ||||
| Additional Information | Ticket: PND-343173 http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=71707 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1648 | ||||
|
|
I checked the user database, shown all 512061 music files sorted by Path and I see no duplicates. Also if I search for 'beatles' it shows 28 files in search results and no duplicates, am I missing something? |
|
|
You were right, I contacted user and in remote session we have made new DB with Duplicates. I'll reassign back to you as soon as I get it. |
|
|
Uploaded new MM.DB You should see problem with Artist: 2'nd Chapter Of Acts Album: With Footnotes |
|
|
You are true that there are triplicates for that album with same Songs.IDMedia = 17 and same Songs.SongsPath I've been very surprised how it could happen, but then I found the answer when I read the first post in the user ticket (PND-343173), he attached screenshots in the TMP.zip (100.16 KB) where on the Picture1.bmp he demostrated the original Medias table and on Picture2.bmp how he manually edited that table. He changed DriveLetter for media ID = 17 from letter Z: (DriveLetter = 25) to letter X: (DriveLetter = 23). This broken the relation and causes the issues. I would suggest to edit it back to the original state. ---------------------------- I've also seen an attached ELF where is a dialog: Your media files will not be physically copied, but the location of files will be updated in the database from:_[]\Music\ to:_Z:\Music\ Are you really sure that you want to do that? And soon after that it has frozen on this SQL: UPDATE Songs SET IDMedia = 12 WHERE IDMedia = 7 AND SongPath LIKE ':\Music\%' What was that dialog? Is this dialog and the query offered by a script? I've gone through our code and there is no such a feature in MMW natively AFAIK. Peke, do you know which script can do this? |
|
|
I suspected something like this and your findings confirms it. Can you please take over the ticket and instruct user what to do or make SQL query that will change DB to correct one using OnStartup Script? If needed I can do another remote session. Assign back to me so that I can correct Forum posts, Wiki and create general mail to others what scripts needs to be avoided with caution. |
|
|
Instructed the user via ticket PND-343173 |
|
|
Fixed in build 1648. There indeed was a problem when drive is replaced and thus two rows with different SN (but same drive letter) exists in the medias table |
|
|
Verified 1659 |
