[mythtv-users] no scheduling data in UI following db restore

Michael T. Dean mtdean at thirdcontact.com
Tue Mar 29 02:28:19 UTC 2011

On 03/28/2011 06:53 PM, Richard Morton wrote:
> more complete log from mythbackend with the scheduling results...
> 2011-03-28 23:47:13.605 Error preparing query: UPDATE oldrecorded SET
> recstatus = :RSABORTED   WHERE recstatus = :RSRECORDING
> 2011-03-28 23:47:13.606 Driver error was [2/144]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Table './mythconverg/oldrecorded' is marked as crashed and last
> (automatic?) repair failed

mysqlcheck -r , see mysql documentation for details

You will likely lose some information (recorded history) in the repair, 
so may end up with re-recorded shows you have to delete (or Never Record 
before the record).


More information about the mythtv-users mailing list