[Solved] default for recordings startoffset and endoffset

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
tjwan68
Newcomer
Posts: 1
Joined: Sat Dec 08, 2018 2:17 pm
Germany

[Solved] default for recordings startoffset and endoffset

Post by tjwan68 »

Hi,

just came back to mythtv after a few years of absense.
I am running mythtv on a current debian 9 / mythtv v29.

I cannot find the menue to set startoffset / endoffset as default any more.
I know I can run something like

Code: Select all

update mythconverg.record 
set startoffset = 5,
endoffset = 15;
but I was not able to find the defaults in mythfrontend, mythtv-setup or mythweb.
Is it possible to edit the template via one of the frontend tools ?

Thanks
Tjwan
User avatar
Steve Goodey
Moderator
Posts: 219
Joined: Fri Feb 07, 2014 6:30 pm
Location: Colchester, England
Great Britain

Re: default for recordings startoffset and endoffset

Post by Steve Goodey »

https://www.mythtv.org/wiki/Manage_Reco ... le_Options

On the frontend, Manage Recordings, Recording Rules, then scroll down to Default Template.
Don't forget the Wiki.
JoeMyth
Newcomer
Posts: 3
Joined: Sun Feb 14, 2021 3:24 pm
Germany

Re: default for recordings startoffset and endoffset

Post by JoeMyth »

Hi,
I know this is an old thread, but I have an old problem so this is OK.
Years ago I added a rule to apply a start offset of 3 minutes and an end offset of 7 minutes to each recording. This was *NOT* the standard rule.
This rule is still in effect, each recording starts 3 minutes early and end 7 minutes late, although startoffset and endoffset are 0 in the database.
Does anyone know where this information is hidden in the latest db scheme?
I searched all tables and didn't find anything with a column name containing offset and a value of 3 or 7, see also my default rule below.

Code: Select all

mysql> select title, startoffset, endoffset, profile from record where startdate < '2015-01-01';
+--------------------+-------------+-----------+---------+
| title              | startoffset | endoffset | profile |
+--------------------+-------------+-----------+---------+
| Default (Template) |           0 |         0 | Default |
+--------------------+-------------+-----------+---------+
1 row in set (0.00 sec)
When I add offsets manually, they subtract/add from -3 and 7.

Code: Select all

mysql> select title, startoffset, endoffset, profile from record where startoffset <> 0;
+-------------------+-------------+-----------+---------+
| title             | startoffset | endoffset | profile |
+-------------------+-------------+-----------+---------+
| 30 Rock           |           3 |         0 | Default |
| Baby Daddy        |           1 |         1 | Default |
| Will & Grace      |           3 |         3 | Default |
| The Coroner       |           2 |         0 | Default |
| The Mindy Project |           1 |         0 | Default |
| Seinfeld          |           2 |         3 | Default |
+-------------------+-------------+-----------+---------+
6 rows in set (0.00 sec)
Any idea is appreciated!

Best regards

Joe
User avatar
dnalorernst
Developer
Posts: 103
Joined: Mon Feb 17, 2020 8:03 pm
Austria

Re: default for recordings startoffset and endoffset

Post by dnalorernst »

The "latest DB-Scheme" is ambiguous.
Please state version and scheme.
Future readers of this topic will appreciate this.

The "Default" recording rule only applies to new rules.
Please post the 'startdate' when you created these rule you mentioned as well:

Code: Select all

mysql> select title, startdate, startoffset, endoffset, profile from record where startoffset <> 0;
Have you applied any "Manual Overrides" to these rules?

What value has the global setting 'SchedOpenEnd' ?

Code: Select all

SELECT * FROM `settings` WHERE `value` LIKE 'SchedOpenEnd'
That's the value you entered in
https://www.mythtv.org/wiki/Configuring_Frontend
for the Scheduler Option 'Avoid back to back recordings' .
JoeMyth
Newcomer
Posts: 3
Joined: Sun Feb 14, 2021 3:24 pm
Germany

Re: default for recordings startoffset and endoffset

Post by JoeMyth »

Thank you for the quick response!

Yes, manual override was applied to the recordings below. All other recordings have startoffset = endoffset = 0, but still start 3 minutes early and end 7 minutes late. Years ago I set these offsets, and I cannot remember where. I'm not even sure if it was a rule or a setting somewhere else (backend configuration?). The database goes back to 2008 and was schema-ugraded several times.

Code: Select all

mysql> select title, startdate, startoffset, endoffset, profile from record where startoffset <> 0;
+-------------------+------------+-------------+-----------+---------+
| title             | startdate  | startoffset | endoffset | profile |
+-------------------+------------+-------------+-----------+---------+
| 30 Rock           | 2020-11-05 |           3 |         0 | Default |
| Baby Daddy        | 2019-06-01 |           1 |         1 | Default |
| Will & Grace      | 2020-03-10 |           3 |         3 | Default |
| The Coroner       | 2021-01-29 |           2 |         0 | Default |
| The Mindy Project | 2020-10-02 |           1 |         0 | Default |
| Seinfeld          | 2021-01-27 |           2 |         3 | Default |
+-------------------+------------+-------------+-----------+---------+
6 rows in set (0.00 sec)

Code: Select all

SELECT * FROM `settings` WHERE `value` LIKE 'SchedOpenEnd';
+--------------+------+----------+
| value        | data | hostname |
+--------------+------+----------+
| SchedOpenEnd | 0    | NULL     |
+--------------+------+----------+
1 row in set (0.01 sec)
Version info:
MythTV Version : v31.0+fixes.202102041836.7763a3363d~ubuntu18.04.1
MythTV Branch : fixes/31
Network Protocol : 91
Library API : 31.20200101-1
QT Version : 5.9.5
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: default for recordings startoffset and endoffset

Post by bill6502 »

Take a look in mythfrontend Setup->Video->General->General (Advanced):.
Values there are in seconds, so 180 and 420. Similar affect, but not startoffset
and endoffset. The help text has a good description.
JoeMyth
Newcomer
Posts: 3
Joined: Sun Feb 14, 2021 3:24 pm
Germany

Re: default for recordings startoffset and endoffset

Post by JoeMyth »

YES! I search this menu but obviously didn't go deep enough. Thank you!
Post Reply