Cannot get rid of daily record of TV program.

[bass_gas]

For future reference for others this clears the errors but I am not confident it will work for all errors like this.

Code:

delete from recurring_recording where oid in
(select oid from RECURRING_RECORDING
where substr(match_rules,instr(match_rules,"<ChannelOID>")+12,4) not in
(select oid from channel)
and match_rules not like '%ChannelOID>0<%')

Stop your recording service and backup you npvr.db3 and use the attached and restart the service.  I can't easily remove the duplicates but you should be able to do that yourself now.  Note I have deleted all your EPG data so I could attach it, once you remove the duplicates you should update the EPG.

It will be easier to delete them in NextPVR.exe or the web browser's UI client since they aren't sorted by name in the normal web client.  But there is a bug there too, since NextPVR doesn't retain the location https://forums.nextpvr.com/showthread.php?tid=63878  so if you don't want to lose your location Kodi works but it prompts you before deleting.

You will lose these shows but they weren't recording anyway because they are scheduled on a dead channel

Code:

Bob Hearts Abishola
Chicago Med
Chicago Fire
Chicago P.D.
Dateline NBC
Taxi
48 Hours
The Wonder Years

Good luck

Martin

Did as requested. As of this morn Wanted Dead or Alive still recording. Do not wish to mess with it anymore. If I do I'll uninstall entirely and re-install.

[mvallevand]

Did you delete the recurring recording for Wanted Dead or Alive that was still in the database?

Martin