MP TV Service broken - "/TvControl" (1 Viewer)

[Blue Lightning]

Problem: TV Service broken. No stopping, no starting.
Solution: See below for fixing the database. It fixed my TV Service.

 

[Wbunaarf]

Hi,

I don't know if this is the only problem, but your SQL database seems to be corrupt:

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)

To quote mm1352000:

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

//W

 

[RobNorthcott]

In case you didn't know, you'll have to stop the TVServer service first, otherwise that auto-repair will fail on some files.
You need to run these commands (can be set up as a batch file for next time it happens)

net stop tvservice
c:
cd \program files\mysql\mysql server 5.1\bin
mysqlcheck mptvdb --auto-repair -e -u root --password=MediaPortal
net start tvservice

Rob