home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Quality Assurance
Bugtracker Feed
0003342: Music views do not work under some rare circumstances
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MediaPortal-Bot" data-source="post: 703896" data-attributes="member: 48617"><p>There are a couple of scenarios where music views will return no data even the views are logically correct.</p><p></p><p>If you add a view with a grouped filter at anything other than the top level (eg</p><p>Genre</p><p>Album Artist (Grouped)</p><p>Album Artist</p><p>Album</p><p>Disc#</p><p>Tracks</p><p><a href="https://forum.team-mediaportal.com/listen-music-99/problem-music-views-91880/" target="_blank">https://forum.team-mediaportal.com/listen-music-99/problem-music-views-91880/</a> [<a href="https://forum.team-mediaportal.com/listen-music-99/problem-music-views-91880/" target="_blank">^</a>]</p><p></p><p>2011-01-07 17:45:22.385800 [Info.][MPMain(1)]: SQLiteClient: MusicDatabaseV11.db3 cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue :p" loading="lazy" data-shortname=":p" />vm=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</p><p>2011-01-07 17:45:22.396800 [Info.][MPMain(1)]: musicdatabase exception err<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused :confused:" loading="lazy" data-shortname=":confused:" />QLiteClient: MusicDatabaseV11.db3 cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue :p" loading="lazy" data-shortname=":p" />vm=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)</p><p> bei SQLite.NET.SQLiteClient.Execute(String query)</p><p> bei MediaPortal.Music.Database.MusicDatabase.DirectExecute(String aSQL)</p><p> bei MediaPortal.Music.Database.MusicDatabase.GetSongsByIndex(String aSQL, List`1& aSongs, Int32 aLevel, String filter)</p><p></p><p>Also if you create a view such as</p><p>Composer (Grouped)</p><p>Album Artist</p><p>Album</p><p>Disc#</p><p>Tracks</p><p></p><p>This returns errors too and no data</p><p><a href="https://forum.team-mediaportal.com/mediaportal-1-1-0-beta-1-454/error-music-views-71972/" target="_blank">https://forum.team-mediaportal.com/mediaportal-1-1-0-beta-1-454/error-music-views-71972/</a> [<a href="https://forum.team-mediaportal.com/mediaportal-1-1-0-beta-1-454/error-music-views-71972/" target="_blank">^</a>]</p><p>then you end up with no data being shown</p><p></p><p><a href="http://mantis.team-mediaportal.com/view.php?id=3342" target="_blank">http://mantis.team-mediaportal.com/view.php?id=3342</a></p><p></p><p><a href="http://mantis.team-mediaportal.com/view.php?id=3342" target="_blank">Open the issue in Mantis...</a></p></blockquote><p></p>
[QUOTE="MediaPortal-Bot, post: 703896, member: 48617"] 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 [URL]https://forum.team-mediaportal.com/listen-music-99/problem-music-views-91880/[/URL] [[URL="https://forum.team-mediaportal.com/listen-music-99/problem-music-views-91880/"]^[/URL]] 2011-01-07 17:45:22.385800 [Info.][MPMain(1)]: SQLiteClient: MusicDatabaseV11.db3 cmd:sqlite3_prepare16:pvm=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 err:SQLiteClient: MusicDatabaseV11.db3 cmd:sqlite3_prepare16:pvm=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 [URL]https://forum.team-mediaportal.com/mediaportal-1-1-0-beta-1-454/error-music-views-71972/[/URL] [[URL="https://forum.team-mediaportal.com/mediaportal-1-1-0-beta-1-454/error-music-views-71972/"]^[/URL]] then you end up with no data being shown [url]http://mantis.team-mediaportal.com/view.php?id=3342[/url] [url=http://mantis.team-mediaportal.com/view.php?id=3342]Open the issue in Mantis...[/url] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Quality Assurance
Bugtracker Feed
0003342: Music views do not work under some rare circumstances
Contact us
RSS
Top
Bottom
