Database corrupt, how to delete "deleted" pending recordings?

daneo · 2008-10-04, 02:21 PM

I had a lot of recordings on automatic where the padding was wrong -- so I deleted them all.

Now I can't re-create them. When I try, it tells me that the recordings failed. I can see them when I choose "deleted" under manage recordings, but don't know how to get rid of them to start over.

I don't want to nuke the database, as my tuners & XML EPG are a pain to setup again.

How can I get rid of these "phantom" deleted items so I can set them up again?

Thanks,
Dane

***sub*** · 2008-10-04, 04:03 PM

I dont know if this will help, but try running "pvrx2.exe -removehistory"

daneo · 2008-10-04, 05:11 PM

Hi Sub,

sorry, but no luck -- the entries are still there.

I get lovely errors on the web interface when I try to re-create the recurring recordings.

I will try an EPG purge and see what happens.

Dane

daneo · 2008-10-04, 05:42 PM

No luck on the purge either.

Damn.

***sub*** · 2008-10-04, 05:46 PM

daneo Wrote:I had a lot of recordings on automatic where the padding was wrong -- so I deleted them all.

Now I can't re-create them. When I try, it tells me that the recordings failed. I can see them when I choose "deleted" under manage recordings, but don't know how to get rid of them to start over.

I don't want to nuke the database, as my tuners & XML EPG are a pain to setup again.

How can I get rid of these "phantom" deleted items so I can set them up again?

To be honest, I dont know what you're talking about. I dont understand where you're seeing them. Where exactly do you see them in the recordings screen?

martint123 · 2008-10-04, 05:54 PM

Sounds like the EWA - I could never figure out what "deleted" recordings were and when they went. ISTR a "vacuum" assisted.

daneo · 2008-10-04, 08:24 PM

Hi Sub,

I've sent you access to EWA by private mail.

Regards,
Dane

***sub*** · 2008-10-04, 11:41 PM

Try using a tool like SQLiteSpy to execute the following SQL statement:

Code:
delete FROM "RECORDING_SCHEDULE" where status=6

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Live TV and recordings do not match	greg in kansas	8	6,926	2013-02-22, 06:35 PM Last Post: sub
	Can't view recordings on pc	jerry430	8	6,520	2013-01-21, 07:27 PM Last Post: jerry430
	Live TV not showing anything although recordings are OK. Pls advise.	seymoria	8	4,540	2012-08-07, 05:07 PM Last Post: ACTCMS
	CSI Miami Recordings Always In Spanish	ga_mueller	6	4,382	2012-06-12, 12:41 AM Last Post: mikeh49
	Recordings missing after switching hard drive	tegat	8	4,772	2011-12-21, 03:00 AM Last Post: tegat
	Recordings and live TV fail with TS mux	dvasco	4	2,558	2011-06-22, 05:47 PM Last Post: dvasco
	Stream errors in recordings with GBPVR	seymoria	11	4,282	2011-06-19, 06:44 PM Last Post: seymoria
	Lost all my recordings	pduncan67	2	1,890	2011-02-27, 03:12 PM Last Post: pduncan67
	Zero byte recordings	chuck_2330	0	1,352	2011-02-09, 01:25 PM Last Post: chuck_2330
	Huge database (+27GB) - is it a problem?	pme	7	2,763	2011-01-24, 12:37 AM Last Post: gEd