[solved] - TVServer config tool failed after update to 1.8.0

Discussion in 'General Support' started by RobNorthcott, July 2, 2014.

  1. RobNorthcott
    • Premium Supporter

    RobNorthcott MP Donator

    Joined:
    October 9, 2007
    Messages:
    493
    Likes Received:
    44
    Gender:
    Male
    Occupation:
    Software Developer
    Location:
    Dartmoor, England
    Ratings:
    +92 / 2
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    After updating to 1.8.0 final I can't run TVServer Config. It gives an error "failed to update database". The TV Server itself seems to be working though. Presumably something went wrong when upgrading MySQL. Is there anything I can try to fix it without doing a clean install of MP? (I did export TVServer settings before running the update)


     
    • Missing System Logs and/or Specs Missing System Logs and/or Specs x 1
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. 2BitSculptor
    • Team MediaPortal

    2BitSculptor Super Moderator

    Joined:
    January 23, 2008
    Messages:
    1,835
    Likes Received:
    301
    Occupation:
    Sculptor - Maquettes, Resin Figure Model Kits, Toy
    Location:
    South Central Wisconsin
    Ratings:
    +399 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    Same issue here...got the notice during install as well as when trying to run TV Server config.

    I finally got TV-Server re-installed sufficiently for my living room client machine to use ... but I jumped through a lot of hoops. Fortunately I exported my channels and settings before the upgrade, and was able to copy my schedules direct plugin back in from the TV-Server backup that was made when I upgraded. I am waiting until a couple recordings are done and I will try again to get the single seat fixed. The client obviously upgraded without a hitch.
     
  4. RobNorthcott
    • Premium Supporter

    RobNorthcott MP Donator

    Joined:
    October 9, 2007
    Messages:
    493
    Likes Received:
    44
    Gender:
    Male
    Occupation:
    Software Developer
    Location:
    Dartmoor, England
    Ratings:
    +92 / 2
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    Mine (single seat) appears to be working fine apart from not being able to run the TVServer config. I did export everything from the TVServer before doing the update so I could reinstall just the TVServer and MySQL from scratch but I'm just wondering whether there's a simple fix before I do that (as everything else seems to be working)
     
    • Missing System Logs and/or Specs Missing System Logs and/or Specs x 1
  5. Holzi
    • Team MediaPortal

    Holzi Super Moderator

    Joined:
    April 21, 2010
    Messages:
    7,928
    Likes Received:
    1,591
    Gender:
    Male
    Location:
    Ba-Wü
    Ratings:
    +2,228 / 8
    Home Country:
    Germany Germany
    Show System Specs
    Can you guys upload SetupTv.log file?
     
  6. RobNorthcott
    • Premium Supporter

    RobNorthcott MP Donator

    Joined:
    October 9, 2007
    Messages:
    493
    Likes Received:
    44
    Gender:
    Male
    Occupation:
    Software Developer
    Location:
    Dartmoor, England
    Ratings:
    +92 / 2
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    Sorry, didn't realise there's a setup log. Here it is (looks like it didn't update the SQL properly - but everything seems to be working fine except the config utility)[DOUBLEPOST=1404378291][/DOUBLEPOST]Here are all the logs just in case, so I don't get flagged again :)
     
    Last edited: July 3, 2014
  7. regeszter
    • Premium Supporter

    regeszter Retired Team Member

    Joined:
    October 29, 2005
    Messages:
    5,335
    Likes Received:
    2,863
    Ratings:
    +5,152 / 18
    Home Country:
    Hungary Hungary
    Try to run these statements form mysql command line or from mysql workbench.

    USE MpTvDb;
    ALTER TABLE canceledschedule ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE card ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE cardgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE cardgroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE channel ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE channelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE channellinkagemap ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE channelmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE conflict ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE diseqcmotor ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE favorite ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE groupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE history ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE keyword ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE keywordmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE pendingdeletion ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE personaltvguidemap ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE program ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE radiochannelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE radiogroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE recording CHANGE COLUMN fileName fileName VARCHAR(255) NOT NULL;
    ALTER TABLE recording ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE satellite ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE schedule CHANGE COLUMN programName programName VARCHAR(255) NOT NULL;
    ALTER TABLE schedule ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE server ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE setting ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE softwareencoder ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE timespan ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE tuningdetail ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE tvmoviemapping ENGINE=InnoDB ROW_FORMAT=COMPACT;
    ALTER TABLE version ENGINE=InnoDB ROW_FORMAT=COMPACT;
    UPDATE version SET versionNumber=62 WHERE idVersion=1;
     
    • Thank You! Thank You! x 2
  8. RobNorthcott
    • Premium Supporter

    RobNorthcott MP Donator

    Joined:
    October 9, 2007
    Messages:
    493
    Likes Received:
    44
    Gender:
    Male
    Occupation:
    Software Developer
    Location:
    Dartmoor, England
    Ratings:
    +92 / 2
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    Thanks for the reply - I'll try it later and let you know if it worked.
    Out of interest, do you know why the TVServer seems to be working completely fine (it even did a successful scheduled recording last night) but the config won't run?
     
  9. seco
    • Team MediaPortal

    seco Development Group

    Joined:
    August 7, 2007
    Messages:
    1,579
    Likes Received:
    897
    Gender:
    Male
    Ratings:
    +1,234 / 4
    Home Country:
    Finland Finland
    Show System Specs
    It might help to pinpoint the problem if you could tell us how much data (how many rows) you have in your tables by running

    select count(*) from canceledschedule;
    select count(*) from card;
    select count(*) etc....

    for each table, so we could check if the amount of data causes the time out.

    TVServer works fine (with old MyISAM tables) since only Config attempts the database update
     
    • Like Like x 1
  10. RobNorthcott
    • Premium Supporter

    RobNorthcott MP Donator

    Joined:
    October 9, 2007
    Messages:
    493
    Likes Received:
    44
    Gender:
    Male
    Occupation:
    Software Developer
    Location:
    Dartmoor, England
    Ratings:
    +92 / 2
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    OK, I'll do that before I try to do the update and let you know.
    Is it likely that some tables will have been updated already before it failed? If so (and assuming the database doesn't roll back to the old config after failing) will it do any harm if I run the alter table commands that regeszter posted above on a table that has already been converted?
     
  11. RobNorthcott
    • Premium Supporter

    RobNorthcott MP Donator

    Joined:
    October 9, 2007
    Messages:
    493
    Likes Received:
    44
    Gender:
    Male
    Occupation:
    Software Developer
    Location:
    Dartmoor, England
    Ratings:
    +92 / 2
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    @regeszter: running those commands manually has fixed it. Thank you :)

    @seco: Record counts in my system are as follows:
    canceledschedule 2
    card 11
    cardgroup 0
    cardgroupmap 0
    channel 2075
    channelgroup 4
    channellinkagemap 0
    channelmap 2881
    conflict 0
    diseqcmotor 0
    favorite 0
    groupmap 1827
    history 1616
    keyword 0
    keywordmap 0
    pendingdeletion 3
    personaltvguidemap 0
    program 66400
    radiochannelgroup 2
    radiogroup 386
    recording 109
    satellite 232
    schedule 10
    server 1
    setting 231
    softwareencoder 23
    timespan 0
    tuningdetail 2075
    tvmoviemapping 0
    version 1

    All tables took no more than a second or two (each) to update, apart from the big one (program) which took 13 seconds.
     
    Last edited: July 4, 2014
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!