<div class="gmail_quote">On 8 October 2012 17:17, Bill Meek <span dir="ltr"><<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>On 10/08/2012 03:31 AM, Paul Gardiner wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 07/10/2012 20:15, Martin Moores wrote:<br>
</blockquote></div>
...<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
So I looked into the possibility that the recording did not exist in the<br>
database. The filename in /var/lib/mythtv/recordings matches what is<br>
going into the script:<br>
<br>
1004_20120429205500.mpg<br>
<br>
But in the database, the start time is listed as:<br>
<br>
2012-04-29 19:55:00<br>
<br>
Which I imagine is due to the UTC time conversion in 0.26 and me being<br>
in the UK, with daylight savings etc<br>
</blockquote></blockquote></div>
...<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
What happens if you try 20120429195500? What value appears as<br>
%STARTTIME% if you run the user job?<br>
</blockquote></div>
...<br>
<br>
Hi;<br>
<br>
Did you upgrade to 0.26 after that program was recorded? You're correct,<br>
recorded.starttime was one of the columns changed to UTC by the upgrade<br>
process.<br>
<br>
The upgrade did not convert the filenames to UTC, but the filnames of new<br>
recordings will be in UTC.<br>
<br>
Can your script use --infile %FILE% rather than %STARTTIME% (or %STARTTIMEUTC%.)<br>
<br>
When you look in the database, compare the starttime and basename:<br>
<br>
select title,chanid,starttime,<u></u>basename from recorded order by starttime;<br>
<br>
That is not, in any way, a suggestion to change the database entries!<span><font color="#888888"><br>
<br>
-- <br>
Bill<br></font></span></blockquote><div><br>Thanks both for the replies, been on a course this week, so just looking at this again now<br><br>Bill,<br><br>Paul's script does not use "--infile", just chanid and starttime, so can't try that at the moment<br>
<br>Running the mysql you suggested (thanks for that) shows "starttime" and "basename" matching since I did the upgrade, but 1 hour off before I did the upgrade.<br><br>The program I was trying to run through the script was recorded before the upgrade, but running the script as a user job on brand new recordings, I get the same error and it shows as failed in mythweb.<br>
<br>Looking in the logs:<br><br>Oct 11 19:38:12 MYTHTV1 mythlogserver: mythbackend[5274]: I UserJob_1483 jobqueue.cpp:2409 (DoUserJobThread) JobQueue: Started MythTranscode for Breakfast recorded from channel 1001 at 2012-10-11T04:55:00Z<br>
Oct 11 19:38:12 MYTHTV1 mythlogserver: mythbackend[5274]: E UserJob_1483 jobqueue.cpp:2444 (DoUserJobThread) JobQueue: User Job '/home/user/mythtranscode.sh --chanid "1001" --starttime "20121011055500" --title "Breakfast" --subtitle "" --outdir /media/media/Videos/Other/Transcoded --passthrough' failed.<br>
</div></div><br>This shows that myth is looking for a recording starting at 04:55, the script is looking for 05:55, it actually started at 05:55, but still failed<br><br>The filename and basename are both 04:55, which is correct for UTC<br>
<br>Paul,<br><br>Manually running with the script "correct" time (04:55) works, on this new recording anyway. Running it on the old recording:<br>
<br>Oct 11 19:40:17 MYTHTV1 mythlogserver: mythbackend[5274]: I UserJob_1484 jobqueue.cpp:2409 (DoUserJobThread) JobQueue: Started MythTranscode for Homeland:"The Vest" recorded from channel 1004 at 2012-04-29T19:55:00Z<br>
Oct 11 19:40:17 MYTHTV1 mythlogserver: mythbackend[5274]: E UserJob_1484 jobqueue.cpp:2444 (DoUserJobThread) JobQueue: User Job '/home/user/mythtranscode.sh --chanid "1004" --starttime "20120429205500" --title "Homeland" --subtitle "The Vest" --outdir /media/media/Videos/Other/Transcoded --passthrough' failed.<br>
<br>Still 1 hour difference between the myth jobqueue line and the script<br><br>Recording actually started at 20:55, basename shows 19:55 and filename shows 20:55<br>
<br>Running the script manually with 19:55 works.<br><br>So:<br><br>Old recording - basename 04:55 - filename 04:55 - script looks for 05:55 (fail) - manual script run 04:55 (works)<br>New recording - basename 19:55 - filename 20:55 - script looks for 20:55 (fail - manual script run 19:55 (works)<br>
<br>I am thoroughly confused. It does seem that if the basename is matched, it works<br><br>Cheers<br><br>Martin<br>