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

[Martin Moores]

On 13 December 2012 09:09, Bryan Bennetts <bryan.bennetts at gmail.com> wrote:

> 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.
>

See thread on this here:

http://www.gossamer-threads.com/lists/mythtv/users/530463

I went through the same issues and also saw the hour difference you are
seeing, see my posts later in the thread.

Changing to %STARTTIMEUTC% in my user job line worked for me.  I am not
using the same script as you, so can't comment specifically, but I imagine
the concept is the same.

Cheers

Martin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121213/2e5b5fcc/attachment.html>