TV guide showing "to be announced" on all TV channels

[Phillyb]

I have a very strange issue with the TV guide within NextPVR.

All channels are showing "to be announced"

To my acknowledge nothing changed the system.

I use schedule direct for the source.

Any help would be greatly appreciated.

[mvallevand]

Sounds like it hasn't been updating for a while, but you would need to send in your zipped logs so we can check.

Martin

[Phillyb]

Thank you for your reply, Martin.

nextpvr running the latest Version: 5.2.3.211114.

The guides now showing no listings.

I have spoken with Schedule direct and they say it's not a problem at their end.

I have attached the logs and a picture of the guide.

Thanks again for your help and support.

[mvallevand]

Your database is corrupt.

2021-11-18 01:42:47.916 [ERROR][9] Unexpected error doing DBHouseCleaning: SQLite Error 11: 'database disk image is malformed'.

Look for any hidden sqlite file in C:\Users\Public\NPVR-Data\ if there are none and you don't want to research and use any sqlite3 tools to repair it, if you want you can send me via PM an external link to your npvr.db3 file in that folder and I will see what I can do.

Martin

[mvallevand]

I got your file from the PM.  I hope that this will work.   

Martin

[Phillyb]

Thank you Martin

That did the job.

[mvallevand]

Glad to help, hopefully the import static tables are okay. You should keep a backup copy of npvr.db3 for good measure.

For users with a malformed database that won't open in any GUI tools that might want to repair their database themself I used the sqlite3 .dump command to create a full backup. I reviewed this file for errors and removed all the EPG table records. Because of the error in the database the last line was a ROLLBACK and I had to change that to END TRANSACTION.

Martin