MP TV - Server? does not work. Maybe SQL Problem (1 Viewer)

[H3llron]

Hi!

I have a huge problem with MP. I cant watch TV. Every other thing works. I get an error message with: "no known error occured" (in germa... Ein unbekannter Fehler ist aufgetreten). I also dont see any program Info. I think it occured since I last updated my extension - it did not work well.
I removed all extension but it does not work either. In my errore report i found this:

2011-05-29 18:43:13.038933 [HeartBeatMonitor(13)]: Controller: Heartbeat Monitor initiated, max timeout allowed is 30 sec.
2011-05-29 18:43:13.038933 [TVService(5)]: Controller: recalculating program states
2011-05-29 18:43:13.038933 [TVService(5)]: TvControllerException: Error: StatementErrorUnclassified
Gentle.Common.GentleException: Update Program set state=0 where state<>0; ---> MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired
bei MySql.Data.MySqlClient.MySqlStream.OpenPacket()
bei MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
bei MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
bei MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
--- Ende der internen Ausnahmestapelüberwachung ---
bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
bei Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
bei Gentle.Framework.SqlStatement.Execute()
bei TvDatabase.Program.ResetAllStates()
bei TvService.TVController.InitController()MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired
bei MySql.Data.MySqlClient.MySqlStream.OpenPacket()
bei MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
bei MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()
bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
bei MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
bei Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
bei Gentle.Framework.SqlStatement.Execute()
bei TvDatabase.Program.ResetAllStates()
bei TvService.TVController.InitController()

May this be the error? Please Help!!!

Ingo

P.S. the TV Card works fine with DVBViewer...

MediaPortal Version: 1.1.2
MediaPortal Skin: StreamedMP
Windows Version: Windows 7 64bit
CPU Type: AMD
HDD: 2x WD Caviar Green 2TB
Memory: 4GB G.Skill
Motherboard: Asus M4A78-HTPC
Video Card: ATI Radeon HD3200 On Board
Video Card Driver: Catalyst
Sound Card: On Board RS780 ATI/AMD
Sound Card AC3: optical out
Sound Card Driver:
1. TV Card: TT BudgetS2-3200
1. TV Card Type: DVB-S2
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: Cyber Link PDVD10
MPEG2 Audio Codec: FFDSHOW AUDIO DECODER
h.264 Video Codec: Cyber Link PDVD10
Satelite/CableTV Provider: Astra 19.2 R
HTPC Case: Antex Fusion Remote
Cooling: Zalmann and others
Power Supply: Be.Quiet 350Watt
Remote: Antec
TV: Toshiba Regza
TV - HTPC Connection: HDMI

 

[Vasilich]

MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired

repair your database and try again. You can do it with SQL Administrator or with commandline tools installed together with MySQL Server

 

[H3llron]

AW: Re: MP TV - Server? does not work. Maybe SQL Problem

MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired

repair your database and try again. You can do it with SQL Administrator or with commandline tools installed together with MySQL Server

Can you please explain how? I have no idea or knowledge about SQL and Tools...

 

[Vasilich]

here is the instruction
https://forum.team-mediaportal.com/...curred-when-trying-watch-tv-96883/#post749133

and next time use MediaPortal Forum - Search Forums

 

[H3llron]

AW: MP TV - Server? does not work. Maybe SQL Problem

... Repairing Tables
mptvdb.programm
Error: Incorrect file format "progam"
Error: Corrupt

Does not work until now. May I have to stop service or something?

 

[jameson_uk]

Open up a command prompt (as admin if Vista / Win7)
navigate to MySQL Bin folder (is C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin for me) and enter

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

does this fix the table?

 

[H3llron]

AW: MP TV - Server? does not work. Maybe SQL Problem

Got it - thanks a lot!