[mythtv-users] bug when scheduling recordings

[Ralf Haller]

Hi,

I tried to find the code where mythTV writes the scheduled recordings 
into the database in order to try to fix the bug. I was however unable 
to find these commands in the source code. Where is the data written to 
the record table?

Ralf

Ralf Haller wrote:

> 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
>>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>