Reply to thread

Message

<blockquote data-quote="AMD" data-source="post: 894134" data-attributes="member: 117091">Hi,&nbsp;I was having this problem and really couldn't figure out what was going on. I prepared a log to post here and see if anyone could help me. Before posting I opened up the error.log file and finally figured out what was going on. I am posting here to help anyone getting the same kind of problem in the future.&nbsp;When I was trying to choose a TV show in the schedule to record it (go in the schedule, right click on the TV show, select Record) the next screen that shows the list of upcoming episodes and in which I normally select Advanced Record and choose the option needed was not displaying the episodes.&nbsp;This is what I found in the log file :2012-08-25 08:47:05.864795 [ERROR][MPMain(1)]: TVProgramInfo: Error in Update() - Error: StatementErrorUnclassifiedGentle.Common.GentleException: select idCanceledSchedule, idSchedule, idChannel, cancelDateTime from CanceledSchedule where idSchedule = ?idSchedule; ---&gt; MySql.Data.MySqlClient.MySqlException: Table 'canceledschedule' is marked as crashed and should be repaired&nbsp;This is where being a computer engineer and Google helped.&nbsp;To solve the problem, open up a MySQL client (I use Toad for MySQL).Go into the Team MediaPortal database schema.Use the REPAIR TABLE statement. Here it would be : REPAIR TABLE CanceledScheduleThe statement will return a Status OK on the last row.When it is done, commit the change.&nbsp;Now all is working well. So really this is a MySQL problem. The computer must have crashed and the database got corrupted.</blockquote>

[QUOTE="AMD, post: 894134, member: 117091"] Hi, I was having this problem and really couldn't figure out what was going on. I prepared a log to post here and see if anyone could help me. Before posting I opened up the error.log file and finally figured out what was going on. I am posting here to help anyone getting the same kind of problem in the future. When I was trying to choose a TV show in the schedule to record it (go in the schedule, right click on the TV show, select Record) the next screen that shows the list of upcoming episodes and in which I normally select Advanced Record and choose the option needed was not displaying the episodes. This is what I found in the log file : 2012-08-25 08:47:05.864795 [ERROR][MPMain(1)]: TVProgramInfo: Error in Update() - Error: StatementErrorUnclassified Gentle.Common.GentleException: select idCanceledSchedule, idSchedule, idChannel, cancelDateTime from CanceledSchedule where idSchedule = ?idSchedule; ---> MySql.Data.MySqlClient.MySqlException: Table 'canceledschedule' is marked as crashed and should be repaired This is where being a computer engineer and Google helped. To solve the problem, open up a MySQL client (I use Toad for MySQL). Go into the Team MediaPortal database schema. Use the REPAIR TABLE statement. Here it would be : REPAIR TABLE CanceledSchedule The statement will return a Status OK on the last row. When it is done, commit the change. Now all is working well. So really this is a MySQL problem. The computer must have crashed and the database got corrupted. [/QUOTE]

Verification