Cant delete capture source

[Elmo Putney]

I've broken it!

I cant delete one of my capture sources, it keeps coming back when I go back into config.

I've been monkeying around with a second dual digital tuner and i wanted to get the capture source priority working so I used sqlitespy as per this thread:

http://forums.nextpvr.com/showthread.php...ight=order

Now I see in the config logs this:

2008-08-30 19:28:21.250 ERROR [1] Error Delete()'ing CaptureSource: The database file is locked
database is locked

What have I done? or is it unrelated?

[sub]

Reboot and it should clear itself.

[Elmo Putney]

I've tried a few times already, I'll have another go.

I also see many tuners in recording status now see screen grab attached

[Elmo Putney]

Nope reboot didnt help, sorry forgot the logs in the first post:

[Elmo Putney]

I now see this in my GBPVR.db3 file, but i'm well out of my depth here.

[sub]

Yeah, you cocked up that attempt to update the database.

You need to execute the following to fix it:

Code:

update CAPTURE_SOURCE set allocation_order=oid

It looks like you've instead done this:

Code:

update CAPTURE_SOURCE set allocation_order="oid"

[Elmo Putney]

Ahhh, normal service has resumed.

Thanks Sub.