TV Recordings Database trashed (MP1.4 recordings list is empty)

Discussion in 'General Support' started by Tim Sherrill, August 27, 2013.

  1. Tim Sherrill

    Tim Sherrill New Member

    Joined:
    May 1, 2013
    Messages:
    4
    Likes Received:
    1
    Gender:
    Male
    Ratings:
    +1 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    I have an issue where no recordings are going into the database. Both client and server machines show no recordings.



    TV-Server Config, Recording Option, Database Import tab, when I click "Import Selected Files" I get an error:
    "Error retrieving recordings from database: The columns idRecording, ... in table Recording do not exist."

    I got this under MP 1.4.0. I upgraded to 1.5 to see if it would dump and recreate the table.

    I don't mind starting over except I've spent a lot of time getting my over-the-air channels configured and the EPG working right. If I can keep this info I'd be happy starting over with a clean DB.

    Thanks in advance for any help!


    Tim
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,527
    Likes Received:
    4,738
    Ratings:
    +8,205 / 17
    Home Country:
    New Zealand New Zealand
  4. Tim Sherrill

    Tim Sherrill New Member

    Joined:
    May 1, 2013
    Messages:
    4
    Likes Received:
    1
    Gender:
    Male
    Ratings:
    +1 / 0
    Home Country:
    United States of America United States of America
    Show System Specs
    That did find a problem in the recording table, but I still don't get any recordings listed.

    C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlcheck mptvdb --auto-repair -e -
    u root -p
    Enter password: ***********
    mptvdb.canceledschedule OK
    mptvdb.card OK
    mptvdb.cardgroup OK
    mptvdb.cardgroupmap OK
    mptvdb.channel OK
    mptvdb.channelgroup OK
    mptvdb.channellinkagemap OK
    mptvdb.channelmap OK
    mptvdb.conflict OK
    mptvdb.diseqcmotor OK
    mptvdb.favorite OK
    mptvdb.groupmap OK
    mptvdb.history
    warning : 1 client is using or hasn't closed the table properly
    status : OK
    mptvdb.keyword OK
    mptvdb.keywordmap OK
    mptvdb.pendingdeletion OK
    mptvdb.personaltvguidemap OK
    mptvdb.program OK
    mptvdb.radiochannelgroup OK
    mptvdb.radiogroupmap OK
    mptvdb.recording
    warning : Table is marked as crashed
    error : Size of indexfile is: 12288 Should be: 19456
    error : Size of datafile is: 12060 Should be: 12444
    error : Corrupt
    mptvdb.satellite OK
    mptvdb.schedule OK
    mptvdb.server OK
    mptvdb.setting OK
    mptvdb.softwareencoder OK
    mptvdb.timespan OK
    mptvdb.tuningdetail OK
    mptvdb.tvmoviemapping OK
    mptvdb.version OK

    Repairing tables
    mptvdb.recording OK
     
  5. mm1352000
    • Team MediaPortal

    mm1352000 Development Group

    Joined:
    September 1, 2008
    Messages:
    21,527
    Likes Received:
    4,738
    Ratings:
    +8,205 / 17
    Home Country:
    New Zealand New Zealand
    You probably need to restart the TV service now. In the manual control section of TV Server configuration, click "start service"... then "stop service".
     
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!