records causing interface problem

[madmanuk]

I have an issue where a few lines in the database, scheduled recordings table, cause the interface to choke.

Since this file is 10.9mb - I have removed the other tables and just left the few lines, one of which I am pretty sure is causing the issue, so you wont be able to just copy it into a NPVR setup...

I hope that is still enough for you to find the problem



It causes the interface to hiccup, making "All Recordings" and "Pending" blank.

I have reached the limit of my database ability...
It may be that Das Boot contains a German character or something?

[mvallevand]

For lack of a link to the real database I suspect the issue is NextPVR importing unicode quote/unquote characters from OTA into you EPG and they need to be fixed before scheduling. I ran my test script against your table and did see the issue that I have seen on the EPG_EVENT table.

Code:

select * from scheduled_recording
where event_details  LIKE '%'||cast(X'13' as text)||'%'
or
event_details LIKE '%'||cast(X'18' as text)||'%'
or
event_details LIKE '%'||cast(X'19' as text)||'%'
or
event_details LIKE '%'||cast(X'1c' as text)||'%'
or
event_details LIKE '%'||cast(X'1d' as text)||'%'

Martin

[madmanuk]

I had thought roughly the same, and hoped that the database records would provide sufficient information for a fix?

[mvallevand]

When sub has time to look at it I am sure it can be fixed. With a database it is so much easier to test we can load it into NextPVR and see problems right away and sub can use the debugger.

Until then you could probably write a script to fix it (I would have provided one if I had your database) or alternatively just use one of these http://www.xmltv.co.uk/feeds the 3 day would serve pretty well. There is also a 7 day trial for schedules direct that will give more data.

Martin

[sub]

I can't load a database like that here, with all the tables missing, so I haven't looked into it any further.

Where did your EPG come from?

[madmanuk]

It came from the HD Homerun Quattro.
Sorry I thought you could save you some space/trouble with the small file.
Next time it happens I will take the whole database.
I fixed the issue for my current install by deleting those 5 offending lines from the recording schedule table using SQLiteStudio.

[sub]

If it's an on going issue, I'll have you capture a 1 minute full transport stream from the device for the frequency with this channel, so I can play it back in my signal generator to reproduce the issue here.

It'll be something to do with code page of the text.

[mvallevand]

How would he do this with macos or docker?

Martin

[sub]

We'd have to use hdhomerun_config. I can't remember the exact commands off the top of my head, but I've used it for this before.