[mythtv-users] mythfilldatabase inserts incorrect default program endtime

[Sven Wünschmann]

Hi mythtv-users,

I setup a mythtv box on Ubuntu 13.04 for Alice/O2/Hansenet IPTV channels and configured tv_grab_ch_search as EPG provider. The setup runs quite OK, but there is an issue with EPG data for the last programme of the day.

----------------------------------------------------------------------
$ dpkg -l | grep mythtv
ii libmythtv-perl 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 all A PERL library to access some MythTV features
ii mythtv-backend 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 amd64 Personal video recorder application (server)
ii mythtv-backend-master 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 all Metapackage to setup and configure a "Master Backend" profile of MythTV.
ii mythtv-common 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 amd64 Personal video recorder application (common data)
ii mythtv-database 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 all Personal video recorder application (database)
ii mythtv-frontend 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 amd64 Personal video recorder application (client)
ii mythtv-transcode-utils 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 amd64 Utilities used for transcoding MythTV tasks
ii php-mythtv 2:0.26.0+fixes.20121118.340b5d4-0ubuntu1 all PHP Bindings for MythTV
ii xbmc-pvr-mythtv-cmyth 1.6.9-0raring amd64 XBMC PVR Addon MythTv - Cmyth - PVR API:1.6.0
----------------------------------------------------------------------

Here are the facts:

- box is located in timezone CEST (GMT + 0200 currently)
- tv_grab_ch_search outputs only starttime data for programmes, no endtimes
- timestamps are in local time (CEST)
- mythtvfilldatabase inserts GMT times into databasse
- if there is no following programme in the grabber data, mythtvfilldatabase inserts 00:00:00 as endtime ==> error!

Result:

- As mythfilldatabase runs the grabber for each day separatly the endtimes of day's last programmes are not correct.

Expected:

- default endtime considers timezone data of the input / local timezone, i.e. default of 00:00 (local timezone) needs to be converted into GMT timestamp (e.g. 22:00 for GMT + 0200) to be consistent with the rest of the data and to make endtimes adjustment work correctly at the end of mythfilldatabase run.

Setting 

	mythtv-setup > 1. General > Locale Settings > Your local time zone (for XMLTV): Auto
to
	mythtv-setup > 1. General > Locale Settings > Your local time zone (for XMLTV): None
or
	mythtv-setup > 1. General > Locale Settings > Your local time zone (for XMLTV): +0200

does not have any effect.

Can anybody reproduce this result? Is this a configuration issue or a bug?

Cheers,
wu

------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE tv SYSTEM "xmltv.dtd">

<tv source-info-url="http://tv.search.ch/index.de.html" source-data-url="http://tv.search.ch/channels.de.html" generator-info-name="XMLTV" generator-info-url="http://xmltv.org/">
  <channel id="ard.search.ch">
    <display-name lang="de">ARD</display-name>
  </channel>
[...]
<programme start="20130507224500 +0200" channel="ard.search.ch">
    <title lang="de">Menschen bei Maischberger</title>
    <sub-title lang="de">Themen: Deutschland gerecht: Mehr Steuern für Reiche? | Gäste: Markus Söder (CSU, Bayerischer Finanzminister); Renate Künast (B´90/Grüne, Fraktionsvorsitzende); Bernhard Brink (Schlagersänger); Thomas Selter (Unternehmer); Leni Breymaier (Ver.di-Landeschefin)</sub-title>
    <desc lang="de">Bereits seit 2003 begrüsst Sandra Maischberger wöchentlich Gäste, [...]</desc>
    <date>2013</date>
    <category lang="de">Talkshow</category>
    <country lang="de">D</country>
    <video>
      <aspect>16:9</aspect>
    </video>
  </programme>
</tv>
------------------------------------------------------------------------------------------------------
mysql> select starttime, endtime, title from program where title like "Menschen bei%";
+---------------------+---------------------+---------------------------+
| starttime           | endtime             | title                     |
+---------------------+---------------------+---------------------------+
| 2013-05-07 20:45:00 | 2013-05-08 00:00:00 | Menschen bei Maischberger |
+---------------------+---------------------+---------------------------+
1 row in set (0.00 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130510/58d57593/attachment.html>