Unhandled exception - recorded TV episode playback

Discussion in 'Television (MyTV frontend and TV-Server)' started by rossparkes, September 10, 2013.

  1. rossparkes

    rossparkes Portal Member

    Joined:
    May 18, 2012
    Messages:
    8
    Likes Received:
    0
    Gender:
    Male
    Ratings:
    +0 / 0
    Home Country:
    New Zealand New Zealand
    Hi all,

    I've had MP 1.4 and MP-TVSeries (latest version) installed and working fine for quite some time now. However, I recently decided to reload my TV Server Channels and now when I play a TV series episode that was recorded after the channels were reloaded I get an Unhandled Exception message box pop up that starts with the following message;

    -----------------------------------------------------------------------------
    MP - TV/Fullscreen

    Unhandled exception has occurred in your application
    ...
    ************** Exception Text **************
    SQLite.NET.SQLiteException: SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "s": syntax error query:confused:ELECT EpisodeFilename, SeriesID, EpisodeIndex, SeasonIndex FROM local_episodes WHERE EpisodeFilename = 'D:\TV\TV ONE\Breakfast America's Cup Special\Breakfast America's Cup Special - 2013-09-09 - S1017592 - E10315501.ts'
    at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    at SQLite.NET.SQLiteClient.Execute(String query)
    at MP_XPressRemoteServer.Classes.TVSeriesHandler.getSeriesIDAndEpisodeNameByFileName(String fileName)
    at MP_XPressRemoteServer.MainClass.refreshPlaybackStatus()
    at MP_XPressRemoteServer.MainClass.timer_Tick(Object sender, EventArgs e)
    at System.Windows.Forms.Timer.OnTick(EventArgs e)
    at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    ...
    -------------------------------------------------------------------------------

    TV episodes recorded after the Channel reload still play fine, however I'm not able to get rid of the above Unhandled exception pop-up without closing MediaPortal.

    All episodes recorded prior to the Channel reload still play fine - with no Unhandled exception.

    I've tried deleting the episode, and then reloading it via the Database load option in the Recordings option of the TV Server Configuration - this did not fix the Unhandled exception



    I tried uninstalling the MP-TVSeries add-in. This did resolve the Unhandled exception, but when I reinstalled the add-in the exception came back again.

    I've had a look in the TVSeriesDatabase4 db but haven't been able to locate any of my recorded TV series, so this makes me wonder whether I've managed to screw up some internal reference when I reloaded the TV Server channels?

    At this point I really don't want to have to reinstall MediaPortal and add-ins, so I'd very much appreciate feedback from anyone else who has managed to resolve this problem.

    Many thanks
    Ross
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,527
    Likes Received:
    4,738
    Ratings:
    +8,205 / 17
    Home Country:
    New Zealand New Zealand
    Hello Ross and welcome Ross :)

    Looks to me like the issue is with the MP-TVSeries plugin not being able to handle the apostrophe/single-quote ' character in "America's Cup".
    You're going to need help from the MP-TVSeries plugin maintainer - @ltfearme.

    mm
     
  4. rossparkes

    rossparkes Portal Member

    Joined:
    May 18, 2012
    Messages:
    8
    Likes Received:
    0
    Gender:
    Male
    Ratings:
    +0 / 0
    Home Country:
    New Zealand New Zealand
    Hi mm,

    Thanks for responding so quickly :)

    It appears that you might be onto something with the single quote character - I've just tried playing back an episode from another series with a name that doesn't contain an apostrophe and it works fine.

    I'll do a bit more checking and then make contact with the plugin maintainer.

    Cheers
    Ross
     
  5. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,527
    Likes Received:
    4,738
    Ratings:
    +8,205 / 17
    Home Country:
    New Zealand New Zealand
    Just looking at your log entries again and the references to "MP_XPressRemoteServer"... do you have some kind of additional plugin (aside from MP-TVSeries) that could be hooking into the MP-TVSeries database?
     
  6. rossparkes

    rossparkes Portal Member

    Joined:
    May 18, 2012
    Messages:
    8
    Likes Received:
    0
    Gender:
    Male
    Ratings:
    +0 / 0
    Home Country:
    New Zealand New Zealand
    I'm running a pretty lean configuration. Here's all the extensions;

    BackupSettings
    Extensions
    FanartHandler
    LAVFilters
    MediaPortalUrlSourceSplitter
    MPRemote Server
    MP-TVSeries
    OnlineVideos
    TitanExtended
    Trakt for MediaPortal

    Trakt would look to be the only possibility, but I've not logged into it.
     
  7. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,527
    Likes Received:
    4,738
    Ratings:
    +8,205 / 17
    Home Country:
    New Zealand New Zealand
    At a guess, "MPRemote Server" could be the cause.
     
    • Agree Agree x 1
  8. rossparkes

    rossparkes Portal Member

    Joined:
    May 18, 2012
    Messages:
    8
    Likes Received:
    0
    Gender:
    Male
    Ratings:
    +0 / 0
    Home Country:
    New Zealand New Zealand
    I've just had a look at one of my other clients and realised that the Trakt version is different between them. I've now removed the newer version of Trakt from my TV Server and the problem has gone (y) - so it looks as though version 3.0.0.0 of Trakt has the SQL parsing issue not MP-TVSeries.

    Thanks for your help

    Cheers
    Ross
     
  9. ltfearme
    • Premium Supporter

    ltfearme Community Plugin Dev

    Joined:
    June 10, 2007
    Messages:
    6,458
    Likes Received:
    4,244
    Gender:
    Male
    Occupation:
    Software Test Engineer
    Location:
    Sydney
    Ratings:
    +5,388 / 0
    Home Country:
    Australia Australia
    Why do you think this is a Trakt issue? According to your call stack it's MPRemote Server. Trakt does not parse any SQL, it uses the MyTV API.

    Maybe MPRemote Server uses the Trakt plugin API for something, I have no idea as I haven't heard of that plugin before.
     
  10. rossparkes

    rossparkes Portal Member

    Joined:
    May 18, 2012
    Messages:
    8
    Likes Received:
    0
    Gender:
    Male
    Ratings:
    +0 / 0
    Home Country:
    New Zealand New Zealand
    Hi lifearme, you're correct, it's not a Trakt issue. After a bit more fiddling around I've been able to consistently create the issue by adding and removing the MPRemote Server. I'm still learning how to read the Exception text, so next time I'll spend a bit more time working through this before I start hacking around with the AddIns. :rolleyes:
     
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!