[mythtv-users] Help: Upcoming recordings list suddenly blank!

[Bruce Markey]

matt wrote:
...
> I've been having database table "crashes" lately, mostly in the
> 'program' table, but I just repaired the 'recordedseek' table today.

$ killall mythbackend
$ killall mythfrontend
$ mysqlcheck -c -u mythtv -pmythtv mythconverg
$ mysql -u mythtv -pmythtv mythconverg
mysql> truncate table program;
mysql> truncate table programrating;
mysql> truncate table programgenre;
mysql> truncate table credits;
mysql> quit
$ mythfilldatabase
$ mysqlcheck -c -u mythtv -pmythtv mythconverg
$ mysqlcheck -o -u mythtv -pmythtv mythconverg
$ mythbackend -v schedule

--  bjm