[mythtv-users] bug when scheduling recordings

Ralf Haller ralf at brap.de
Fri Jun 13 12:24:02 EDT 2003


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



More information about the mythtv-users mailing list