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