[mythtv] [mythtv-commits] Ticket #1888: EIT failures with Finnish channels (DVB-T)

Michael T. Dean mtdean at thirdcontact.com
Mon Jul 10 21:07:22 UTC 2006


On 07/10/2006 05:03 PM, Otto Kolsi wrote:
> Michael T. Dean wrote:
>   
>>> I haven't really paid attention to 'airdate' column. Now that I look my 
>>> program data in DB, I can see a bit strange values. Query "select 
>>> distinct(airdate) from program" gives me two values:
>>>
>>> 0001-01-01
>>> 2000-01-01
>>>       
>> Jumping into the middle of a thread I haven't read, so ignore me if this 
>> info isn't helpful...
>>
>> What DBSchemaVer are you using?  The airdate column of program is 
>> supposed to be a YEAR(4) with a default of 0000, and the comments in 
>> dbcheck.cpp say
> Thanks for the explanations, I'm using schema version 1151. I'm using 
> DbVisualizer tool in Windows when working with the DB and this tool 
> fooled me. It shows those values above. When executing query from 
> commandline, results are:
>
> mysql> select distinct(airdate) from program;
> +---------+
> | airdate |
> +---------+
> |    0000 |
> |    2000 |
> +---------+
>
> So no mysteries here. 

Good.  That means you can ignore me.  I just knew that the output you 
showed should not have been the output provided by the mysql client 
utility for the SQL statement you gave, so I wanted to make sure you 
weren't chasing a "bug" that's due to a corrupt DB.

Good luck.  (Bowing out, now, because I know nothing about DVB or EIT.)

Mike


More information about the mythtv-dev mailing list