[mythtv-users] bug when scheduling recordings
Ralf Haller
ralf at brap.de
Fri Jun 13 12:51:54 EDT 2003
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
>
More information about the mythtv-users
mailing list