Reply to thread

Message

<blockquote data-quote="nino" data-source="post: 220082" data-attributes="member: 59214">Hi hwahrmann and nip.nyborg Thanks for your replies!Its not a &quot;space problem&quot; - indeed there is an sql exception.I updated the tag of one song so that Mediaportal would update the database. In Mediaportal.log the following showed up:2008-01-02 21:07:19.125000 [Info.][MPMain]: SQLiteClient: MusicDatabaseV10.db3 cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:ERROR detailed:near &quot;s&quot;: syntax error query:select * from tracks where strAlbumArtist like '%| Pavlov''s Dog |%' and strAlbum like 'At The Sound Of The Bell' and strAlbumArtist like '%| Pavlov's Dog |%'&nbsp; order by iTrack asc2008-01-02 21:07:19.140625 [Info.][MPMain]: musicdatabase exception err<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />QLiteClient: MusicDatabaseV10.db3 cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:ERROR detailed:near &quot;s&quot;: syntax error query:select * from tracks where strAlbumArtist like '%| Pavlov''s Dog |%' and strAlbum like 'At The Sound Of The Bell' and strAlbumArtist like '%| Pavlov's Dog |%'&nbsp; order by iTrack asc stack:&nbsp;&nbsp; at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)&nbsp;&nbsp; at SQLite.NET.SQLiteClient.Execute(String query)&nbsp;&nbsp; at MediaPortal.Music.Database.MusicDatabase.GetSongsByFilter(String aSQL, List`1&amp; aSongs, String filter)2008-01-02 21:07:19.140625 [Info.][MPMain]: MusicDatabase: Opening database2008-01-02 21:07:19.140625 [Info.][MPMain]: MusicDatabase: Database openedWhen viewing a plain song listing (&quot;title view&quot;?) the songs are visible.Cheers,Nino</blockquote>

[QUOTE="nino, post: 220082, member: 59214"] Hi hwahrmann and nip.nyborg Thanks for your replies! Its not a "space problem" - indeed there is an sql exception. I updated the tag of one song so that Mediaportal would update the database. In Mediaportal.log the following showed up: 2008-01-02 21:07:19.125000 [Info.][MPMain]: SQLiteClient: MusicDatabaseV10.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "s": syntax error query:select * from tracks where strAlbumArtist like '%| Pavlov''s Dog |%' and strAlbum like 'At The Sound Of The Bell' and strAlbumArtist like '%| Pavlov's Dog |%' order by iTrack asc 2008-01-02 21:07:19.140625 [Info.][MPMain]: musicdatabase exception err:SQLiteClient: MusicDatabaseV10.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "s": syntax error query:select * from tracks where strAlbumArtist like '%| Pavlov''s Dog |%' and strAlbum like 'At The Sound Of The Bell' and strAlbumArtist like '%| Pavlov's Dog |%' order by iTrack asc stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err) at SQLite.NET.SQLiteClient.Execute(String query) at MediaPortal.Music.Database.MusicDatabase.GetSongsByFilter(String aSQL, List`1& aSongs, String filter) 2008-01-02 21:07:19.140625 [Info.][MPMain]: MusicDatabase: Opening database 2008-01-02 21:07:19.140625 [Info.][MPMain]: MusicDatabase: Database opened When viewing a plain song listing ("title view"?) the songs are visible. Cheers, Nino [/QUOTE]

Verification