[mythtv-users] A few odd bugs with cutlists

Isaac Richards ijr at po.cwru.edu
Sun Aug 10 20:08:36 EDT 2003


On Sunday 10 August 2003 05:36 pm, Ian Westcott wrote:
> On Sun, Aug 10, 2003 at 02:03:51PM -0700, Ian Westcott wrote:
> > Upon restarting, I couldn't edit the cutlist anymore either. After poking
> > around through the database, I noticed the editing field in that
> > program's recorded entry was set to 1 (makes since, since I killed
> > mythfrontend). Upon setting it back to 0, I could edit the cutlist again,
> > although all the cuts I had previously made were gone.
>
> And one last bug I just noticed.. on one of these programs that had this
> problem, the "starttime" in the database mysteriously changed to today:
>
> mysql> select title,chanid,starttime,endtime,editing,cutlist from
> recorded where title='batman';
> +--------+--------+----------------+----------------+---------+-----------+
>
> | title  | chanid | starttime      | endtime        | editing | cutlist
>
> +--------+--------+----------------+----------------+---------+-----------+
>
> | Batman |   1042 | 20030810141420 | 20030705190000 |       0 | 0 - 6150
>
> +--------+--------+----------------+----------------+---------+-----------+
> 1 row in set (0.00 sec)
>
> Now I couldn't have done this myself while looking through the DB,
> 20030810141420 is a pretty specific value to have put in, and I didn't do
> it myself. 

Actually, you did do it yourself.  starttime is a timestamp, and must be 
updated (just set to the same value) along with what you're changing when you 
change other data in that record.

Isaac


More information about the mythtv-users mailing list