[mythtv-users] Recording unavailable , zero length at incorrect time

Michael T. Dean mtdean at thirdcontact.com
Thu Dec 16 18:54:42 UTC 2010


  On 12/16/2010 02:55 AM, Nick Morrott wrote:
> On 14 December 2010 16:07, Bill Meek wrote:
>> On Tue, 2010-12-14 at 08:16 +0000, Sean Salisbury wrote:
>> ...
>>> Is there an example of sql commands I could use to query the offset
>>> for all upcoming recordings to see if its affecting all recordings.
>> ...
>>
>> Hi;
>>
>> This will work:
>>
>> SELECT title,starttime,startoffset FROM record;
> In addition to Bill's information, the following should give you the
> global pre/post-roll settings (which are unlikely to be causing the
> issues you are seeing, but might be worth checking nonetheless):
>
> mysql>  SELECT * FROM `settings` WHERE `value` = 'RecordPreRoll';
> mysql>  SELECT * FROM `settings` WHERE `value` = 'RecordOverTime';

Then again, you could just use the UI to go in and look at them directly.

Manage Recordings|Recording Rules, select the recording rule whose start 
early/end late you want to check.

And to check all of them without having to work hard, but still using a 
UI, go to MythWeb Recording Schedules and look at the Start Early/End 
Late fields.

Utilities/Setup|Setup|TV Settings|General, then check the "Time to 
record before start/past end of show (in seconds)" settings.

The big benefit of using the UI that we provide is that you don't have 
to do any interpretation of raw data--which may not work the way you 
think it does.

Remember, there's a UI for a reason...

Mike


More information about the mythtv-users mailing list