2.2.6 Recordings not working, maybe related to SQLITE

[exiton]

I'll do a clean reinstall of the latest version and update.

[mvallevand]

For my problem I think NEWA is keeping the database locked and afterwards NPVR isn't able to do anything with the database until the recording service is restarted.

After applying the quick fix UJB posted on this thread http://forums.nextpvr.com/showthread.php...SearchLite I cannot duplicate any SearchLite or NEWA problems.

Martin

[exiton]

Ok, after a clean reinstall (uninstalled, removed NPVR directories, rebooted, reinstalled), it is giving me the same error in the log when trying to record a show using TV Guide. I did reinstall searchlite and guideplus. The only thing I brought from the old installation was pointing it to my mc2xml file.

Code:

2011-08-30 07:16:08.831    [ERROR][1]    Unexpected error saving scheduled recording: System.Data.SQLite.SQLiteException: SQLite error
14 values for 13 columns
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   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()

[sub]

Is it a recurring recording or one-off recording?

Is it a particular show, or any show that is causing problems?

[TVHelp]

I am new to nPVR, just loaded this weekend. I have just tried to install the guidePlus and am having the same issue with not being able to set a recording of any kind - not via TV Guide nor manually! I don't have any other plug-ins or utilities added except the xmlTV (mc2xml). I guess I will have to uninstall nPVR and re-install to see if I can get my record function back. I would be greatly interested in using guidePlus, but I think it needs some more detail about how to setup (what directories, etc.)

I saw one post that said something about mapping the channels to the new guidePlus xml, this is not indicated in the instructions. Can someone confirm that needs to be done?

Otherwise I will simply be interested in seeing how this post gets resolved.

[Redlow]

I am also having the same issue. I just updated to 2.2.6, and tried GuidePlus for the first time. We all have GuidePlus in common, I have noticed.

Code:

2011-10-21 21:30:44.037    [ERROR][1]    Unexpected error saving scheduled recording: System.Data.SQLite.SQLiteException: SQLite error
14 values for 13 columns
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   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()
2011-10-21 21:30:44.039    [DEBUG][1]    TV Listings: Got event RELOAD_RECORDINGS

Funny, pre-existing scheduled recordings are still recording fine. I just can't schedule new recordings of any form... whether quick, series, etc. Nor does this work in the OOB TV Guide, or TV Listings, or NEWA.

David

[sub]

I've never used GuidePlus. A couple of things that could cause it though is if it's overwriting one of the built in dlls with an older version, or if it's changing the database. Does anyone know if that is the case?

[mvallevand]

I had a look in guidePlus and it creates a trigger in NPVR.db3

Code:

CREATE TRIGGER [recordingInserted]  AFTER INSERT ON [SCHEDULED_RECORDING]  
FOR EACH ROW   BEGIN  
insert into RECORDED_EVENT  (rec_oid, oid,  title, subtitle, description, start_time, end_time,  channel_oid, unique_id, rating, original_air_date, season, episode)  
select new.OID, *  from EPG_EVENT
where new.name = EPG_EVENT.title and EPG_EVENT.start_time = new.start_time and EPG_EVENT.channel_oid = new.channel_oid;
END;

EPG_EVENT and RECORDED_EVENT are not the same so the insert syntax is wrong and carpeVideo needs to update the utility. To fix this so NPVR works (which breaks guidePlus) you need to use sqlite to update the database using this command

drop trigger recordingInserted

A command line example might be

sqlite3.exe \Users\Public\NPVR\npvr.db3 "DROP TRIGGER recordingInserted"

If you still want to experiment with guidePlus and you are experienced enough, you need to recreate the trigger and replace the * with oid, title, subtitle, description, start_time, end_time, channel_oid, unique_id, rating, original_air_date, season, episode or create a field called dvb_service_event_id in the RECORDED_EVENT table that guidePlus adds.

Note my earlier comments in this thread weren't related to this problem, that was an NEWA problem that occurred at the same time.

Martin

[sub]

Yep, that'd do it. Good spotting.

[sub]

Perfect example of why I dont like other developers changing the database.