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
vm=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 errQLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=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
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
vm=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
QLiteClient: MusicDatabaseV12.db3 cmd:sqlite3_prepare16vm=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