[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