"unknow error occurred" when trying to watch tv (1 Viewer)

[erik070]

MediaPortal Version: 1.2.0 beta
MediaPortal Skin: StreamedMP
Windows Version: Windows XP SP3
CPU Type: AMD Athlon II X2 245e
HDD: OCZ Vertex 2 60GB
Memory: 2GB DDR3 PC3-12800
Motherboard: Gigabyte GA-MA785GMT-UD2H
Video Card:
Video Card Driver: 10.7
Sound Card: Onboard
Sound Card AC3: Optical
Sound Card Driver: -
1. TV Card: Digital Everywhere - FireDTV
1. TV Card Type: DVB-C
1. TV Card Driver:
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: SAF 5 beta
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case: Silverstone LC-17
Cooling:
Power Supply:
Remote: Harmony ONE
TV: Samsung LE40A656
TV - HTPC Connection: DVI>HMDI

When I try to watch tv I get an "unknow error occurred" message. Same happens when I try to preview a channel in tvservice config.

Only things I tried but didn't work are a restart of the pc (the error happened to me before, usually this does the trick) after that system restore to a couple of days ago (when tv still worked).

Logs below

 

[quake2rambo]

AW: "unknow error occurred" when trying to watch tv

Did you take the recommended legacy driver for your firewire connection?

 

[mm1352000]

Please post TV Server logs...

 

[erik070]

sorry about the wrong logs. Here are the tvserver logs.

Also, in the topic start my specs weren't completely up to date. I use Win XP SP3 instead of Win7.

 

[quake2rambo]

AW: "unknow error occurred" when trying to watch tv

Oops. My fault ...

From your Log (error.log): MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired
It may be the problem.

 

[mm1352000]

Hi again

First thing: it looks like your database is corrupted:

2011-05-22 11:11:26.609375 [(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.
bij Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
bij Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
bij Gentle.Common.Check.Fail(Error error, Object[] args)
bij Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
bij Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
bij Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
bij Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
bij Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
bij TvDatabase.Channel.UpdateNowAndNext()
bij TvDatabase.Channel.get_CurrentProgram()
bij TvService.TvCardContext.OnZap(IUser user)
bij TvService.TimeShifter.Start(IUser& user, String& fileName)

To fix that, open up a command prompt, navigate to the MySQL Bin folder (C:\Program Files\MySQL\MySQL Server 5.1\bin for me) and run the command:

mysqlcheck --user=root --pass=MediaPortal --auto-repair MPTVDB

There are also errors from your TV card driver:

2011-05-22 11:05:49.816019 [(7)]: dvb:  RunGraph returns: 0x800705AA

2011-05-22 15:05:58.109375 [(16)]: dvb:  RunGraph returns: 0x8007001F

The first error code means that the system is out of resources, and the second one means something like "can't perform operation". Those are both driver problems - probably some kind of memory leak. There is nothing that you can do to resolve it except to restart the computer. Digital Devices would need to fix the driver...

 

[erik070]

Thanks for the detailed and quick respond.

When I try to repair the database mysql gave an error: mysqlcheck: Got error: 1049 Unknow databse 'mptvb' when selecting the database
Tried it several times, just to be sure there where no typo's.

after screwing around a little bit, decided to save most of my settings, thumbs and database (mytvseries etc.) and reinstalled the whole lot. It all seems to work again.

Thanks for the help

 

[Jay_UK]

Hi there,

The DB name is MpTvDB (you are missing the D)

J.