[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