View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003811 | MMW v4 | Synchronization | public | 2007-10-23 16:34 | 2007-10-26 17:18 |
| Reporter | jiri | Assigned To | |||
| Priority | immediate | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Product Version | 3.0 | ||||
| Fixed in Version | 3.0 | ||||
| Summary | 0003811: SQL error in Device configuration dialog | ||||
| Description | An EL from a user showed the following error: Error executing SQL "SELECT NULL FROM Songs WHERE Songs.IDFolder in (SELECT IDChildFolder FROM FoldersHier WHERE IDFolder=?) AND (SELECT Songs.Id FROM Songs AND NOT Songs.id = -5 AND NOT exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id) ) " : near "AND": syntax error (1, 1). From my search it seems to be caused by the following code from FormDeviceConfig.pas: if (MusicFilter = nil) or (MusicFilter.actFilter <> currID) then begin myFreeAndNil( MusicFilter); // Need to re-init filter MusicFilter := TFilter.Create; AudiobooksQuery := JoinAudiobooksFilters(' AND NOT '); if CBFilter.ItemIndex = 0 then begin MusicFilter.SetFilter( -1, ' NOT ' + AudiobooksQuery //Exlude audiobooks + ' AND NOT ' + PodcastQuery); //Exclude podcasts end else begin MusicFilter.SetFilter( currID, FMainWindow.FiltersManager.GetFilterQuery( currID) // Current music filter query + ' AND NOT ' + AudiobooksQuery//Exlude audiobooks + ' AND NOT ' + PodcastQuery); //Exclude podcasts end end; | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1092 | ||||
