Cannot get rid of daily record of TV program.

[bass_gas]

[attachment=undefined]This is all on Windows10..... won't let me attach db3 file. 18.181Kb

[mvallevand]

I didn't ask you to attach it so I am not surprised. Please read the posts fully.

Martin

[bass_gas]

Never was scheduled from Kodi only windows 10. Also as of today its just like the movie JASON "Its back again" ready to record Monday morn.

[mvallevand]

Of course it will with all those recurring recordings. That is why you need to give use an external link to your database so we can help you.

Martin

[sub]

From what we can see, you've got lots of recurring recordings setup for this show. It's not clear how you managed to create so many, but it's going to keep scheduling episodes for these until you've deleted all the recurring recordings you've setup.

2022-06-03 02:46:07.521 [INFO][98] UpdateRecurringRecording(149, 'Wanted: Dead or Alive'):
2022-06-03 02:46:08.454 [INFO][98] UpdateRecurringRecording(217, 'Wanted: Dead or Alive'):
2022-06-03 02:46:08.892 [INFO][98] UpdateRecurringRecording(218, 'Wanted: Dead or Alive'):
2022-06-03 02:46:08.924 [INFO][98] UpdateRecurringRecording(219, 'Wanted: Dead or Alive')
....

As Martin said, if you'd like to zip up your NPVR.db3, and put it somewhere like onedrive or google drive, and let us know the download link, we can delete them all for you.

[bass_gas]

Of course it will with all those recurring recordings.  That is why you need to give use an external link to your database so we can help you.

Martin

So how to do it? The old remote PC is not available on W10.

[mvallevand]

As sub and I both have posted put it on GoggleDrive, OneDrive or DropBox.

Martin

[bass_gas]

As sub and I both have posted put it on GoggleDrive, OneDrive or DropBox.

Martin

https://drive.google.com/file/d/1XqS8FmY...sp=sharing

hope this works

[mvallevand]

We should be able to do something now. There is a bug in the delete logic (probably because the channel_id is invalid leaving something locked and also the API return shows success. I will remove all the recurring recordings against bad channels.

Code:

2022-06-07 13:52:54.887    [DEBUG][37]    Got request [127.0.0.1]: /service (recording.recurring.delete)
2022-06-07 13:52:54.887    [DEBUG][37]    method=recording.recurring.delete
2022-06-07 13:52:54.887    [DEBUG][37]    parameters:
2022-06-07 13:52:54.887    [DEBUG][37]       method: recording.recurring.delete
2022-06-07 13:52:54.887    [DEBUG][37]       recurring_id: 80
2022-06-07 13:52:54.887    [DEBUG][37]       channel_id: 7372
2022-06-07 13:52:54.887    [DEBUG][37]       event_id: 0
2022-06-07 13:52:54.887    [DEBUG][37]       keep: 0
2022-06-07 13:52:54.887    [DEBUG][37]       pre_padding: 1
2022-06-07 13:52:54.887    [DEBUG][37]       post_padding: 2
2022-06-07 13:52:54.887    [DEBUG][37]       day_mask: SAT:SUN:MON:TUE:WED:THU:FRI:
2022-06-07 13:52:54.887    [DEBUG][37]       directory_id: Default
2022-06-07 13:52:54.887    [DEBUG][37]       only_new: true
2022-06-07 13:52:54.887    [DEBUG][37]       enabled: true
2022-06-07 13:52:54.887    [DEBUG][37]       sid: 2dd785502f7741aeaf3703546da0f88e
2022-06-07 13:52:54.887    [DEBUG][37]       client_ip: 127.0.0.1
2022-06-07 13:52:54.887    [DEBUG][37]       user_agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:100.0) Gecko/20100101 Firefox/100.0
2022-06-07 13:52:54.887    [DEBUG][37]       host_callback: ...
2022-06-07 13:52:54.887    [DEBUG][37]    Deleting RecurringRecording oid:80
2022-06-07 13:52:54.887    [ERROR][37]    Unexpected error in RemovePendingForRecurring(): Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 8: 'attempt to write a readonly database'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at NUtility.RecentlyDeleted.RemovePendingForRecurring(Int32 recurringOID)
2022-06-07 13:52:54.889    [ERROR][37]    Unexpected error deleting RecurringRecording: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 8: 'attempt to write a readonly database'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at NUtility.RecurringRecording.Delete()
2022-06-07 13:52:54.889    [DEBUG][37]    <?xml version="1.0" encoding="utf-8" ?>
<rsp stat="ok">
</rsp>

Martin

[mvallevand]

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