[prev in list] [next in list] [prev in thread] [next in thread]
List: mythtv-dev
Subject: Re: [mythtv] Why do we reject previously shown dates before 1940
From: lsorense () csclub ! uwaterloo ! ca (Lennart Sorensen)
Date: 2020-12-07 15:16:42
Message-ID: 20201207151642.a2k5dymg6e6bwykz () csclub ! uwaterloo ! ca
[Download RAW message or body]
On Sun, Dec 06, 2020 at 09:36:38PM +0000, Paul Harrison wrote:
> I wonder how or where Schedules Direct get there original air dates from. I
> have 4 programs with original air date before 1940 in my DB currently. The
> earliest is for a program called Marconiphone from 1930-01-01.
>
>
> I don't have anything with bad dates like the commit found by Peter appears
> to be trying to fix. I'm using the XMLTV SD grabber by someone called Gary
> something or other I forget his name :)
>
>
> The 1940 date seems like an arbitrary date chosen at random maybe we could
> move it back to say 1920 or even 1900 without doing any harm?
>
>
> Lets do a quick survey run this query to see what programs if any you have
> in the EPG with original air dates before 1940.
>
> SELECT p.chanid, c.name, p.title, p.originalairdate, airdate FROM program p
> INNER JOIN channel c ON p.chanid = c.chanid WHERE p.originalairdate <
> '1940-1-1';
Wow quite a bit here:
+--------+---------------------------------+-------------------+-----------------+---------+
| chanid | name | title | originalairdate | airdate |
+--------+---------------------------------+-------------------+-----------------+---------+
| 1482 | AMC Canada HD | The Three Stooges | 1938-02-18 | 0000 |
| 10669 | RBTI | Os Três Patetas | 1934-05-05 | 2020 |
| 1563 | Turner Classic Movies Canada HD | Wild West Days | 1937-07-05 | 0000 |
| 1482 | AMC Canada HD | The Three Stooges | 1937-05-14 | 0000 |
| 1327 | Turner Classic Movies Canada | Wild West Days | 1937-07-05 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-11-15 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-10-25 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-06-07 | 0000 |
| 1328 | AMC CANADA | The Three Stooges | 1938-02-18 | 0000 |
| 10669 | RBTI | Os Três Patetas | 1934-05-05 | 2020 |
| 1482 | AMC Canada HD | The Three Stooges | 1937-05-14 | 0000 |
| 1482 | AMC Canada HD | The Three Stooges | 1938-02-18 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1938-01-03 | 0000 |
| 1563 | Turner Classic Movies Canada HD | Wild West Days | 1937-07-05 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-11-15 | 0000 |
| 1563 | Turner Classic Movies Canada HD | Wild West Days | 1937-07-05 | 0000 |
| 1482 | AMC Canada HD | The Three Stooges | 1937-05-14 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1939-01-16 | 0000 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-05-03 | 0000 |
| 1327 | Turner Classic Movies Canada | Wild West Days | 1937-07-05 | 0000 |
| 1328 | AMC CANADA | The Three Stooges | 1937-05-14 | 0000 |
| 10669 | RBTI | Os Três Patetas | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1328 | AMC CANADA | The Three Stooges | 1937-05-14 | 0000 |
| 1482 | AMC Canada HD | The Three Stooges | 1937-05-14 | 0000 |
| 1482 | AMC Canada HD | The Three Stooges | 1938-02-18 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1939-01-16 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-10-25 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-05-03 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-03-15 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-03-15 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-11-01 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-01-18 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-03-01 | 0000 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1938-01-03 | 0000 |
| 10669 | RBTI | Os Três Patetas | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-03-01 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-11-01 | 0000 |
| 1328 | AMC CANADA | The Three Stooges | 1938-02-18 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-01-18 | 0000 |
| 1482 | AMC Canada HD | The Three Stooges | 1937-05-14 | 0000 |
| 1328 | AMC CANADA | The Three Stooges | 1938-02-18 | 0000 |
| 1328 | AMC CANADA | The Three Stooges | 1937-05-14 | 0000 |
| 10324 | Silver Screen Classics | Lux Radio Theater | 1937-06-07 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1328 | AMC CANADA | The Three Stooges | 1937-05-14 | 0000 |
| 1482 | AMC Canada HD | The Three Stooges | 1938-02-18 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1328 | AMC CANADA | The Three Stooges | 1938-02-18 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1482 | AMC Canada HD | The Three Stooges | 1937-05-14 | 0000 |
| 1328 | AMC CANADA | The Three Stooges | 1937-05-14 | 0000 |
| 10669 | RBTI | Os Três Patetas | 1934-05-05 | 2020 |
| 10669 | RBTI | Os Três Patetas | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1328 | AMC CANADA | The Three Stooges | 1937-05-14 | 0000 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 1482 | AMC Canada HD | The Three Stooges | 1937-05-14 | 0000 |
| 1328 | AMC CANADA | The Three Stooges | 1937-05-14 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1328 | AMC CANADA | The Three Stooges | 1938-02-18 | 0000 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1482 | AMC Canada HD | The Three Stooges | 1938-02-18 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 1327 | Turner Classic Movies Canada | Wild West Days | 1937-07-05 | 0000 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
| 10343 | WSBK | The Three Stooges | 1934-05-05 | 2020 |
| 10571 | WSBKDT (WSBK-DT) | The Three Stooges | 1934-05-05 | 2020 |
+--------+---------------------------------+-------------------+-----------------+---------+
96 entries.
--
Len Sorensen
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic