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

Tim Sherrill

New Member
May 1, 2013
4
1
50
Home Country
United States of America United States of America
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
 

Tim Sherrill

New Member
May 1, 2013
4
1
50
Home Country
United States of America United States of America
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
 

mm1352000

Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    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".
     

    Users who are viewing this thread

    Top Bottom