← Back to team overview

linux-traipu team mailing list archive

[Bug 1027871] [NEW] EIT not observing timezone correctly

 

Public bug reported:

Found that program information from EIT time offset is wrong after
upgrade to 0.26, and it breaks the custom rules that use
program.starttime comparisons.  For me, in NZ, the timezone is
Pacific/Auckland which is NZST officially (UTC+1200), however the
program table shows entries for 6pm occuring at 0600.

Interestingly, when frontend displays the program guide, the correct
AM/PM indications is given.  So, it must just be a hook to custom
recording schedules that is broken.  Some information below:

$ cat /etc/timezone
Pacific/Auckland

$ date
Mon Jul 23 22:30:41 NZST 2012

$ date -R
Mon, 23 Jul 2012 22:30:44 +1200

mysql> SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York');
+--------------------------------------------------------------+
| CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York') |
+--------------------------------------------------------------+
| 2012-06-07 08:00:00                                          |
+--------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'Pacific/Auckland');
+--------------------------------------------------------------+
| CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'Pacific/Auckland') |
+--------------------------------------------------------------+
| 2012-06-08 00:00:00                                          |
+--------------------------------------------------------------+
1 row in set (0.05 sec)

mysql> select title,starttime from program where title like 'One News%' order by starttime;
+--------------------+---------------------+
| title              | starttime           |
+--------------------+---------------------+
| ONE News at Midday | 2012-07-23 00:00:00 |
| ONE News at 4.30   | 2012-07-23 04:30:00 |
| ONE News At 6pm    | 2012-07-23 06:00:00 |
| ONE News Tonight   | 2012-07-23 10:25:00 |
| ONE News at Midday | 2012-07-24 00:00:00 |
| ONE News at 4.30   | 2012-07-24 04:30:00 |
| ONE News At 6pm    | 2012-07-24 06:00:00 |
| ONE News Tonight   | 2012-07-24 10:30:00 |
| ONE News at Midday | 2012-07-25 00:00:00 |
| ONE News at 4.30   | 2012-07-25 04:30:00 |
| ONE News At 6pm    | 2012-07-25 06:00:00 |
| ONE News Tonight   | 2012-07-25 10:25:00 |
| ONE News at Midday | 2012-07-26 00:00:00 |
| ONE News at 4.30   | 2012-07-26 04:30:00 |
| ONE News At 6pm    | 2012-07-26 06:00:00 |
| ONE News Tonight   | 2012-07-26 10:45:00 |
| ONE News at Midday | 2012-07-27 00:00:00 |
| ONE News at 4.30   | 2012-07-27 04:30:00 |
| ONE News At 6pm    | 2012-07-27 06:00:00 |
| ONE News Tonight   | 2012-07-27 10:25:00 |
| ONE News At 6pm    | 2012-07-28 06:00:00 |
| ONE News At 6pm    | 2012-07-29 06:00:00 |
| ONE News at Midday | 2012-07-30 00:00:00 |
| ONE News at 4.30   | 2012-07-30 04:30:00 |
| ONE News At 6pm    | 2012-07-30 06:00:00 |
| ONE News Tonight   | 2012-07-30 10:25:00 |
+--------------------+---------------------+

The following recording rule, is an example that currently finds NOTHING
to record.  It should match 'ONE News At 6pm', daily.


INSERT INTO `record` VALUES (556,9,0,'10:46:23','2012-06-17','10:46:23','2012-06-17','TV ONE News (Power Search)','','program.title LIKE \'%news%\' AND HOUR(program.starttime) >= 18 AND HOUR(program.starttime) < 21 AND (channel.callsign = \'TV ONE\')',0,0,'','Default',0,1,3,1,0,0,'Default',1,15,'','','','',1,0,0,0,0,0,0,0,1,'00:00:00',735036,0,0,0,'Default',0,'0000-00-00 00:00:00','2012-07-21 18:37:14','2012-07-22 06:22:31','Default',9,0)

I have tried changing both "TimeOffset" and "EITTimeOffset" values in
the settings table to reflect our TZ (+1200), but hasn't helped.

mysql> select * from settings where value like '%offset%';
+---------------------+------+-----------+
| value               | data | hostname  |
+---------------------+------+-----------+
| TimeOffset          | 0    | NULL      |
| EITTimeOffset       | Auto | NULL      |
| PreviewPixmapOffset | 180  | NULL      |
| GuiOffsetX          |      | mythbuntu |
| GuiOffsetY          |      | mythbuntu |
| DefaultStartOffset  | 0    | NULL      |
| DefaultEndOffset    | 0    | NULL      |
| AudioSyncOffset     | 0    | mythbuntu |
+---------------------+------+-----------+
8 rows in set (0.00 sec)


mysql> select * from settings where value like '%offset%';
+---------------------+-------+-----------+
| value               | data  | hostname  |
+---------------------+-------+-----------+
| TimeOffset          | +1200 | NULL      |
| EITTimeOffset       | +1200 | NULL      |
| PreviewPixmapOffset | 180   | NULL      |
| GuiOffsetX          |       | mythbuntu |
| GuiOffsetY          |       | mythbuntu |
| DefaultStartOffset  | 0     | NULL      |
| DefaultEndOffset    | 0     | NULL      |
| AudioSyncOffset     | 0     | mythbuntu |
+---------------------+-------+-----------+
8 rows in set (0.01 sec)

** Affects: mythbuntu
     Importance: Undecided
         Status: New


** Tags: timezone

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Mythbuntu.
https://bugs.launchpad.net/bugs/1027871

Title:
  EIT not observing timezone correctly

Status in Mythbuntu, Ubuntu derivative focused upon MythTV:
  New

