0003342: Music views do not work under some rare circumstances (1 Viewer)

[MediaPortal-Bot]

There are a couple of scenarios where music views will return no data even the views are logically correct.

If you add a view with a grouped filter at anything other than the top level (eg
Genre
Album Artist (Grouped)
Album Artist
Album
Disc#
Tracks
https://forum.team-mediaportal.com/listen-music-99/problem-music-views-91880/ [^]

2011-01-07 17:45:22.385800 [Info.][MPMain(1)]: SQLiteClient: MusicDatabaseV11.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: strGenre query:select UPPER(SUBSTR(strArtist,1,1)) IX, Count(distinct strArtist), * from artist where strGenre like '%| Alben |%' group by ix order by strArtist asc
2011-01-07 17:45:22.396800 [Info.][MPMain(1)]: musicdatabase exception errQLiteClient: MusicDatabaseV11.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:no such column: strGenre query:select UPPER(SUBSTR(strArtist,1,1)) IX, Count(distinct strArtist), * from artist where strGenre like '%| Alben |%' group by ix order by strArtist asc stack: bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
bei SQLite.NET.SQLiteClient.Execute(String query)
bei MediaPortal.Music.Database.MusicDatabase.DirectExecute(String aSQL)
bei MediaPortal.Music.Database.MusicDatabase.GetSongsByIndex(String aSQL, List`1& aSongs, Int32 aLevel, String filter)

Also if you create a view such as
Composer (Grouped)
Album Artist
Album
Disc#
Tracks

This returns errors too and no data
https://forum.team-mediaportal.com/mediaportal-1-1-0-beta-1-454/error-music-views-71972/ [^]
then you end up with no data being shown

http://mantis.team-mediaportal.com/view.php?id=3342

Open the issue in Mantis...