[mythtv-users] bug when scheduling recordings

[Ralf Haller]

I forgot to mention that I'm using version 0.9.1.

Ralf

Ralf Haller wrote:

> Hi,
>
> I just found a bug when scheduling two recordings on the same channel, 
> at the same time but on a different day. The first recording is 
> replaced by the second.
>
> Just take a look at the database after scheduling the first recording:
>
> mysql> select chanid, starttime, startdate, endtime, enddate, title 
> from record;
> +--------+-----------+------------+----------+------------+--------------------+ 
>
> | chanid | starttime | startdate  | endtime  | enddate    | 
> title              |
> +--------+-----------+------------+----------+------------+--------------------+ 
>
> |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | Indy 
> Racing League |
> |      7 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | 
> Frasier            |
> |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | 
> Cart               |
> |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | 
> Nascar             |
> |     24 | 22:00:00  | 0000-00-00 | 22:30:00 | 0000-00-00 | South 
> Park         |
> |     21 | 12:30:00  | 2003-06-14 | 12:45:00 | 2003-06-14 | 
> Automobil          |
> |     21 | 15:15:00  | 2003-06-14 | 17:00:00 | 2003-06-14 | 
> Automobil          |
> |     21 | 20:15:00  | 2003-06-14 | 21:00:00 | 2003-06-14 | 
> Automobil          |
> |      7 | 20:15:00  | 0000-00-00 | 21:15:00 | 0000-00-00 | 
> Enterprise         |
> |     16 | 19:45:00  | 0000-00-00 | 20:15:00 | 0000-00-00 | Dick und 
> Doof      |
> |     21 | 09:00:00  | 2003-06-14 | 10:00:00 | 2003-06-14 | 
> Automobil          |
> |     21 | 08:30:00  | 2003-06-15 | 10:00:00 | 2003-06-15 | 
> Automobil          |
> +--------+-----------+------------+----------+------------+--------------------+ 
>
> 12 rows in set (0.00 sec)
>
> Here is the database after scheduling the second recording, mind the 
> 7th record:
>
> mysql> select chanid, starttime, startdate, endtime, enddate, title 
> from record;
> +--------+-----------+------------+----------+------------+--------------------+ 
>
> | chanid | starttime | startdate  | endtime  | enddate    | 
> title              |
> +--------+-----------+------------+----------+------------+--------------------+ 
>
> |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | Indy 
> Racing League |
> |      7 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | 
> Frasier            |
> |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | 
> Cart               |
> |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 0000-00-00 | 
> Nascar             |
> |     24 | 22:00:00  | 0000-00-00 | 22:30:00 | 0000-00-00 | South 
> Park         |
> |     21 | 12:30:00  | 2003-06-14 | 12:45:00 | 2003-06-14 | 
> Automobil          |
> |     21 | 15:15:00  | 2003-06-15 | 16:30:00 | 2003-06-15 | 
> Automobil          |
> |     21 | 20:15:00  | 2003-06-14 | 21:00:00 | 2003-06-14 | 
> Automobil          |
> |      7 | 20:15:00  | 0000-00-00 | 21:15:00 | 0000-00-00 | 
> Enterprise         |
> |     16 | 19:45:00  | 0000-00-00 | 20:15:00 | 0000-00-00 | Dick und 
> Doof      |
> |     21 | 09:00:00  | 2003-06-14 | 10:00:00 | 2003-06-14 | 
> Automobil          |
> |     21 | 08:30:00  | 2003-06-15 | 10:00:00 | 2003-06-15 | 
> Automobil          |
> +--------+-----------+------------+----------+------------+--------------------+ 
>
> 12 rows in set (0.00 sec)
>
> This looks like a faulty query to me (update instead of insert?). I 
> don't have time right now to fix it, maybe someone else can take a look?
>
> Thanks,
>
> Ralf
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>