View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011872 | MMW v4 | DB/FileMonitor | public | 2014-02-15 20:01 | 2014-02-20 00:01 |
| Reporter | lowlander | Assigned To | |||
| Priority | urgent | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.1 | ||||
| Target Version | 4.1.1 | Fixed in Version | 4.1.1 | ||
| Summary | 0011872: Upgrade creates phantom Genres | ||||
| Description | Some users are reporting that the upgrade created new genres without any files associated. | ||||
| Additional Information | OPE-763546 http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=75472 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1693 | ||||
|
|
I don't see a reason for it and we cannot replicate the issue. Assigned to Peke as he has a suspicion on a script issue, assigned to him to collect more info from users and to get MM.DB copy prior to performing the 4.0 -> 4.1 upgrade. |
|
|
I think that the issue is that MM 4.1 shows all genres in the media tree while MM 4.0 shows only used genres there, assigned to me for fix. |
|
|
It was caused by 0009193 optimizations, nevertheless I've gone through the code and I haven't found a way how unused Genres could remain in the database, when a song is deleted then delete_songs trigger deletes it also from GenresSongs table which results in decreasing Genres.UsageCount value and when Genres.UsageCount = 0 then the corresponding genre is auto-deleted. So I wonder how the unused genres could get to the user's databases? Peke, do you still think it could be a script issue? BTW: I saw from the forum link that there is also script that can correct it for the affected users (http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=75472#p383665) So generally there is nothing bad in the MM code, we just don't know how the unused genres could get to the user's databases. We should add code that will fix that to DB maintenance so that the affected users don't need to run the script. EDIT: I found that it already is in the DB maintenace (both Optimize Database options do it), to be found why it doesn't work on the user's DB |
|
|
I downloaded the user's DB from ticket OPE-763546 and he have a lot of genres with (Genres.UsageCount = 0) for some reason. Fixed in build 4.1.1.1693 so that they are not shown even if the DB maintain isn't performed (test note: browse 'Entire Library' to reproduce) + fixed also in DB maintenance, note that the 'Optimize database (Quick)' option is enough to remove the unused items. |
|
|
Verified 1693 with user DB |
