mythbuntu-bugs team mailing list archive
-
mythbuntu-bugs team
-
Mailing list archive
-
Message #07245
[Bug 1027871] Re: EIT not observing timezone correctly
The data in the database on 0.26 is all in UTC, so "News at 6PM" in +12:00 is correctly stored with 06:00 UTC in the datebase.
Please try changing your power search to match the change done to the filters in http://code.mythtv.org/cgit/mythtv/commit/?id=7fb9747c047add7d149f32afd27f20bd0f76ea6e
the old
program.title LIKE \'%news%\' AND HOUR(program.starttime) >= 18 AND HOUR(program.starttime) < 21 AND (channel.callsign = \'TV ONE\')
becomes
program.title LIKE \'%news%\' AND (HOUR(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM')) >= 18 AND (HOUR(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM')) < 21 AND (channel.callsign = \'TV ONE\')
** Changed in: mythbuntu
Status: New => Invalid
--
You received this bug notification because you are a member of Mythbuntu
Bug Team, 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:
Invalid
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
References