[solved] SQLlite Error: duplicate column name ??? how to fix (1 Viewer)

katze

Portal Member
November 14, 2008
23
0
Hi

i have checked my log files and see that TVSeries Plugin and FanartHandler Plugin causes SQLLite errors:
The Plugins want to Alter the Table with a new column, which alredy exists for many times.
The Plugins want to Update the Table which is non existing.

Code:
[2015-08-19 08:56:57,160] [Error  ] [MPMain  ] [ERROR] - SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: StopTime query:ALTER TABLE local_episodes ADD StopTime Int
How can i Fix this issue ???
 

m3rcury

Development Group
  • Team MediaPortal
  • August 12, 2010
    962
    707
    Malta Malta
    Country flag
    Hi

    i have checked my log files and see that TVSeries Plugin and FanartHandler Plugin causes SQLLite errors:
    The Plugins want to Alter the Table with a new column, which alredy exists for many times.
    The Plugins want to Update the Table which is non existing.

    Code:
    [2015-08-19 08:56:57,160] [Error  ] [MPMain  ] [ERROR] - SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: StopTime query:ALTER TABLE local_episodes ADD StopTime Int
    How can i Fix this issue ???

    @katze. By any chance, do you use MPSync plugin?
     

    m3rcury

    Development Group
  • Team MediaPortal
  • August 12, 2010
    962
    707
    Malta Malta
    Country flag
    Yes i use MPSync to Sync client with MPExtended Web Frontend.
    @katze. So what could have happened is that you updated your master HTPC and then through MPSync, the table changes were propagated to the other HTPCs. Now lately there was an upgrade in TV-Series that fails if it finds the tables already containing the new fields. What I had done on my setup is to delete the TVSeriesDatabase4.db3 on the target client. Install the latest TV-Series plugin and then use MPSync to synchronise with your master database.

    This should solve the errors you are encountering. If you also have issues with FanartHandler plugin, do the same, although I didn't have issues with this plugin.

    Hope this helps.
     

    katze

    Portal Member
    November 14, 2008
    23
    0
    thank you.
    I have deleted db3 files and created new tvseries and fanart database. (on server and client)
    now the issue is fixed.
     

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

    OP Similar threads Forum Replies Date
    F MediaPortal 1.16 server crashing due to user error? General Support 5
    CanadianEh MP TV server rebuild with Colossus 2 - Kodi clients receive PMT error when playing videos recoreded by Colossus 2 TV-Server 1
    M 1.25.0 Tv Server Configuration Italian Dvb-t2 test channel preview error Television (MyTV frontend and TV-Server) 7
    G [solved] timeshift error Newcomers Forum 2
    C Can't install any extensions - DLL error Installation, configuration support 19
    horned_reaper Errors in FH log ... Fanart Handler 1
    joecrow 1.25.0 5031: Error on Install. Bugreports 24
    M MediaPortal2 TV Config Error on Install (0x80004005) General 7
    J Blue Screen Error Submit: Bug Reports 0
    G Q about scheduling weekly series when epg lists duplicate back to back episodes each week General Support 2
    Rob Hexenmeister Dependency error on install v2.3.2.0 OnlineVideos 28
    catavolt [WiP] When changing theme in my skins, I always get this error message in logs MediaPortal 1 9
    F Error invoking action 'GetNowNextProgramForGroup' Submit: Bug Reports 3
    B MP 2.2.3 Error playing videos from NAS Submit: Bug Reports 2
    vvulture UNKNOWN ERROR when starting live TV General Support 6
    doskabouter Build errors MediaPortal 1 9
    ajs Trakt error when start with MP crash Trakt 1
    horned_reaper MediaPortal configuration error log message General Support 1
    horned_reaper MiniDisplayStatus error log messages General Support 7
    horned_reaper [solved] GUITextureManager Load2 log error messages Fanart Handler 1
    horned_reaper MediaPortal.LastFM.LastFMException error log message General Support 1
    R [solved] No Response from Home Page - Error Newcomers Forum 0
    globaldonkey Music Database Error Listen Music 1
    ajs [solved] 4982: Why this error hard stop when Mediaportal start? MediaPortal 1 3
    thepahakurki Trakt error: Invalid or missing file Trakt 8
    Similar threads

























    Top Bottom