Unhandled exception - recorded TV episode playback (1 Viewer)

rossparkes

Portal Member
May 18, 2012
8
0
58
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
 

mm1352000

Development Group
  • Team MediaPortal
  • September 1, 2008
    21,571
    8,218
    New Zealand New Zealand
    Country flag
    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
     

    rossparkes

    Portal Member
    May 18, 2012
    8
    0
    58
    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
     

    mm1352000

    Development Group
  • Team MediaPortal
  • September 1, 2008
    21,571
    8,218
    New Zealand New Zealand
    Country flag
    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?
     

    rossparkes

    Portal Member
    May 18, 2012
    8
    0
    58
    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.
     

    rossparkes

    Portal Member
    May 18, 2012
    8
    0
    58
    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
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,697
    7,081
    Sydney
    Australia Australia
    Country flag
    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.
     

    rossparkes

    Portal Member
    May 18, 2012
    8
    0
    58
    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:
     

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

    OP Similar threads Forum Replies Date
    CyberSimian Unhandled exception in TV Server TV-Server 0
    R Unhandled Exception Allgemeines Support- und Diskussionsforum 3
    rexdog unhandled exception error, and, no sound on first TV channel selected - fine afterwards General 2
    T [further infos missing] Unhandled exception 2.2 Archive 5
    doskabouter Exceptions found due to improved logging General Support 11
    ltfearme Exception thrown when SetText in GUI Notification dialog Titan Skin Feedback 3
    P MP2 TV Server crashes when starting - throws error remoting exception General 2
    uxDesign Can't play Blu Ray: VideoPlayer9: Exception while creating DShow graph 1.20 2
    Terra [fixed] MP2 Importer Exception of type 'System.OutOfMemoryException' was thrown. 2.2 Archive 38
    R Exception while creating DShow graph Watch / Listen Media 12
    toricred Only Show Actual Recordings General 1
    ajs How recreate Recording thumbs TV-Server 4
    P [solved] MP2 new install, 2 x hdhomerun tuners, client on same PC unable to view TV & recordings Newcomers Forum 8
    CyberSimian [Proposal] Tool to display time of next recording MediaPortal 1 0
    Golf4 TV-Records werden als Audio-Files importiert ? Allgemeines Support- und Diskussionsforum 0
    R [solved] Unable to delete single recording General 2
    R Correct setting for recordings on shared folder General 0
    W [solved] MP suddenly Crashes when starting live TV on most channels and on recordings from the same channels General Support 20
    W [solved] MP suddenly Crashes when starting live TV on some channels and on some recordings Television (MyTV frontend and TV-Server) 1
    S Shortcuts MP1 My Recorded & TV Guide General 10
    F How to reset tv recordings database General 5
    P Recordings not showing up unless re-imported and not possible to delete General 0
    X Recording import hängt Allgemeines Support- und Diskussionsforum 0
    F Recording starts at second time only MediaPortal 1 Talk 6
    T TV Recording Schedule General 2
    Similar threads

























    Top Bottom