View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0006241||MMW v4||DB/FileMonitor||public||2010-01-10 17:04||2010-10-08 23:47|
|Fixed in Version||4.0|
|Summary||0006241: 'Maintain Library' doesn't fix some DB inconsistencies|
|Description||'Maintain Library' recreates and fixes inconsistencies and DB integerity issues, and cleans and optimizes database.|
Nevertheless there are some inconsistencies like the one from ticket ATT-707700 that 'Maintain Library' doesn't fix. The problematic DB is attached on our FTP ( /MMeSupportTickets/BXG-495116 ), where the genre 'Sound Track' leaves in the main tree and cannot be deleted, because of inconsistence between Songs and GenresSongs table where corresponding Songs.ID for GenresSongs.IDSong doesn't exist.
I don't know how this inconsistency could happen, probably a script caused it, because there are DB triggers in MediaMonkey responsible for deletion of GenresSongs.IDSong when corresponding Songs entry is deleted.
|Fixed in build||1301|