Unknown Error When Starting TV (1 Viewer)

kj87

Portal Member
June 1, 2010
9
0
MediaPortal Version: 1.1.0 RC4
MediaPortal Skin: Blue3wide
Windows Version: XP SP3
CPU Type: Athlon X2 Dual 2.21GHz
HDD: seagate 250GB
Memory: DDR400 2GB
Motherboard: MSI RD480 Neo2
Video Card: Nvidia Geforce 6800XT
Video Card Driver:
Sound Card: integrated
Sound Card AC3:
Sound Card Driver:
1. TV Card: Winfast DTV 1000
1. TV Card Type: DVB-T?
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:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote: Coolcommand Y040004
TV:
TV - HTPC Connection:


Hi there,

I hope you can help, my version of mediaportal has recently started producing an unknown error whenever I attempt to start the TV function. It has been working perfectly under the previous RC, however all of a sudden it stopped. To the best of my knowledge I didnt change anything to cause this, however something must have happened. I updated to the latest RC in an attempt to fix this, however I have had no luck with this either. The problem is simply that when clicking on a tv channel to start it, a prompt pops up saying that an unknown error occurred. I have attempted to rectify this by re-scanning for channels (which completes successfully) however it has no effect on the problem. Any help would be much appreciated.

Thanks,

Karl
 

te3hpurp

Retired Team Member
  • Premium Supporter
  • September 23, 2008
    910
    231
    Rovaniemi
    Home Country
    Finland Finland
    Hi.

    At least your database is corrupt and needs to be repaired:
    Code:
    2010-06-05 18:04:09.125000 [(14)]: Exception   :Error: StatementErrorUnclassified
    [B]Gentle.Common.GentleException: show columns from `program` ---> MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired[/B]
       at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
       at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
       at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
       at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
       --- End of inner exception stack trace ---
       at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
       at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
       at Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)
       at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
       at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
       at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
       at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
       at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
       at TvDatabase.Channel.UpdateNowAndNext()
       at TvDatabase.Channel.get_CurrentProgram()
       at TvService.TvCardContext.OnZap(User user)
       at TvService.TimeShifter.Start(User& user, String& fileName)MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired
       at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
       at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
       at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
       at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)

    When you have that sorted out and if error still exist well look more.

    Br,
     

    kj87

    Portal Member
    June 1, 2010
    9
    0
    This is probably a dumb question but how do I repair my corrupt database?

    Thanks
     

    kj87

    Portal Member
    June 1, 2010
    9
    0
    Ok, I think I have managed to repair my database, I opened up mysql command line, entered the default pass, connected to mptvdb and then typed in "repair table program". I then re-scanned for channels and opened up MP and went to the TV to test it, however still no joy.

    Attached are the new logs after this.
     

    te3hpurp

    Retired Team Member
  • Premium Supporter
  • September 23, 2008
    910
    231
    Rovaniemi
    Home Country
    Finland Finland
    Hi

    You still have lot of errors on Database. It now has missing tables/fileds in table.
    I think you need to re-create database completely.

    Uninstalling MePo Completely, or by dropping the Database with some MySql tool.
    TvSetup should re-create it when executed next time. I really am not sure about if it is re-created,
    Maybe some other team member can help on that ??

    Br,
     

    kj87

    Portal Member
    June 1, 2010
    9
    0
    Hi,

    Thanks for your help guys, i've now managed to solve this problem by uninstalling the TV server completely and then re-installing and setting up again including a channel scan. All works now. Thanks!

    :D
     

    tom78

    Portal Pro
    August 10, 2007
    149
    5
    Home Country
    Germany Germany
    AW: Unknown Error When Starting TV

    Afer 2 weeks w/o problems with RC4 i got the same error message today and it seems to be a damaged database, too.

    So i'd like to know how this could occur? Could any EPG-grabber be the problem?
    I use "tvxb" in combination with the built-in xmltv-plugin to grab the data from tvmovie.de.

    could i avoid this problem by using webepg?

    thanks

    Tom
     

    kj87

    Portal Member
    June 1, 2010
    9
    0
    I have no idea what caused the problem. My new problem is that after working for 1 day, now whenever I click on a channel MP freezes. Absolutely fine when playing movies or My TV Series, it only occurs when attempting to view tv. Hopefully someone can help. New logs attached
     

    Users who are viewing this thread

    Top Bottom