<div class="gmail_quote">On 13 December 2012 09:09, Bryan Bennetts <span dir="ltr"><<a href="mailto:bryan.bennetts@gmail.com" target="_blank">bryan.bennetts@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all,<div><br></div><div>I'm having a problem getting *some* recordings to export using mythexport I'm guessing its due to them being recorded during summer time.</div><div><br></div><div>I'm using MythBuntu 12.04, myth version 0.26, export scriptPortableH264HighRes.pm version 1.2 .</div>
<div><br></div><div>So for example, Hunted - Hourglass :</div><div><br></div><div><blockquote class="gmail_quote" style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
mysql> select subtitle,starttime,endtime from recorded where title like "hunted" AND subtitle like "Hourglass";<br>+-----------+---------------------+---------------------+<br>| subtitle | starttime | endtime |<br>
+-----------+---------------------+---------------------+<br>| Hourglass | 2012-10-18 20:54:00 | 2012-10-18 22:10:10 |<br>+-----------+---------------------+---------------------+<br>1 row in set (0.01 sec)</blockquote><div>
<br></div></div><div>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).</div><div><br></div><div>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...)</div>
<div><br></div><div><blockquote class="gmail_quote" style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: exportdir = /home/mythtv/Exported at line 353 in /usr/bin/mythexport-daemon<br>December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: <b>starttime = 20121018215400</b> at line 354 in /usr/bin/mythexport-daemon<br>
December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: chanid = 2050 at line 355 in /usr/bin/mythexport-daemon<br>December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: config = PortableH264HighRes at line 356 in /usr/bin/mythexport-daemon<br>
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<br> FROM recorded rec LEFT JOIN program pg ON pg.starttime = rec.starttime AND pg.chanid = rec.chanid<br>
WHERE rec.chanid=? AND rec.starttime=? at line 365 in /usr/bin/mythexport-daemon<br>December 11 12:39:05 doombar /usr/bin/mythexport-daemon[1466]: Going into new mode<br> at line 382 in /usr/bin/mythexport-daemon<br>
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<br>
avconv version 0.8.4-4:0.8.4-0ubuntu0.12.04.1, Copyright (c) 2000-2012 the Libav developers<br> built on Nov 6 2012 16:51:33 with gcc 4.6.3<br>/media/: Operation not permitted<br>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</blockquote>
</div><div><br></div><div>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.</div><div><br></div>
<div>I have tried altering setupsave.cgi to use %STARTTIMEUTC% as mentioned <a href="http://ubuntuforums.org/archive/index.php/t-2076815.html" target="_blank">here</a> to no avail.</div><div><br></div><div>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)</div>
<div><br></div><div>Any thoughts?</div><div><br></div><div>TIA, Bryan.</div></blockquote><div><br>See thread on this here:<br><br><a href="http://www.gossamer-threads.com/lists/mythtv/users/530463">http://www.gossamer-threads.com/lists/mythtv/users/530463</a><br>
<br>I went through the same issues and also saw the hour difference you are seeing, see my posts later in the thread.<br><br>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.<br>
<br>Cheers<br><br>Martin<br></div></div>