[mythtv-users] errors with mythconverg, mythweb and scheduling recordings

[Chris Petersen]

Gabe Rubin wrote:
> When I try to go into mythweb and look at my upcoming recordings, it
> says there are none.  Worse, when I try to search for a show or
> listings, I get a major mysql error.  There is plenty of space on my
> partitions, and I can watch my recorded shows (so the db is somewhat
> working).  Any ideas?
> 
> Here is what is displayed in mythweb:
> 
> Fatal Error at /var/www/html/mythweb/includes/db.php, line 360:
> SQL Error: Can't open file: 'program.MYI' (errno: 145) [#1016]
> 
> If you choose to submit a bug report, please make sure to include a
> brief description of what you were doing, along with the following
> backtrace as an attachment (please don't paste the whole thing into
> the ticket).


A quick google on that error message should tell you that the index file
(*.MYI) for the program table is corrupt and needs to be repaired.
You're also likely to find something to tell you to grab and run
optimize_mythdb.pl from the contrib directory to fix the problem.

-Chris

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 251 bytes
Desc: OpenPGP digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060908/5f80b31b/attachment.pgp