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

[Tim Sherrill]

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

 

[mm1352000]

Hello Tim

http://wiki.team-mediaportal.com/1_...Troubleshooting/TV/Repairing_database_(MySQL)

mm

 

[Tim Sherrill]

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]

You probably need to restart the TV service now. In the manual control section of TV Server configuration, click "start service"... then "stop service".