Recordings doesn't use same channel tuners

[Handy.Man]

I remember reading about using an utility like SQLiteDatabaseBrowser to change the capture_source_oid of scheduled recording in order for each channel is on the same tuner so that pre/post padding can be achieved without rescheduling ?

Would that be a viable option ?

[Handy.Man]

I found out why the top recordings don't change place, they are all with 0 priority

[johnsonx42]

you shouldn't have all those zeros in the priority column. by default priority=oid and can never be zero. either something went very wrong during the upgrade when adjustable priority was added (3 or 4 releases ago at least), or TV Listings is doing this; I'd bet on the latter. I don't know how much alibert keeps TV Listings up to date; he isn't very active any more.

To fix this and get your recurring recordings back to default priorities, execute this SQL statement:

Code:

UPDATE RECURRING_RECORDING SET priority=oid

I use SQLiteSpy; you can also do it from the command line with sqlite3.exe "c:\Users\Public\NPVR\npvr.db3" "UPDATE RECURRING_RECORDING SET priority=oid"

Or if nothing else has changed in your database since you posted it, you can use the fixed version I've attached (just exit NextPVR.exe and stop the recording service before swapping in the database).

Regardless of how you get the database updated to fix the priority column, I strongly recommend you exit and restart NextPVR and then run an EPG udpate to re-schedule all the recordings with default priorities.

Once you have all the recordings back to where priority=oid, then you can go back and adjust the priorities with no more problems.

[johnsonx42]

I remember reading about using an utility like SQLiteDatabaseBrowser to change the capture_source_oid of scheduled recording in order for each channel is on the same tuner so that pre/post padding can be achieved without rescheduling ?

Would that be a viable option ?

sure you can do that. just don't blame me or sub for the consequences; you are VERY on your own if you do.

[Handy.Man]

Will do this during the night as NextPVR will be recording all evening.

[johnsonx42]

important, just in case you missed my edit above:

Regardless of how you get the database updated to fix the priority column, I strongly recommend you exit and restart NextPVR and then run an EPG udpate to re-schedule all the recordings with default priorities.

[Handy.Man]

sure you can do that. just don't blame me or sub for the consequences; you are VERY on your own if you do.

I will make backup copy before, Stop NPVR Service, do the modifications, Start NPVR Service and will check what happens if I do create recording during the day.

This seems like a good option as doing the modifications for the recordings of the day doesn't take much time.

[johnsonx42]

mvallevand, get some dark goggles for the low-yield nuclear detonation that may result when Handy.Man screws with his database!

[Handy.Man]

I haven't use TV Listing for scheduling recordings for about a week now.

I will try to modify the priority as well after fixing the db3, maybe the tuners will be "aligned" when it is to my liking.

Once the priority of Recurring Recordings are changed, I think I should do a EPG update to have the changed reflected in the scheduled recordings.

[Handy.Man]

mvallevand, get some dark goggles for the low-yield nuclear detonation that may result when Handy.Man screws with his database!

I wouldn't push my luck as to specify the seconds in Start/End_Time column :p