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

RobNorthcott

MP Donator
  • Premium Supporter
  • October 9, 2007
    517
    96
    Dartmoor, England
    United Kingdom United Kingdom
    Country flag
    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,839
    403
    South Central Wisconsin
    United States of America United States of America
    Country flag
    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
    517
    96
    Dartmoor, England
    United Kingdom United Kingdom
    Country flag
    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
    517
    96
    Dartmoor, England
    United Kingdom United Kingdom
    Country flag
    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
    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
    517
    96
    Dartmoor, England
    United Kingdom United Kingdom
    Country flag
    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

    Development Group
  • Team MediaPortal
  • August 7, 2007
    1,580
    1,236
    Finland Finland
    Country flag
    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
    517
    96
    Dartmoor, England
    United Kingdom United Kingdom
    Country flag
    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
    517
    96
    Dartmoor, England
    United Kingdom United Kingdom
    Country flag
    @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 (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    badboyxx TV card is listed as unknown in TV-server config General 4
    E TVserver RTSP Input / Output interfaces 0
    D [solved] TVServer Plugin must be missing something. General Development (no feature request here!) 1
    Dark Eyes Updated to Windows 10, now TVServer won't work Installation, configuration support 1
    G MP 1.21 TVserver race condition when cant delete recording triggered by episode management General Support 0
    T How do I install the Kodi TVServer plugin General 8
    C Manual Control doesn't work anymore inside TVServer General Support 4
    I TVServer issues Installation, configuration support 2
    T Things I wish I had known setting up and first using TVServer for good reception of DVB-T Installation, configuration support 0
    M MediaPortal2 TV Config Error on Install (0x80004005) General 7
    framug [Approved] Fix Irtrans config bug Submit: code patches (MediaPortal/TV-Server/etc.) 4
    T [solved] Green Button start MP not working....but box ticked in config. General Support 1
    D [solved] Changed username in Win10, now TV Server config crashes on fresh install Installation, configuration support 1
    A 1.24.0 MP config goes very small and unreadable if called from MP with F2 1.24-1.26 Pre Release 0
    A FB funktioniert plötzlich nicht mehr korrekt Allgemeines Supportforum 0
    mrbonsen Probleme bei "Preview" in der TV Config TV / Streaming 13
    M Can't run TV config because "target machine actively refused it" General 3
    G Sauvegarder et dupliquer les configs de mp1 et mp2 sur plusieurs pc Support Général 3
    F Config starting, but not showing. Moving Pictures 2
    azzuro [WiP] Providing most of 3rd part tools as nuget MediaPortal 1 13
    CyberSimian [Proposal] Tool to display time of next recording MediaPortal 1 0
    sve1 Invalid DateTime when loading configuration tool Trakt 5
    BlueMax1916 Tool: MPTVSeries and MovingPictures to MP2 General 0
    D [solved] HID remote for mp2 and w10 64 bit? using all tools: sony, cisco, homeworkx ng General 2
    raffe [solved] Export tool and import support from MP-TVSeries & Moving Pictures to MP2 General 22
    Similar threads

























    Top Bottom