[mythtv-users] Mythexport vs UTC vs British Summer Time

Bryan Bennetts bryan.bennetts at gmail.com
Thu Dec 13 09:09:40 UTC 2012


Hi all,

I'm having a problem getting *some* recordings to export using mythexport
I'm guessing its due to them being recorded during summer time.

I'm using MythBuntu 12.04, myth version 0.26, export
scriptPortableH264HighRes.pm version 1.2 .

So for example, Hunted - Hourglass :

mysql> select subtitle,starttime,endtime from recorded where title like
> "hunted"  AND subtitle like "Hourglass";
> +-----------+---------------------+---------------------+
> | subtitle  | starttime           | endtime             |
> +-----------+---------------------+---------------------+
> | Hourglass | 2012-10-18 20:54:00 | 2012-10-18 22:10:10 |
> +-----------+---------------------+---------------------+
> 1 row in set (0.01 sec)


You can see the start time is 20:54, mythweb and mythfrontend show the
start time as 21:54, although iirc the actual start time *was* 21:00 (sans
6 minutes padding).

When I invoke the myth export job I get the following in the export log
(note I couldn't pursuade the debugging output to work so have hacked in
some output...)

December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: exportdir =
> /home/mythtv/Exported at line 353 in /usr/bin/mythexport-daemon
> December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: *starttime
> = 20121018215400* at line 354 in /usr/bin/mythexport-daemon
> December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: chanid =
> 2050 at line 355 in /usr/bin/mythexport-daemon
> December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: config =
> PortableH264HighRes at line 356 in /usr/bin/mythexport-daemon
> December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: query =
> SELECT rec.title, rec.subtitle, rec.description,
> pg.syndicatedepisodenumber, pg.showtype, rec.programid, rec.basename,
> rec.starttime
>     FROM recorded rec LEFT JOIN program pg ON pg.starttime = rec.starttime
> AND pg.chanid = rec.chanid
>     WHERE rec.chanid=? AND rec.starttime=? at line 365 in
> /usr/bin/mythexport-daemon
> December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: Going into
> new mode
>  at line 382 in /usr/bin/mythexport-daemon
> December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: query =
> SELECT callsign FROM channel WHERE chanid=? at line 390 in
> /usr/bin/mythexport-daemon
> avconv version 0.8.4-4:0.8.4-0ubuntu0.12.04.1, Copyright (c) 2000-2012 the
> Libav developers
>   built on Nov  6 2012 16:51:33 with gcc 4.6.3
> /media/: Operation not permitted
> December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: ERROR: No
> resulting file from ffmpeg, most likely your ffmpeg failed.  Enable
> debugging and test by hand. at line 459 in /usr/bin/mythexport-daemon


You can see in bold the start time it is looking for is 2154, thus it fails
to find the recording. IIRC I updated to 0.26 *after* this show was
recorded - but I could be wrong.

I have tried altering setupsave.cgi to use %STARTTIMEUTC% as mentioned
here<http://ubuntuforums.org/archive/index.php/t-2076815.html> to
no avail.

Presumably I can just change the start time/end time in the db work around
this issue, but its not a very good solution in the long term (assuming I
want to export more than this show)

Any thoughts?

TIA, Bryan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121213/7d466eaa/attachment-0001.html>


More information about the mythtv-users mailing list