[mythtv-users] bug when scheduling recordings

[Ralf Haller]

Hi Isaac,

I was able to reproduce the bug. I selected for single recording a 
program tonite at 8:00 pm and again tomorrow at the same time on the 
same channel.

Here's the database. Have a look at the last entry.

mysql> select * from record;
+----------+------+--------+-----------+------------+----------+------------+---
---------------------+----------+-------------+---------+
| recordid | type | chanid | starttime | startdate  | endtime  | 
enddate    | ti
tle                  | subtitle | description | profile |
+----------+------+--------+-----------+------------+----------+------------+---
---------------------+----------+-------------+---------+
|       19 |    3 |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | In
dy Racing League     | NULL     | NULL        |       0 |
|       14 |    3 |      7 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Fr
asier                | NULL     | NULL        |       0 |
|       25 |    3 |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Ca
rt                   | NULL     | NULL        |       0 |
|       16 |    3 |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Na
scar                 | NULL     | NULL        |       0 |
|        2 |    2 |     24 | 22:00:00  | 0000-00-00 | 22:30:00 | 
0000-00-00 | So
uth Park             | NULL     | NULL        |       0 |
|       24 |    2 |      7 | 20:15:00  | 0000-00-00 | 21:15:00 | 
0000-00-00 | En
terprise             | NULL     | NULL        |       0 |
|       22 |    2 |     16 | 19:45:00  | 0000-00-00 | 20:15:00 | 
0000-00-00 | Di
ck und Doof          | NULL     | NULL        |       0 |
|       42 |    3 |      2 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Di
e Schöneberger-Show | NULL     | NULL        |       0 |
|       44 |    1 |     35 | 20:00:00  | 2003-06-16 | 20:15:00 | 
2003-06-16 | Ta
gesschau             |          |             |       0 |
+----------+------+--------+-----------+------------+----------+------------+---
---------------------+----------+-------------+---------+
9 rows in set (0.00 sec)

mysql> select * from record;
+----------+------+--------+-----------+------------+----------+------------+---
---------------------+----------+-------------+---------+
| recordid | type | chanid | starttime | startdate  | endtime  | 
enddate    | ti
tle                  | subtitle | description | profile |
+----------+------+--------+-----------+------------+----------+------------+---
---------------------+----------+-------------+---------+
|       19 |    3 |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | In
dy Racing League     | NULL     | NULL        |       0 |
|       14 |    3 |      7 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Fr
asier                | NULL     | NULL        |       0 |
|       25 |    3 |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Ca
rt                   | NULL     | NULL        |       0 |
|       16 |    3 |     21 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Na
scar                 | NULL     | NULL        |       0 |
|        2 |    2 |     24 | 22:00:00  | 0000-00-00 | 22:30:00 | 
0000-00-00 | So
uth Park             | NULL     | NULL        |       0 |
|       24 |    2 |      7 | 20:15:00  | 0000-00-00 | 21:15:00 | 
0000-00-00 | En
terprise             | NULL     | NULL        |       0 |
|       22 |    2 |     16 | 19:45:00  | 0000-00-00 | 20:15:00 | 
0000-00-00 | Di
ck und Doof          | NULL     | NULL        |       0 |
|       42 |    3 |      2 | 00:00:00  | 0000-00-00 | 00:00:00 | 
0000-00-00 | Di
e Schöneberger-Show | NULL     | NULL        |       0 |
|       45 |    1 |     35 | 20:00:00  | 2003-06-17 | 20:15:00 | 
2003-06-17 | Ta
gesschau             |          |             |       0 |
+----------+------+--------+-----------+------------+----------+------------+---
---------------------+----------+-------------+---------+
9 rows in set (0.00 sec)

Ralf

Isaac Richards wrote:

>On Friday 13 June 2003 05:24 am, 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;
>>    
>>
>
>select * from record.  You're cutting off columns of interest.
>
>I can't reproduce this at all, by the way.
>
>Isaac
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at snowman.net
>http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>
>  
>