[fixed] - [SOLVED]Latest SVN - TVServer DB exceptions | Page 3

Discussion in 'MediaPortal 1.2.0 ALPHA' started by OnkelChris, January 7, 2011.

  1. OnkelChris
    • Team MediaPortal

    OnkelChris Retired Team Member

    Joined:
    October 17, 2007
    Messages:
    764
    Likes Received:
    59
    Ratings:
    +59 / 0
    Home Country:
    Germany Germany
    AW: Latest SVN - TVServer DB exceptions

    Code (Text):
    1.  
    2. [SetupTv(1)]:   Exec SQL: ALTER TABLE Program   DROP COLUMN notify
    3. .
    4. .
    5. .
    6. Exec SQL: ALTER TABLE Program   DROP COLUMN notify
    7. [SetupTv(1)]:   ********* SQL statement failed! *********
    8. [SetupTv(1)]:   ********* Error reason: Fehler bei ALTER TABLE DROP COLUMN, da die 'notify'-Spalte in der 'Program'-Tabelle nicht vorhanden ist.
    9. [SetupTv(1)]:   ********* Error code: 4924, Line: 1 *********
    10. [SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN pcrPid
    11. [SetupTv(1)]:   ********* SQL statement failed! *********
    12. [SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_TuningDetail_idChannel' ist vom Spalte-Objekt 'pcrPid' abhängig.
    13. Fehler bei ALTER TABLE DROP COLUMN pcrPid, da mindestens ein Objekt auf diese Spalte zugreift.
    14. [SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
    15. [SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN videoPid
    16. [SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN audioPid
    17. [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=56
    18. .
    19. .
    20. .
    21. [SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "name"
    22. [SetupTv(1)]:   ********* SQL statement failed! *********
    23. [SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_Channel_IsTV' ist vom Spalte-Objekt 'name' abhängig.
    24. Fehler bei ALTER TABLE DROP COLUMN name, da mindestens ein Objekt auf diese Spalte zugreift.
    25. [SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
    26. [SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "freetoair"
    27. [SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=57
    28.  

    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:
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. romuz
    • Team MediaPortal

    romuz Retired Team Member

    Joined:
    July 26, 2008
    Messages:
    1,045
    Likes Received:
    125
    Location:
    Moskau
    Ratings:
    +126 / 0
    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
     
  4. OnkelChris
    • Team MediaPortal

    OnkelChris Retired Team Member

    Joined:
    October 17, 2007
    Messages:
    764
    Likes Received:
    59
    Ratings:
    +59 / 0
    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 ^^)
     
  5. romuz
    • Team MediaPortal

    romuz Retired Team Member

    Joined:
    July 26, 2008
    Messages:
    1,045
    Likes Received:
    125
    Location:
    Moskau
    Ratings:
    +126 / 0
    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
     
  6. OnkelChris
    • Team MediaPortal

    OnkelChris Retired Team Member

    Joined:
    October 17, 2007
    Messages:
    764
    Likes Received:
    59
    Ratings:
    +59 / 0
    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...
     
    • Like Like x 1
  7. OnkelChris
    • Team MediaPortal

    OnkelChris Retired Team Member

    Joined:
    October 17, 2007
    Messages:
    764
    Likes Received:
    59
    Ratings:
    +59 / 0
    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:
     

    Attached Files:

  8. romuz
    • Team MediaPortal

    romuz Retired Team Member

    Joined:
    July 26, 2008
    Messages:
    1,045
    Likes Received:
    125
    Location:
    Moskau
    Ratings:
    +126 / 0
    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
     
  9. OnkelChris
    • Team MediaPortal

    OnkelChris Retired Team Member

    Joined:
    October 17, 2007
    Messages:
    764
    Likes Received:
    59
    Ratings:
    +59 / 0
    Home Country:
    Germany Germany
    AW: Re: Latest SVN - TVServer DB exceptions

    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 ;)
     
  10. Jay_UK
    • Team MediaPortal

    Jay_UK Test Group

    Joined:
    October 6, 2009
    Messages:
    1,781
    Likes Received:
    250
    Occupation:
    Enterprise Architect
    Location:
    Derby
    Ratings:
    +271 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    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
     
  11. romuz
    • Team MediaPortal

    romuz Retired Team Member

    Joined:
    July 26, 2008
    Messages:
    1,045
    Likes Received:
    125
    Location:
    Moskau
    Ratings:
    +126 / 0
    Home Country:
    Russian Federation Russian Federation
    Re: Latest SVN - TVServer DB exceptions

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

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!