Some channel guide data gone, EPG update problem

[4zm4r3d02]

The main page of the NPVR web interface shows no recordings pending, although there should be some there. Four of the channels show (no listings) in the guide. When I go to Settings>Guide and press "Update EPG", at the end it displays the message "EPG Update complete. [0 inserted, 0 updated, 0 skipped]". Pressing "Empty EPG" doesn't seem to do anything. I tried stopping and restarting the NPVR service and rebooting the pc but that didn't help. Channels still seem to be mapped and associated with SD lineup. Everything was working yesterday, don't know what happened. Logs attached.

[mvallevand]

You appear to have a corrupt database. If you empty the epg database does that help?

Martin

[4zm4r3d02]

You appear to have a corrupt database.  If you empty the epg database does that help?

Martin

Pressing the "Empty EPG" button in the web interface doesn't seem to do anything. Is there another way to empty it?

[mvallevand]

After empty did you try an update?

[4zm4r3d02]

After empty did you try an update?

Yes.

[mvallevand]

Could you send he new logs to see if it is still corrupt.

Martin

[4zm4r3d02]

Could you send he new logs to see if it is still corrupt.

Martin

Done.

[mvallevand]

Yes it is. Stop the server and look to see if there are any files in the data folder that look odd including hidden files.

Martin

[4zm4r3d02]

Yes it is.  Stop the server and look to see if there are any files in the data folder that look odd including hidden files.

Martin

Code:

Directory of C:\Users\Public\NPVR-data 2019-12-18  08:55 PM    <DIR>          . 2019-12-18  08:55 PM    <DIR>          .. 2019-12-18  07:43 PM    <DIR>          logs 2019-08-23  09:30 PM    <DIR>          media 2019-11-07  06:48 PM    <DIR>          scripts 2019-12-02  11:07 PM    <DIR>          thumbs 2019-08-23  09:30 PM    <DIR>          web 2019-12-12  09:10 AM              168 clientstore-local.xml 2019-12-18  07:58 PM            18,524 config.xml 2019-12-18  07:58 PM            18,524 config.xml.old 2019-12-13  12:11 AM            18,524 config-old.xml 2019-12-18  07:59 PM        7,110,656 npvr.db3 2019-12-18  08:55 PM            91,061 recording-backup.xml 2019-12-18  07:59 PM            91,061 recording-backup.xml.1 2019-12-18  07:54 PM            91,061 recording-backup.xml.2 2019-12-18  08:55 PM            4,046 recurring-backup.xml 2019-12-18  07:59 PM            4,046 recurring-backup.xml.1 2019-12-18  07:54 PM            4,046 recurring-backup.xml.2

There don't appear to be any hidden files in there.

[mvallevand]

Do you know how to use sqlite tools to try and repair the database? If not put your database on a cloud drive server and I will see if it can be repaired.

Martin