[mythtv-users] Cannot schedule recordings

Nick Morrott knowledgejunkie at gmail.com
Mon Sep 15 21:58:20 UTC 2008


On 15/09/2008, R. Kannan <rkannan at peoplepc.com> wrote:
> I had the following lines in the log file when I restarted the backend:
>
>  Query was:
>  INSERT sched_temp_recorded SELECT * from recorded;
>  Driver error was [2/1194]:
>  QMYSQL3: Unable to execute query
>  Database error was:
>  Table 'recorded' is marked as crashed and should be repaired

Read http://mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance#Optimize_the_Database
now, run the optimize_mythdb.pl script to repair your MythTV database,
and add it to a regular cron job to keep the database in healthy
condition.

That should solve this problem.

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin


More information about the mythtv-users mailing list