[mythtv-users] SQL Error: Can't open file: 'programrating.MYI'. (errno: 145)

[Adrian Phillips]

>>>>> "Malcolm" == Malcolm  <mythtv at lds.dyndns.org> writes:

    Malcolm> Fatal Error at
    Malcolm> /var/www/html/mythtv/includes/programs.php, line 189: SQL
    Malcolm> Error: Can't open file: 'programrating.MYI'. (errno: 145)
    Malcolm> The system administrator has been notified and the
    Malcolm> problem will be remedied shortly.

    Malcolm> So I tried this: mysql -u mythtv -p mythconverge
    mysql> select * from programrating;
    Malcolm> ERROR 1016: Can't open file: 'programrating.MYI'. (errno:
    Malcolm> 145)

For future reference, try :-

$ perror 145
Error code 145:  Unknown error 145
145 = Table was marked as crashed and should be repaired

Sincerely,

Adrian Phillips

-- 
Who really wrote the works of William Shakespeare ?
http://www.pbs.org/wgbh/pages/frontline/shakespeare/