Bug description:
  Found that program information from EIT time offset is wrong after
  upgrade to 0.26, and it breaks the custom rules that use
  program.starttime comparisons.  For me, in NZ, the timezone is
  Pacific/Auckland which is NZST officially (UTC+1200), however the
  program table shows entries for 6pm occuring at 0600.

  Interestingly, when frontend displays the program guide, the correct
  AM/PM indications is given.  So, it must just be a hook to custom
  recording schedules that is broken.  Some information below:

  $ cat /etc/timezone
  Pacific/Auckland

  $ date
  Mon Jul 23 22:30:41 NZST 2012

  $ date -R
  Mon, 23 Jul 2012 22:30:44 +1200

  mysql> SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York');
  +--------------------------------------------------------------+
  | CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York') |
  +--------------------------------------------------------------+
  | 2012-06-07 08:00:00                                          |
  +--------------------------------------------------------------+
  1 row in set (0.00 sec)

  mysql> SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'Pacific/Auckland');
  +--------------------------------------------------------------+
  | CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'Pacific/Auckland') |
  +--------------------------------------------------------------+
  | 2012-06-08 00:00:00                                          |
  +--------------------------------------------------------------+
  1 row in set (0.05 sec)

  mysql> select title,starttime from program where title like 'One News%' order by starttime;
  +--------------------+---------------------+
  | title              | starttime           |
  +--------------------+---------------------+
  | ONE News at Midday | 2012-07-23 00:00:00 |
  | ONE News at 4.30   | 2012-07-23 04:30:00 |
  | ONE News At 6pm    | 2012-07-23 06:00:00 |
  | ONE News Tonight   | 2012-07-23 10:25:00 |
  | ONE News at Midday | 2012-07-24 00:00:00 |
  | ONE News at 4.30   | 2012-07-24 04:30:00 |
  | ONE News At 6pm    | 2012-07-24 06:00:00 |
  | ONE News Tonight   | 2012-07-24 10:30:00 |
  | ONE News at Midday | 2012-07-25 00:00:00 |
  | ONE News at 4.30   | 2012-07-25 04:30:00 |
  | ONE News At 6pm    | 2012-07-25 06:00:00 |
  | ONE News Tonight   | 2012-07-25 10:25:00 |
  | ONE News at Midday | 2012-07-26 00:00:00 |
  | ONE News at 4.30   | 2012-07-26 04:30:00 |
  | ONE News At 6pm    | 2012-07-26 06:00:00 |
  | ONE News Tonight   | 2012-07-26 10:45:00 |
  | ONE News at Midday | 2012-07-27 00:00:00 |
  | ONE News at 4.30   | 2012-07-27 04:30:00 |
  | ONE News At 6pm    | 2012-07-27 06:00:00 |
  | ONE News Tonight   | 2012-07-27 10:25:00 |
  | ONE News At 6pm    | 2012-07-28 06:00:00 |
  | ONE News At 6pm    | 2012-07-29 06:00:00 |
  | ONE News at Midday | 2012-07-30 00:00:00 |
  | ONE News at 4.30   | 2012-07-30 04:30:00 |
  | ONE News At 6pm    | 2012-07-30 06:00:00 |
  | ONE News Tonight   | 2012-07-30 10:25:00 |
  +--------------------+---------------------+

  The following recording rule, is an example that currently finds
  NOTHING to record.  It should match 'ONE News At 6pm', daily.

  
  INSERT INTO `record` VALUES (556,9,0,'10:46:23','2012-06-17','10:46:23','2012-06-17','TV ONE News (Power Search)','','program.title LIKE \'%news%\' AND HOUR(program.starttime) >= 18 AND HOUR(program.starttime) < 21 AND (channel.callsign = \'TV ONE\')',0,0,'','Default',0,1,3,1,0,0,'Default',1,15,'','','','',1,0,0,0,0,0,0,0,1,'00:00:00',735036,0,0,0,'Default',0,'0000-00-00 00:00:00','2012-07-21 18:37:14','2012-07-22 06:22:31','Default',9,0)

  I have tried changing both "TimeOffset" and "EITTimeOffset" values in
  the settings table to reflect our TZ (+1200), but hasn't helped.

  mysql> select * from settings where value like '%offset%';
  +---------------------+------+-----------+
  | value               | data | hostname  |
  +---------------------+------+-----------+
  | TimeOffset          | 0    | NULL      |
  | EITTimeOffset       | Auto | NULL      |
  | PreviewPixmapOffset | 180  | NULL      |
  | GuiOffsetX          |      | mythbuntu |
  | GuiOffsetY          |      | mythbuntu |
  | DefaultStartOffset  | 0    | NULL      |
  | DefaultEndOffset    | 0    | NULL      |
  | AudioSyncOffset     | 0    | mythbuntu |
  +---------------------+------+-----------+
  8 rows in set (0.00 sec)

  
  mysql> select * from settings where value like '%offset%';
  +---------------------+-------+-----------+
  | value               | data  | hostname  |
  +---------------------+-------+-----------+
  | TimeOffset          | +1200 | NULL      |
  | EITTimeOffset       | +1200 | NULL      |
  | PreviewPixmapOffset | 180   | NULL      |
  | GuiOffsetX          |       | mythbuntu |
  | GuiOffsetY          |       | mythbuntu |
  | DefaultStartOffset  | 0     | NULL      |
  | DefaultEndOffset    | 0     | NULL      |
  | AudioSyncOffset     | 0     | mythbuntu |
  +---------------------+-------+-----------+
  8 rows in set (0.01 sec)

To manage notifications about this bug go to:
https://bugs.launchpad.net/mythbuntu/+bug/1027871/+subscriptions


Follow ups

References