GuidePlus for NPVR

[toricred]

I'd like to use this, but I keep getting a SQL. Attached is the output from running it.

[Graham]

I'd like to use this, but I keep getting a SQL. Attached is the output from running it.

The wiki for GuidePlus at http://www.nextpvr.com/nwiki/pmwiki.php?....GuidePlus has ...

[ATTACHMENT NOT FOUND]

[mvallevand]

@carpeVideo, thanks since the last messages sub has made a few changes, including selection of archive folders at record time and on-demand, which use the recording service so no impact on the client, plus the resume position no longer cares about the folder so it deals with archiving well. I don't think I need any more archiving features othere than multiple resumes to go with colour marking.

I'd like to use this, but I keep getting a SQL. Attached is the output from running it.

Check the wiki, there's a command you need to run, it creates a non-standard database

Martin

[toricred]

I got it to run, but as I understand it the extra data will only be added for new recurring recordings I schedule as they will be the only ones in the new table. Is there a way to get existing recordings added to the trigger table?

[carpeVideo]

I may be able to get it to rename existing - I see that there have been a few more changes while I was AWOL. The issue was/is after the fact there is not enough data in the listing to rename as you need the original air date or a seasonepisode string from the guide data. But I have noticed that in the XML for most series there is an original air date so I may be able to start using that and remove the whole extra table trigger.

Sub can you confirm that the UID or Original Air Date is getting written to the xml file if it exists in the guide data?

CV

[mvallevand]

carperVideo I'm not sub but imageGrabLite depends on them getting written the the event_details field. They aren't mandatory so they won't be there on recording created in earlier versions, in some imported recordings or in recordings created by older version of TV Listings and other tools (NEWA is okay). It is of less value outside North America too.

Martin

[toricred]

I'm not trying to rename existing files, I just want to get the guide to have the correct season and episode information for shows I have configured as recurring recordings.

[toricred]

Help. Now I can't get any recurring recordings to schedule. My Nrecord log has a lot of errors like this:

2012-11-06 14:04:51.843 [ERROR][8] Unexpected error saving scheduled recording: System.Data.SQLite.SQLiteException: Abort due to constraint violation
RECORDED_EVENT.rec_oid may not be NULL
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at NUtility.ScheduledRecording.Save()

I assume this is related to the table creation by GuidePlus that I performed last night.

Edit: I got running for the moment by removing the limitation on null for rec_oid, but I know that's not really the correct fix.

[carpeVideo]

I'm not trying to rename existing files, I just want to get the guide to have the correct season and episode information for shows I have configured as recurring recordings.

It should have no problem doing that - it is only renaming older files that it can't do without more info (or adding the season/episode info to the descriptions of older recordings.) What command lne are you using? I will see if its running un-necessary code to do with the table that needs to be added for better renaming.

[carpeVideo]

Help. Now I can't get any recurring recordings to schedule. My Nrecord log has a lot of errors like this:

2012-11-06 14:04:51.843 [ERROR][8] Unexpected error saving scheduled recording: System.Data.SQLite.SQLiteException: Abort due to constraint violation
RECORDED_EVENT.rec_oid may not be NULL
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()

Edit: I got running for the moment by removing the limitation on null for rec_oid, but I know that's not really the correct fix.

Hmmm - I will see about making a version that no longer uses the trigger and looks in the several other possible places for what it needs that will help make the whole complication go away.