[mythtv-users] no scheduled jobs appear in front end

[Brock Palen]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mar 16, 2007, at 11:58 AM, Matt Rude wrote:

> Brock Palen wrote:
>>
>> Ok this is strange,  I'm running myth-0.20 on fedora core 6.  When i
>> schedule a recording from the front end, it never appears in the
>> 'upcoming recordings'  And if i go back to the program in the guide
>> it does not say its going to record (and never does)  The program to
>> record does show up in myth web,  and i see entries in the 'record'
>> table in the database.  Has anyone else seen this?  I What could
>> cause such problem to happen it was working fine until i updated all
>> the DST stuff but both the system and mysql have the right date and
>> time.
>>
>
> Try running optimize_mythdb.pl
>
> -Matt
>
Didn't help,  I notice that even though jobs i schedule show up in  
mythweb, (but not myth front end) that the up coming recordings list  
in mythweb has nothing listed.  For example nothing happend between  
the following two quires:

mysql> select title,starttime,startdate,now() from record;
+-----------------+-----------+------------+---------------------+
| title           | starttime | startdate  | now()               |
+-----------------+-----------+------------+---------------------+
| Montel Williams | 12:00:00  | 2007-03-16 | 2007-03-16 11:57:51 |
+-----------------+-----------+------------+---------------------+
1 row in set (0.00 sec)

mysql> select title,starttime,startdate,now() from record;
+-----------------+-----------+------------+---------------------+
| title           | starttime | startdate  | now()               |
+-----------------+-----------+------------+---------------------+
| Montel Williams | 12:00:00  | 2007-03-16 | 2007-03-16 12:00:39 |
+-----------------+-----------+------------+---------------------+
1 row in set (0.00 sec)

The myth status shows the back end as idle.  Thanks for the script  
though,  handy im sure for when MyISAM tables to on the fritz.

>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (Darwin)

iD8DBQFF+sAQTE2vN0HAO8kRAizOAKCTrNLp4AgCrAEBLxXGDf7kqGIW5ACfRrGK
nZwQEGPw1vUDD0AjIZxW8Lo=
=YezC
-----END PGP SIGNATURE-----