[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