Orphan recording

DVBLink TV Server for Synology NAS is discussed here!

Orphan recording

Postby michhans » Sat Sep 17, 2016 2:04 pm

For some reason there's an orphan recording entry in the TV Recordings page. I can't delete it. When trying to, I get an error: "Error while deleting recording".
Any suggestions how to get rid of it?
Thanks!
michhans
 
Posts: 23
Joined: Sat Oct 13, 2012 8:28 am


Re: Orphan recording

Postby the_man » Tue Sep 20, 2016 10:36 am

Please, make a repair of the database then try remove this recording.
http://dvblogic.com/wiki/index.php/How_ ... :_Recorder
NETGEAR RNDU2000; Synology DS112j, DS 212j, DS213+, DS 712+; Western Digital WD ex2; Asustor AS3, RPI2 ...
PCTV 460,461e,292e; TT 4400, 4650CI;DVBSKy S960; DD octopus net; Inverto sat2ip multibox; TBS DVB-C ...
the_man
 
Posts: 4696
Joined: Mon Dec 02, 2013 1:11 pm

Re: Orphan recording

Postby michhans » Tue Sep 20, 2016 6:16 pm

I tried doing a Repair, but no change - the orphan recording is still there and can not be deleted.
michhans
 
Posts: 23
Joined: Sat Oct 13, 2012 8:28 am

Re: Orphan recording

Postby the_man » Wed Sep 21, 2016 8:41 am

Do you have any experience working with SQLIte or SQLBrowser ?
NETGEAR RNDU2000; Synology DS112j, DS 212j, DS213+, DS 712+; Western Digital WD ex2; Asustor AS3, RPI2 ...
PCTV 460,461e,292e; TT 4400, 4650CI;DVBSKy S960; DD octopus net; Inverto sat2ip multibox; TBS DVB-C ...
the_man
 
Posts: 4696
Joined: Mon Dec 02, 2013 1:11 pm

Re: Orphan recording

Postby michhans » Wed Sep 21, 2016 8:52 am

I've worked a lot with SQL being a developer, but I haven't used the mentioned tools. But I'll give a go :-)
What should I do?
michhans
 
Posts: 23
Joined: Sat Oct 13, 2012 8:28 am

Re: Orphan recording

Postby the_man » Wed Sep 21, 2016 9:02 am

Easier will be using of the SQLBroser.
Just install the software, stop the DVBlink server, open open the dlrecorder.db file in the SQLBrowser
The dlrecoder.db file you may find at the NAS filestation ../DVBLink/database/

Go to completed recordings table, and just remove the corrupted recording (remove the line with this entry)
Save changes, paste the db file back to original path, start the server.
NETGEAR RNDU2000; Synology DS112j, DS 212j, DS213+, DS 712+; Western Digital WD ex2; Asustor AS3, RPI2 ...
PCTV 460,461e,292e; TT 4400, 4650CI;DVBSKy S960; DD octopus net; Inverto sat2ip multibox; TBS DVB-C ...
the_man
 
Posts: 4696
Joined: Mon Dec 02, 2013 1:11 pm

Re: Orphan recording

Postby michhans » Wed Sep 21, 2016 9:07 am

Thanks, I'll try.

Do you have a link to the software I should install? When doing a Google search I get different results, but want to make sure I get the one you recommend.
michhans
 
Posts: 23
Joined: Sat Oct 13, 2012 8:28 am

Re: Orphan recording

Postby the_man » Wed Sep 21, 2016 9:30 am

NETGEAR RNDU2000; Synology DS112j, DS 212j, DS213+, DS 712+; Western Digital WD ex2; Asustor AS3, RPI2 ...
PCTV 460,461e,292e; TT 4400, 4650CI;DVBSKy S960; DD octopus net; Inverto sat2ip multibox; TBS DVB-C ...
the_man
 
Posts: 4696
Joined: Mon Dec 02, 2013 1:11 pm

Re: Orphan recording

Postby michhans » Wed Sep 21, 2016 3:03 pm

Easy to do and it works perfectly - Thanks!
michhans
 
Posts: 23
Joined: Sat Oct 13, 2012 8:28 am

Re: Orphan recording

Postby pdom » Mon Sep 26, 2016 10:43 am

I tried this as well, since I had 6 orphan recordings, and the Repair-function didn't work.

Super easy to do with the DB Browser... :)
pdom
 
Posts: 92
Joined: Sun Feb 24, 2013 11:48 am

Re: Orphan recording

Postby Aileron » Mon Feb 19, 2018 5:06 pm

Install SQLite Browser; Stop DVBlink server; Copy dlrecorder.db from NAS Filestation ../DVBLink/database/ to computer; Open dlrecorder.db in SQL Browser; Go to Browse Data\Table\completed_recording; Remove the corrupted recording (remove the line with this entry); Save changes; Paste the db file back to original path; Start the DVBLink server.
Aileron
 
Posts: 23
Joined: Tue Mar 04, 2014 6:53 am


Return to DVBLink TV Server for Synology NAS

Who is online

Users browsing this forum: No registered users and 4 guests

cron