Hardware Defect? TT-Budget S2-3200 (1 Viewer)

jojo1411

Portal Pro
January 23, 2008
182
37
Home Country
Germany Germany
Hi Together,
since yesterday I'm in big trouble with one of my HTPC Configuration.

3 days ago, we had a power blackout. My HTPC was in Standby and after the blackout he was fully shut down. After booting it, TV Server gave came up with some error messages. After a reinstall of the TV-Server and uninstalling the Beta TV Card drivers and installing the stable ones, everything worked fine. Until today.
After watching 2 days tv without any problems, the tv Server stopped completely working. Restarting TV Server, Reinstalling TV Server, Reinstalling TV Card Driver had no effect. TV-Server comes up everytime with a "unknown error" message. Searching after the log-entry, didn't match any forum results.
What's your suggestion? Has the tv card been broken through the power blackout?

A short description of my situation: The HTPC's activity is 80% TV and 20% Music&Videos. My parents are using a HTPC setup since over 2 years. They hope to get a really stable TV Server, the HTPC wasn't stable all the time. Often you had to restart the TVService or even reinstall the TVServer.
I'm using a Cinergy S2 which is slightly more stable. So my question is, is there a hardware setup which you would say runs very stable. Would you recommend to buy a new/other TV Card or would you switch over to HDTV Stand-alone Receiver for TV watching and using the HTPC only for Videos and Music?

Logs are attached:

Thank you

MediaPortal Version: MediaPortal 1.2.0 Beta
MediaPortal Skin: Streamed MP
Windows Version: Windows 7
CPU Type: AMD Phenom X4 955 3,2Ghz
HDD:
Memory: 4GB DDR2
Motherboard:
Video Card: Sapphire RADEON HD 4670
Video Card Driver: Catalyst 11.4
1. TV Card: TT-Budget S2-3200
1. TV Card Type: DVB-S
1. TV Card Driver: 5.0.1.8
Satelite/CableTV Provider: Astra 19,2°E
HTPC Case:
Cooling:
Power Supply:
Remote: Logitech Harmony 895
TV: Sony Bravia KDL-40W4500
TV - HTPC Connection: HDMI
 

kszabo

MP Donator
  • Premium Supporter
  • December 6, 2007
    796
    86
    Germany, Bayern
    Home Country
    Hungary Hungary
    Hi

    this won´t help you but I had already 1 Technotrend S2-3200 failure (no power out on the antenna cable) and 2 Technisat HD2 failures (simlpy no signal error 2 times).... it is very possible.
     

    mm1352000

    Retired Team Member
  • Premium Supporter
  • September 1, 2008
    21,577
    8,224
    Home Country
    New Zealand New Zealand
    Hi

    This is not a hardware problem - I'm 95% certain it is a DB problem. This comes from your logs:

    [COLLAPSE]2011-05-31 21:42:49.595262 [TVService(6)]: 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()[/COLLAPSE]

    To fix it, open a command line and enter the following commands:

    CD C:\Program Files\MySQL\MySQL Server 5.1\bin
    mysqlcheck mptvdb --auto-repair -e -u root -p

    The default password is "MediaPortal" - case sensitive

    :)
     

    jojo1411

    Portal Pro
    January 23, 2008
    182
    37
    Home Country
    Germany Germany
    AW: Re: Hardware Defect? TT-Budget S2-3200

    Hi

    This is not a hardware problem - I'm 95% certain it is a DB problem. This comes from your logs:

    [COLLAPSE]2011-05-31 21:42:49.595262 [TVService(6)]: 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()[/COLLAPSE]

    To fix it, open a command line and enter the following commands:

    CD C:\Program Files\MySQL\MySQL Server 5.1\bin
    mysqlcheck mptvdb --auto-repair -e -u root -p

    The default password is "MediaPortal" - case sensitive

    :)

    Thank you very much, TV works again. I don't understand how the db has get damaged, but now it doesn't matter.

    :D:D:D:D
     

    Users who are viewing this thread

    Top Bottom