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