I posted here in Developers as I need some helped from tech minded folk.
I'm trying to find a more efficient way of handling large amounts of EPG data when a user has a lot of TV channels configured for npvr.
At the moment I create 7 individual XML files for nDroid (one for each day) using a query similar to the following...
Code:
SELECT * FROM EPG_EVENT WHERE end_time > '2013-02-02 00:00:00' AND start_time < '2013-02-02 23:59:59' ORDER BY channel_oid
With my setup of 67 channels, it returns 1060 results for 1 day but if I create a query for a single channel for an entire week similar to...
Code:
SELECT * FROM EPG_EVENT WHERE end_time > '2013-02-02 00:00:00' AND start_time < '2013-02-08 23:59:59' AND channel_oid = 10029 ORDER BY start_time
...I get 260 results which is less than 1/4.
So...a little request for help - if anyone is happy to spend a few minutes playing with SQL queries on their npvr database, I'd appreciate some comparisons between the number of results returned with the two queries above. I'm particularly interested in anyone with a lot of channels (perhaps 120+ and definitely 150-200 or more). Obviously the second query will need adjusting for a valid channel_oid.
I just recently setup nextpvr installing all of the R2 patches and am having some issues when playing Live TV in XBMC with timeshifting enabled. I will randomly get a tuner no longer available error message and then the Live TV video reverts to when I started watching and loops through at about 2 second intervals (the following is my log from XBMC at the time it occurs). I watched my Live TV folder and it appears to occur when a new Live TV segment file is created. This happens randomly and varies between each of the four files being created but always occurs between the transition from one file to the next. I do not have any issues playing Live TV when I disable timeshifting in XBMC. I have three machines running the nextpvr XBMC addon and all exhibit the same behavior.
i'm trying to setup npvr with Ceton for brighthouse in FL. I am currently running WME with Ceton and it works just fine. Only issue is livetv and streaming of recorded show to my xbmc on atv, therefore npvr :-).
So far i configure npvr to see the Ceton tuner 1 [i am starting with the first one for now] using NetworkRecorder plugin. My next challenge is to setup TV guide/channels so i can record something. Can somone point me to what do i need to do next to setup TV guide/channels? there is no capablity to scan channels as outlined in the wiki @http://www.nextpvr.com/nwiki/pmwiki.php?n=Walkthrough.ConfigureQAMDeviceWithSDEPG. This is because of the networkrecorder pluging which uses sageDCT.
One other thing, i am doing this setup to move away from monthly fees. So Schedule Direct is a no starter because of monthly fees.
Is it just me or XBMC playback video quality (LiveTV or recording) is worst then when i playback form WMP or from Npvr? If so, is this because XBMC doing some sort of operation in the background causing this or XBMC + PVR addon and its the same with any PVR addon that is used?
NPVR 9, applied the patches from the sticky. Checked all prerequisites (a little tricky for x64, since the links are all x86, but whatever...) HDHR Prime (3 tuners) on the local LAN. Win 7 x64, up to date.
Tuner works fine with WMC. I'm just ready for a change, and love an opportunity to discontinue using an MS product.
Running nPVR after reboot game me a video feed, no audio. Changed channels and the whole thing hung. Tried installing the SAF filters, figuring it was a decoder problem, and now no video or audio.
Logs attached. Ideas? Thanks.
[ATTACHMENT NOT FOUND]
[ATTACHMENT NOT FOUND]
Operating System: Windows 8 Pro
Most current version of NPVR
tuner: HDHomeRun (no cable card)
Channels picked up in HDHomeRun interface: basic over cable free digital channels
Goal: To get NPVR to work with the new XBMC 12.0 using my HDHomeRun box.
[ATTACHMENT NOT FOUND]
When I try to start the NPVR service the above message is what pops up. I do not know what this means.
So I launch NextPVR.
I go to settings -> devices I see my HDHomeRun box.
There are 3 types shown here: ATSC, QAM, and HDHR. Running a default scan on these results in no channels found. Any help on how to fix this would be appreciated!
Notes:
I have allowed NPVR through my firewall.
I do have NPVR selected as the source in HDHomeRun configuration.
Using the HDHomeRun viewer or WMC, the channels play fine.
Just thought, in light of recent client freezes during Live TV:
I have five HDHR devices connected to my network. It would be nice if it would be possible to configure an (otherwise) NPVR client install to use the HDHR tuners directly for Live TV (since that doesn't freeze on me), but to keep the server functions all on the "server" machine - that being the updating of EPG data, scheduling recordings, doing recordings, etc.
I imagine this would add a decent amount of logic into the program for tuner priority - but with five tuners, for me it shouldn't really be an issue. At most - I would just need use of one of them at a time, and if I had to pick one to be dedicated to my client machine, that'd be fine too (I don't think I have ever used more than three tuners concurrently).
Hello all, I installed nextPVR just last week and have been pleased it's simple to use appearance, but, (there's always a but) in the last 2 days I have been getting an error message about which I haven't a clue.
As I select a programme to record I get:
"Unhandled exception has occurred in a component in your application. If you click 'Continue', the application will ignore this error and attempt to continue."
Then a short message:
"Object reference not set to an instance of an object"
Thus far, I have been clicking 'Continue' and the programme has recorded successfully. I am concerned that I have done something wrong and that it may be necessary to rectify the problem before long...any ideas anyone.
By the way, there is more information available but I cannot copy it because when this message pops up it hides my pointer over the whole programme window. It is something JIT corrections, or the like.
The other situation is one of having to re-set channels, devices and decoders every time I turn the programme on. I obviously haven't set something up correctly but have no idea what.
I did tell you I was a tyro. I have 'used' computers for years but know nothing about the inner workings, so you will have to avoid any techy language or I simply won't get it, please.
