Unknown Error Occured when attempting to view TV (1 Viewer)

[paul.aplin]

I receive a dialog box telling me that an unknown error occurred when I try to view any TV channel.

2010-09-04 22:11:41.093750 [(16)]: Exception :Error: DeveloperErrorUnclassified

This occurs both in MediaPortal and when attempting to use manual control of the card in TV Server.

Previously I have had some serious issues with the database and believe this may be related to the DB connection however I have done a clean install of both MP and MySQL between then and now. Any tips on how to confirm the database is fine would be appreciated also.

I have included logs from both today (04_09_10) and from 1.0.2 where the database had corrupted in case they may also help.

MediaPortal Version: 1.1.0 Final
MediaPortal Skin: Bluewide3
Windows Version: Win XP SP3
CPU Type: Intel P4 3.0G
HDD: 1140mb (3 WD Drives)
Memory: 1GB
Motherboard: Gigabyte
Video Card: GeForce 7300SE
Video Card Driver: 6.14.11.8208
Sound Card: Realtek HD
Sound Card AC3: Optical Out
Sound Card Driver: 5.10.0.5643
1. TV Card: Hauppauge MCE Nova-T-500
1. TV Card Type: Dual DVB-T
1. TV Card Driver: 4.3.27240.0
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: FFDShow
MPEG2 Audio Codec: FFDShow
h.264 Video Codec: FFDShow
Satelite/CableTV Provider:
HTPC Case: Silverstone LC19
Cooling: 2x80mm Fans
Power Supply: Silverstone 350w
Remote: Microsoft MCE
TV: Samsung 42inch Wide
TV - HTPC Connection: HDMI

 

[chemelli]

2010-09-04 23:08:08.343750 [(16)]: Exception :Error: DeveloperErrorUnclassified
Gentle.Common.GentleException: The columns idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating in table Program do not exist.

Seems your DB is corrupted. Please drop it and retry.
Let us know if all is sorted.

Simone

 

[paul.aplin]

Thanks.

I have done so, and uninstalled mysql shortly after posting the logs.

I installed MS SQL in its place, and seem to have a much better, more stable system. On average I only need to reboot about every 3-4 days where previously it was every 24hrs.

A Previous install also had a database error that corrupted the database. I am not good with databases so it may be just me.

Thanks heaps for your help.

 

[Zorba]

How do you dump your database?