[fixed] [SOLVED]Latest SVN - TVServer DB exceptions (1 Viewer)

OnkelChris

Retired Team Member
  • Premium Supporter
  • October 17, 2007
    764
    59
    Germany Germany
    AW: Latest SVN - TVServer DB exceptions

    Jay_UK:
    are you running ms sql 2008 express sp1?
    what i saw is that it can't work on ms sql, because it tries to delete columns which are needed for the index... so dropping is not possible -> column exists on -> tvserver can't save things to the db...

    romuz:
    what do you mean... "now it should be the same"? you mean MS and mySQL databases are now the same?

    i am kind of f#$%ed up in my brain.. lost 4h with these failures... :mad:
     

    Jay_UK

    Test Group
  • Team MediaPortal
  • October 6, 2009
    1,781
    283
    Derby
    United Kingdom United Kingdom
    Country flag
    Hi there,

    Know how you feel...annoying things like this can really mess with ya mind! :(

    From my little SQL knowledge, having an index that is not valid, just means it potentially affects performance (but the SQL should still execute), and again, not dropping a column should not stop SQL from executing.

    Anyway.. main thing is that you have fixed it :D

    Yep..I'm running MS SQL 2008 express

    J.
     

    OnkelChris

    Retired Team Member
  • Premium Supporter
  • October 17, 2007
    764
    59
    Germany Germany
    AW: [SOLVED]Latest SVN - TVServer DB exceptions

    did you do a clean install of the svn or an upgrade? i saw the upgrades not throwing exception on failing the upgrade, but clean installs throw messageboxes on running the tvserver config without having the service running... ok.. weird... this sounds crazy... in short:

    after clean installation -> tvserver started -> running tvserver config -> executes

    after clean installation -> tvserver stopped -> running tvserver config -> failure

    after upgrade i can't get the "upgrade failed" message...


    the problem is not that the index is wrong.. the problem is that there are dependencies on columns in the index... so the column can't be dropped... for me, it does not allow to save anything to the database

    Jay_UK:
    have you tried to do a channel scan afterwards? does it create/update the channels right?
     

    Mr Hipp

    Retired Team Member
  • Premium Supporter
  • April 2, 2006
    1,261
    188
    52
    Malmö
    Sweden Sweden
    Re: AW: Latest SVN - TVServer DB exceptions

    OK... Finally I did it.. here is the solution... does work without any failures in upgrading. due to the lack of a mySQL database I do not know if it is 100% correct. I only replaced the parts which ran into failures... So here it is for SVN 27200:

    :mad:
    Patch applied to svn. Thanks OnkelChris!

    Mr Hipp
     

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

    OP Similar threads Forum Replies Date
    cladinshadows85 timeshift error <solved> General 2
    F [Solved] Movies View with Thumbnail Layou General Support 4
    squidina [solved] - MediaPortal 1.22 won't start even with new install General Support 4
    J [solved] Lag on client-only PCs General 0
    joecrow [solved] (Solved) Win 10 1809 Woes General Support 4
    L [solved] MovPicNFO mit NAS? Video & DVD 1
    joecrow (Solved) EPG wrong General Support 18
    D [SOLVED] Radio issue in MediaPortal 1.20 Pre-Release 1.20 Pre Release 47
    TheBatfink [solved] Homescreen tile labels are offset Titanius 3
    1gkar Latest Intel HD4600 Drivers Issue General Support 1
    Rob Hexenmeister [solved] Latest Media Handler - skinning buttons Fanart Handler 19
    T No TV after updating Windows 10 to latest Version 1903 / OS build 18362.175 (logs attached) General Support 2
    Rob Hexenmeister Latest Media Handler - facade properties - itemcount General Support 3
    G How best to get cover art for tracks to show up on the Audio Menu (Latest Added, Unplayed)? General 9
    Rob Hexenmeister [solved] Latest media handler - time reported as date Fanart Handler 18
    Rob Hexenmeister Video Buttons / Latest Media MediaPortal 1 Skins 7
    Lichloathe [solved] Latest Media Handler - Default view for TVSeries on startup Fanart Handler 2
    ajs [solved] Latest Media Handler - Skin settings - Custom latests items number Fanart Handler 27
    Rob Hexenmeister [solved] Latests Media Handler - Skinning an updating window or control Fanart Handler 26
    uxDesign [Question] Where are the latest sources of mpextended? MPExtended 3
    joEhSuper [solved] Latest Media Handler wrong version in MPE Fanart Handler 3
    Top Bottom