[mythtv-users] Cannot schedule recordings

[R. Kannan]

That was it. Thanks

-----Original Message-----
>From: Nick Morrott <knowledgejunkie at gmail.com>
>Sent: Sep 15, 2008 5:58 PM
>To: Discussion about mythtv <mythtv-users at mythtv.org>
>Subject: Re: [mythtv-users] Cannot schedule recordings
>
>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
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


________________________________________
PeoplePC Online
A better way to Internet
http://www.peoplepc.com