[solved] TVServer config tool failed after update to 1.8.0 (1 Viewer)

RobNorthcott

MP Donator
  • Premium Supporter
  • October 9, 2007
    540
    102
    Dartmoor, England
    Home Country
    United Kingdom United Kingdom
    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)
     

    2BitSculptor

    Super Moderator
  • Team MediaPortal
  • January 23, 2008
    1,948
    498
    South Central Wisconsin
    Home Country
    United States of America United States of America
    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.
     

    RobNorthcott

    MP Donator
  • Premium Supporter
  • October 9, 2007
    540
    102
    Dartmoor, England
    Home Country
    United Kingdom United Kingdom
    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)
     

    RobNorthcott

    MP Donator
  • Premium Supporter
  • October 9, 2007
    540
    102
    Dartmoor, England
    Home Country
    United Kingdom United Kingdom
    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:

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    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;
     

    RobNorthcott

    MP Donator
  • Premium Supporter
  • October 9, 2007
    540
    102
    Dartmoor, England
    Home Country
    United Kingdom United Kingdom
    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?
     

    seco

    Retired Team Member
  • Premium Supporter
  • August 7, 2007
    1,575
    1,239
    Home Country
    Finland Finland
    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
     

    RobNorthcott

    MP Donator
  • Premium Supporter
  • October 9, 2007
    540
    102
    Dartmoor, England
    Home Country
    United Kingdom United Kingdom
    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?
     

    RobNorthcott

    MP Donator
  • Premium Supporter
  • October 9, 2007
    540
    102
    Dartmoor, England
    Home Country
    United Kingdom United Kingdom
    @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:

    Users who are viewing this thread

    Top Bottom