View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006049 | MMW v4 | DB/FileMonitor | public | 2009-10-16 16:25 | 2009-11-01 02:55 |
| Reporter | Ludek | Assigned To | |||
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Target Version | 3.1.2 | Fixed in Version | 3.1.2 | ||
| Summary | 0006049: Database reference integrity: several missing SQL triggers | ||||
| Description | There are some missing triggers in our database, this way there can remain some reference dead-links e.g. when a device is deleted. Possible "false reference" rows can be on the following DB tables: SynchPlaylist, SynchLocation, SynchArtist, SynchAlbum, SynchPlaylist, SynchPodcast, DeviceFilters, ArtistsAlbums, ArtistsAlbums, GenresSongs, PodcastEpisodes. | ||||
| Additional Information | http://www.mediamonkey.com/forum/viewtopic.php?f=18&t=35231&st=0&sk=t&sd=a&start=105#p222156 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1276 | ||||
|
|
Added the missing triggers in build 1275. And tested for regressions. |
|
|
Cross checked triggers and schema. Looks like still 4 missing trigger actions. Folders.IDMedia->Medias.ID PathProcessing.IDMedia->Medias.ID SynchLocation.IDMedia->Medias.ID Played.IDSong->Songs.ID |
|
|
Thx. Re-opened. |
|
|
Fixed in build 1276. |
|
|
Verified in 1276. |
|
|
Confirmed 1282 |
