Can't Record Series - S.W.A.T. TV Show

[mcragoe]

I have SQLite installed on Linux, not sure how to run the command.

Thanks,

Mike

[mvallevand]

From the command prompt

sudo sqlite3 npvr.db3

sqlite3>delete from RECENTLY_DELETED where unique_identifier = 'EP026965470101';
sqlite3>.exit

Martin

[mcragoe]

I ran the command and received the following error.

Error: no such table: RECENTLY_DELETED

Logs attached.

Thanks,

Mike

[mvallevand]

No need for logs, are you sure it loaded npvr.db3

Martin

[mcragoe]

Here is the command output.

$ sudo sqlite3 npvr.db3
[sudo] password for cragoe:
SQLite version 3.22.0 2018-01-22 18:45:57
sqlite> delete from RECENTLY_DELETED where unique_identifier = 'EP026965470101';
Error: no such table: RECENTLY_DELETED
sqlite>

[mvallevand]

The one with real data is in /var/opt/nextpvr you may have created one.

Martin

[sub]

Are you sure you're in the directory that has npvr.db3 when you run that?

On my Ubuntu machine, my data directory is ~/.NPVR-data. I can change into that directory, then run your command and it succeeds. If you installed with the deb file, it's in /var/opt/nextpvr

Code:

graeme@ubuntu-nuc:~/.NPVR-data$ sqlite3 npvr.db3
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
sqlite> delete from RECENTLY_DELETED where unique_identifier = 'EP026965470101';
sqlite>

[mcragoe]

I installed Linux Mint 19.3 and used Martin's deb file to install NextPVR.

I ran the command again.

cragoe@pluto:~$ cd /var/opt/nextpvr
cragoe@pluto:/var/opt/nextpvr$ sqlite3 npvr.db3
SQLite version 3.22.0 2018-01-22 18:45:57
sqlite> delete from RECENTLY_DELETED where unique_identifier = 'EP026965470101';
Error: attempt to write a readonly database
sqlite>

Thanks,

Mike

[mvallevand]

You forgot sudo this time

Martin

[mcragoe]

Martin,

Oops, you are correct, I did not use sudo. I did just run it again and then was able to add S.W.A.T. as a recurring series to record all new shows. Not sure why this originally caused an issue for me.

Thanks Martin and Sub!!