Reply to thread

Message

<blockquote data-quote="Wbunaarf" data-source="post: 845088" data-attributes="member: 17027">Hi,&nbsp;I don't know if this is the only problem, but your SQL database seems to be corrupt:&nbsp;[CODE]2012-02-19 17:28:01.311652 [scheduler thread(10)]: scheduler: SchedulerWorker inner exception Error: StatementErrorUnclassifiedGentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program where title = ?title and startTime &lt;= ?startTime and endTime &gt; ?endTime; ---&gt; MySql.Data.MySqlClient.MySqlException: Table 'program' is marked as crashed and should be repaired&nbsp; at MySql.Data.MySqlClient.MySqlStream.OpenPacket()&nbsp; at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 pageSize, Int32 columns)&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.NextResult()&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)&nbsp; at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)&nbsp; --- End of inner exception stack trace ---&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)&nbsp; at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)&nbsp; at Gentle.Framework.SqlStatement.Execute()&nbsp; at TvDatabase.Program.RetrieveCurrentRunningByTitle(String title, Int32 preRec, Int32 postRec)&nbsp; at TvService.Scheduler.IsTimeToRecordEveryTimeOnEveryChannel(Schedule schedule)&nbsp; at TvService.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail&amp; newRecording)&nbsp; at TvService.Scheduler.StartAnyDueRecordings()&nbsp; at TvService.Scheduler.DoScheduleWork()&nbsp; at TvService.Scheduler.SchedulerWorker()MySql.Data.MySqlClient.MySqlException: Table 'program' is marked as crashed and should be repaired&nbsp; at MySql.Data.MySqlClient.MySqlStream.OpenPacket()&nbsp; at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 pageSize, Int32 columns)&nbsp; at MySql.Data.MySqlClient.MySqlDataReader.NextResult()&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)&nbsp; at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)&nbsp; at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()&nbsp; at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)[/CODE]&nbsp;&nbsp;To quote <a href="http://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: Code: mysqlcheck --user=root --pass=MediaPortal --auto-repair MPTVDB" target="_blank">mm1352000</a>:&nbsp;&nbsp;&nbsp;//W</blockquote>

[QUOTE="Wbunaarf, post: 845088, member: 17027"] Hi, I don't know if this is the only problem, but your SQL database seems to be corrupt: [CODE]2012-02-19 17:28:01.311652 [scheduler thread(10)]: scheduler: SchedulerWorker inner exception Error: StatementErrorUnclassified Gentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program where title = ?title and startTime <= ?startTime and endTime > ?endTime; ---> MySql.Data.MySqlClient.MySqlException: Table 'program' is marked as crashed and should be repaired at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 pageSize, Int32 columns) 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.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction) at Gentle.Framework.SqlStatement.Execute() at TvDatabase.Program.RetrieveCurrentRunningByTitle(String title, Int32 preRec, Int32 postRec) at TvService.Scheduler.IsTimeToRecordEveryTimeOnEveryChannel(Schedule schedule) at TvService.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail& newRecording) at TvService.Scheduler.StartAnyDueRecordings() at TvService.Scheduler.DoScheduleWork() at TvService.Scheduler.SchedulerWorker()MySql.Data.MySqlClient.MySqlException: Table 'program' is marked as crashed and should be repaired at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 pageSize, Int32 columns) 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)[/CODE] To quote [URL='http://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: Code: mysqlcheck --user=root --pass=MediaPortal --auto-repair MPTVDB']mm1352000[/URL]: //W [/QUOTE]

Verification