My-TV has stopped working (1 Viewer)

[Dansta]

MediaPortal Version: 0.2.3
MediaPortal Skin: X-Face
Windows Version: XP Pro SP2
CPU Type: Intel Pentium 4 640 3.0GHz
HDD: 1x Maxtor Diamond Max Plus 160GB and 1X Hitachi Deskstar 80GB
Memory: 1GB
Motherboard: Foxconn 945G7MD-8EKRS2H
Motherboard Chipset: Intel 945 +ICH7R
Video Card: MSI 7300LE
1. TV Card: Terratec Cinergy 2400i DT
1. TV Card Type: Dual DVB-T
TV - HTPC Connection: DVI-D

Hi. Stange problem today I've never encountered before. Came to use My-TV (standard, don't use TV Server) and it came up with something like "No Tuner can receive: BBC1" or any other channel for that matter. PC was left hibernated overnight. I resumed and was presented with this problem.

After a reboot, I removed and rescanned the channels, no change. Removed the tuners and rescanned, no change. Then I've uninstalled and reinstalled MP still to no avail. I downloaded the naff Terratec TV software and this shows TV channels OK (thus ruling out driver, hardware or signal) but still nowt from MP.

I've run the debugger and attached the logs as I am stumped. Any help or advice anyone can offer, would be much appreciated.
Cheers, Dan

 

[ronilse]

Hi,
seems like your TVdatabase has been corrupted, try renaming TVDatabaseV21.db3 in database folder & run MP Configuration again to scan setup channels.

Regards
Roy

 

[Dansta]

That worked, cheers!

As I'm still trying to work out what much of the log content tells me, what pointed you to the database being corrupted?

Thanks, Daniel

 

[ronilse]

Hi,
In MediaPortal.log(it's also in error.log) this was the clue:

2008-02-05 09:20:59.765625 [Info.][6]: TVDatabase exception err:SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT 
detailed:database disk image is malformed query:select * from channel,tblPrograms,genre where 
genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'BBC THREE'
 and ( (tblPrograms.iEndTime>='20080203092000' and tblPrograms.iEndTime <='20080207092000')
 or (tblPrograms.iStartTime>='20080203092000' and tblPrograms.iStartTime <= '20080207092000' )
 or (tblPrograms.iStartTime<='20080203092000' and tblPrograms.iEndTime >= '20080207092000') )
order by iStartTime stack:   at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
   at SQLite.NET.SQLiteClient.Execute(String query)

Regards
Roy

 

[Dansta]

Cheers. Pretty obvious now you pointed it out !

Thanks again.

 

[ronilse]

Hi,
Yeah, when you know what to look for, thats why we always ask(nags) for logs. They tell almost everything we need to know

Regards
Roy