MusicDatabase query syntax error for artists / albums with quote in name (1 Viewer)

Kucheek

Portal Member
December 18, 2008
22
8
Prague
Czech Republic Czech Republic
MediaPortal Version: 1.4.0

Description
Although this problem occurs when MP is triggered by external plugin, it occurs in MP core (MusicDatabase) and also I am not able to figure out if it is caused by incorrect call from the plugin, or if the interface of MusicDatabase itself is the cause.

MediaPortal Version: 1.5.0.0

WifiRemote Version: 0.7.1.0
MPExtended Version: 0.5.4
aMPdroid Version: 1.1.3

Actions to simulate the issue:

1. Start MediaPortal
2. Connect to MediaPortal using aMPdroid
3. Access the Artists view in the Music section of aMPdroid
4. View the albums of an artist which contains quote in name
5. Try playing any of the albums of the selected artist in MediaPortal (PlayOnPc action)

Result:

Playback does not start. Error is generated in MP log (see below).

[2013-10-12 18:02:59,832] [Error ] [12 ] [ERROR] - SQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "s": syntax error query:select * from tracks where strAlbumArtist like '%Blackmore's Night%' AND strAlbum LIKE '%Shadow of the Moon%' order by iTrack ASC
[2013-10-12 18:02:59,882] [Error ] [12 ] [ERROR] - musicdatabase exception err:confused:QLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "s": syntax error query:select * from tracks where strAlbumArtist like '%Blackmore's Night%' AND strAlbum LIKE '%Shadow of the Moon%' order by iTrack ASC stack: v SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
v SQLite.NET.SQLiteClient.Execute(String query)
v MediaPortal.Music.Database.MusicDatabase.DirectExecute(String aSQL)
v MediaPortal.Music.Database.MusicDatabase.GetSongsByFilter(String aSQL, List`1& aSongs, String filter)

The same issue was already solved in past in this thread:

https://forum.team-mediaportal.com/threads/apostrophe-in-artist-name.33306/#post-220082

Steps to Reproduce:
Actions to simulate the issue:

1. Start MediaPortal
2. Connect to MediaPortal using aMPdroid
3. Access the Artists view in the Music section of aMPdroid
4. View the albums of an artist which contains quote in name
5. Try playing any of the albums of the selected artist in MediaPortal (PlayOnPc action)

Result:

Playback does not start. Error is generated in MP log
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

OP Similar threads Forum Replies Date
J upgraded to mp2 but have a few queries! General 17
Rob Hexenmeister Conditional syntax General Support 7
Similar threads


Top Bottom