[mythtv-users] I somehow broke it [solved]

[Jonatan Lindblad]

Den 2020-01-04 kl. 01:47, skrev James Linder:
> 
> 
>> On 4 Jan 2020, at 12:43 am, mythtv-users-request at mythtv.org wrote:
>>
>>>>> Hi All
>>>>>
>>>>> myisamchk -r /var/lib/mysql/mythconverg
>>>>>
>>>>> fixed all the rules and guide data errors.
>>>>> Now a more careful look at backup and restore
>>>>> James
>>>>
>>>> You can tell MythTV to record something daily after a certain time of
>>>> day using the Power recording rules.  You may need to use mythfrontend
>>>> to create a Power rule - I do not think mythweb can do that.  You
>>>> write a small snippet of SQL telling the scheduler what to record. The
>>>> SQL would check the chanid of the channel, a programme title and for a
>>>> starttime in the range you want.  I used to use a rule like that to
>>>> record only the evening sessions of Coronation Street for my mother -
>>>> she was getting the afternoon repeats recorded as well and getting
>>>> confused by that.
>>>>
>>>> Go to Manage Recordings > Schedule Recordings > Custom Record to
>>>> create a Power rule.  Let me know if you need help doing SQL.
>>>
>>> Stephen thanks.
>>> I?ve a few power rules so my understanding bit is ok.
>>>
>>> What would be ideal is record XXX+15 min but it seems the scheduler wont do that.
>>
>> If you tell a recording rule to record for an extra 15 minutes, it
>> will always do that. 
> 
> Interesting in passing …
> 
> 31st Dec 15 min overrun working
> http://tigger.ws/downloads/myth4.png
> 
> I presume that they put their breakfast TV segment on the News so 1 hour + 1/2 hour +15 min
> 
> 1st Jan
> http://tigger.ws/downloads/myth0.png
> See the 15 min overrun is gone
> 
> So after pondering I decide to use a manual rule.
> Delete the rule (mythtv:6544)
> All rules and all guide data deleted!
> 
> (This is where if find my daily DB backup stopped in November)
> SQL fiddling all restore
> Do a backup
> 
> I can now repeate: delete rule - all gone - restore DB.

I'm not sure, but this sounds a bit like https://code.mythtv.org/trac/ticket/13348.

What does mythfrontend --version say?

Cheers
Jonatan