MusicDatabase query syntax error for artists / albums with quote in name

Discussion in '1.5.x' started by Kucheek, October 12, 2013.

  1. Kucheek

    Kucheek Portal Member

    Joined:
    December 18, 2008
    Messages:
    22
    Likes Received:
    8
    Gender:
    Male
    Occupation:
    Software Test Analyst
    Location:
    Prague
    Ratings:
    +8 / 0
    Home Country:
    Czech Republic Czech Republic
    Show System Specs
    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
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Kucheek

    Kucheek Portal Member

    Joined:
    December 18, 2008
    Messages:
    22
    Likes Received:
    8
    Gender:
    Male
    Occupation:
    Software Test Analyst
    Location:
    Prague
    Ratings:
    +8 / 0
    Home Country:
    Czech Republic Czech Republic
    Show System Specs
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!