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

OnkelChris

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

    • MS_SQL_56_57.patch
      1.9 KB

    romuz

    Retired Team Member
  • Premium Supporter
  • July 26, 2008
    1,045
    250
    Moskau
    Home Country
    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
    Home Country
    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
    Home Country
    United Kingdom United Kingdom
    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
    Home Country
    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

    Top Bottom