[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.
>> 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
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...
More information about the mythtv-users