Switching From XMLTV To SD NO Listings

[persim]

I have switched my guide info from XMLTV to SD and am getting no data in the guide now.  Emptied EPG.  Deleted the xmltv reference in the source.  Filled in all the SD login information.  Automapped the channels to use the SD listing.  Updated EPG.  It appears the be grabbing SD data but then no listings when the update is done.  Any ideas?

[sub]

On the Settings->Channels screen screen, does the 'EPG Source' column say 'Schedules Direct' for each channel?

[persim]

Yes

[mvallevand]

There seems to be multiple outputs of a new error on all your channels.

2020-06-14 18:13:07.257 [ERROR][115] Unexpected error in EPGEvent.GetListingsFromReader(): System.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.Data.Sqlite.SqliteValueReader.GetInt32(Int32 ordinal)
at NUtility.EPGEvent.GetListingsFromReader(DbDataReader reader)

Does restarting the service help?

Martin

[persim]

No.  Did full system reboot.  Emptied EPG then updated, still no listings.  Updated logs.

[mvallevand]

Can you put your npvr.db3 file on the cloud for download?

Martin

[persim]

https://drive.google.com/file/d/1MlAUAnL...sp=sharing

[mvallevand]

That scary I don't know how the EPG_EVENT seq got so big. I reset the sequence number, does this help?

Martin

[persim]

Yes! Listings are back. Thanks so much. Can you tell me what you changed, having same issue on my second Nextpvr machine.

[mvallevand]

I hope its not a bug in NextPVR but what happened is the sequence number for the event table jumped to a large number probably max 32 bit int and became negative. I reset the sequence number with sqlite3 back to a small number and deleted all the bad epg_event records.

The commands I used were

DELETE FROM EPG_EVENT
UPDATE SQLITE_SEQUENCE SET SEQ= '5000' WHERE NAME='EPG_EVENT';

Sub will need to look at the file and see if it is NextPVR code causes this. Do you do any manul manipualtion of the db3 file?

Martin