<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<br><br>> Date: Thu, 16 Dec 2010 13:54:42 -0500<br>> From: mtdean@thirdcontact.com<br>> To: mythtv-users@mythtv.org<br>> Subject: Re: [mythtv-users] Recording unavailable , zero length at incorrect time<br>> <br>> On 12/16/2010 02:55 AM, Nick Morrott wrote:<br>> > On 14 December 2010 16:07, Bill Meek wrote:<br>> >> On Tue, 2010-12-14 at 08:16 +0000, Sean Salisbury wrote:<br>> >> ...<br>> >>> Is there an example of sql commands I could use to query the offset<br>> >>> for all upcoming recordings to see if its affecting all recordings.<br>> >> ...<br>> >><br>> >> Hi;<br>> >><br>> >> This will work:<br>> >><br>> >> SELECT title,starttime,startoffset FROM record;<br>> > In addition to Bill's information, the following should give you the<br>> > global pre/post-roll settings (which are unlikely to be causing the<br>> > issues you are seeing, but might be worth checking nonetheless):<br>> ><br>> > mysql> SELECT * FROM `settings` WHERE `value` = 'RecordPreRoll';<br>> > mysql> SELECT * FROM `settings` WHERE `value` = 'RecordOverTime';<br>> <br>> Then again, you could just use the UI to go in and look at them directly.<br>> <br>> Manage Recordings|Recording Rules, select the recording rule whose start <br>> early/end late you want to check.<br>> <br>> And to check all of them without having to work hard, but still using a <br>> UI, go to MythWeb Recording Schedules and look at the Start Early/End <br>> Late fields.<br>> <br>> Utilities/Setup|Setup|TV Settings|General, then check the "Time to <br>> record before start/past end of show (in seconds)" settings.<br>> <br>> The big benefit of using the UI that we provide is that you don't have <br>> to do any interpretation of raw data--which may not work the way you <br>> think it does.<br>> <br>> Remember, there's a UI for a reason...<br>> <br>> Mike<br>> _______________________________________________<br>> mythtv-users mailing list<br>> mythtv-users@mythtv.org<br>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<br><br><br>Thanks for all the help on the sql commands, didn't know which tables and entries I needed to check.<br><br>These showed the pending recordings having the expected zero offsets right upto roughly the start time, however recordings continued starting late suggesting corruption somewhere else when starting recording.<br><br>In the end I have completely removed myth and reinstalled 0.24 cleanly instead of update from 0.23 to see if the root cause was some form of corruption during update somewhere.<br><br>I have recorded multiple shows so far without any late starts, having some other issues and error messages in the backend log, but will track them down a bit further myself.<br><br>Sean<br> </body>
</html>