[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

    Code:
    [SetupTv(1)]:   Exec SQL: ALTER TABLE Program   DROP COLUMN notify
    .
    .
    .
    Exec SQL: ALTER TABLE Program   DROP COLUMN notify
    [SetupTv(1)]:   ********* SQL statement failed! *********
    [SetupTv(1)]:   ********* Error reason: Fehler bei ALTER TABLE DROP COLUMN, da die 'notify'-Spalte in der 'Program'-Tabelle nicht vorhanden ist.
    [SetupTv(1)]:   ********* Error code: 4924, Line: 1 *********
    [SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN pcrPid
    [SetupTv(1)]:   ********* SQL statement failed! *********
    [SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_TuningDetail_idChannel' ist vom Spalte-Objekt 'pcrPid' abhängig.
    Fehler bei ALTER TABLE DROP COLUMN pcrPid, da mindestens ein Objekt auf diese Spalte zugreift.
    [SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
    [SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN videoPid
    [SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN audioPid
    [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=56
    .
    .
    .
    [SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "name"
    [SetupTv(1)]:   ********* SQL statement failed! *********
    [SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_Channel_IsTV' ist vom Spalte-Objekt 'name' abhängig.
    Fehler bei ALTER TABLE DROP COLUMN name, da mindestens ein Objekt auf diese Spalte zugreift.
    [SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
    [SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "freetoair"
    [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=57

    ok... i get it now a bit... it is deleting the "notify" column... then it tries this again -> 1st fail... then tries to drop "pcrPid" but there is a dependency on "IX_TuningDetail_idChannel" -> 2nd fail... and on deleting "name" there is a dependency on IX_Channel_IsTV -> 3rd fail...

    why is this just happening on my installations? should fail on all or none :mad:
     

    romuz

    Retired Team Member
  • Premium Supporter
  • July 26, 2008
    1,045
    250
    Moskau
    Russian Federation Russian Federation
    Re: Latest SVN - TVServer DB exceptions

    Most of us use MySQL server
    but you (if i checked correctly) use MS SQL server.
    is not it?
    if so then it could be a root of problem
     

    OnkelChris

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

    yeah.. i am using sql server 2008 express... perhaps this is the root of the problem... but there must be a solution ;) (atm i am fighting with the database and sql server management studio ^^)
     

    romuz

    Retired Team Member
  • Premium Supporter
  • July 26, 2008
    1,045
    250
    Moskau
    Russian Federation Russian Federation
    Re: Latest SVN - TVServer DB exceptions

    If you do it manually, Could you generate and upload commands executed in ms sql
     

    OnkelChris

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

    got it :)

    i only have to figure out, how to get the statements in the correct order... ;) will report back


    EDIT:
    could someone please upload his mySQL database or better: a complete report which tables consists of which columns... don't know how the failures are handled in the MP scripts...
     

    OnkelChris

    Retired Team Member
  • Premium Supporter
  • October 17, 2007
    764
    59
    Germany Germany
    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:
     

    Attachments

    romuz

    Retired Team Member
  • Premium Supporter
  • July 26, 2008
    1,045
    250
    Moskau
    Russian Federation Russian Federation
    Re: Latest SVN - TVServer DB exceptions

    MP works with different db types separately so it doesnt affect mysql. And thank you for sharing results
     

    OnkelChris

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

    MP works with different db types separately so it doesnt affect musql
    yeah, but tvserver relies on the same tables and columns... i just wanted a original mySQL database in version 57 to compare with my database, so every table has the right columns ;)
     

    Jay_UK

    Test Group
  • Team MediaPortal
  • October 6, 2009
    1,781
    283
    Derby
    United Kingdom United Kingdom
    Country flag
    Re: Latest SVN - TVServer DB exceptions

    Hi there,

    Weird..how come it worked for me ? (or am I being dumb and not seeing the failure???)

    Looking at your SQL/patch...would not recreating indexes and droping columns cause the install to fail? (just curious)

    Thanks,

    J.

    ps - Glad you sorted it :D
     

    romuz

    Retired Team Member
  • Premium Supporter
  • July 26, 2008
    1,045
    250
    Moskau
    Russian Federation Russian Federation
    Re: Latest SVN - TVServer DB exceptions

    now it should be the same, except the indexes :))
     

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

    OP Similar threads Forum Replies Date
    Stephen O'Kane [SOLVED] TV Stream stuttering - both Video and Audio Watch / Listen Media 14
    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
    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
    Top Bottom