Libreelec 11.0 Alpha NextPVR Guide disappears

[statomm]

I recently purchased a new computer to run Libreelec but have to run the Alpha version 11.0 since 10.0 will not boot (needs a newer kernel). I am having problems with the nextPVR client epg disappearing after a few seconds.

Running Libreelec 11.0Alpha and nextPVR client 20.3.0.2

[mvallevand]

Assuming you can connect to the backend on a static IP LE11 should be able to with no issue.

As explained on the wiki https://github.com/sub3/NextPVR/wiki/get-help I need the zipped NextPVR logs and the debug Kodi logs. On LE it is easiest just pass the URL from running pastekodi However debug logging might not be set so the best way is to do this is storing this as advancedsettings.xml in the /storage/.kodi/userdata folder

Code:

<advancedsettings>
    <loglevel hide="false">1</loglevel>
</advancedsettings>

Martin

[statomm]

Here are the logs. 

Just to clarify live TV viewing works and the guide always shows up in the web interface, its just when using the Kodi next pvr client the guide will disappear and you will only see the channels with no guide data (ie tv shows).

[mvallevand]

You PVR database looks corrupt. Go to the Settings PVR and clear the data.

I also noticed a Kodi issue with one of the database files

2022-11-04 14:45:13.917 T:977 error <general>: SQL: [Epg16.db] SQLite error SQLITE_ERROR (table epgtags has no column named sParentalRatingCode)

That column certainly is supposed to be there and the issue is not related to NextPVR. I am not sure how you upgraded to Nexus but that doesn't look good. I suggest removing that file and letting Kodi recreate it. You can rename it if your prefer.

systemctl stop kodi
rm /storage/.kodi/userdata/Database/Epg16.db
systemctl start kodi

As the first user of the new package, how did you find the installation of the server?

Martin

[mvallevand]

Actually I see how you updated, I will pass on the information to Team Kodi. Do you mind if I share your file?

Code:

2022-11-04 14:43:59.852 T:937     error <general>: SQL: [Epg16.db] SQLite error SQLITE_ERROR (duplicate column name: iChannelGroup)
                                                   Query: ALTER TABLE savedsearches ADD iChannelGroup integer; (duplicate column name: iChannelGroup)
2022-11-04 14:43:59.862 T:937     error <general>: Exception updating database Epg16 from version 13 to 16
2022-11-04 14:43:59.862 T:937     error <general>: Error updating database Epg16 from version 13 to 16
2022-11-04 14:43:59.865 T:937      info <general>: Old database found - updating from version 13 to 16
2022-11-04 14:43:59.865 T:937     debug <general>: Copying from Epg13.db to Epg16 at /storage/.kodi/userdata/Database/
2022-11-04 14:44:00.417 T:903     debug <general>: CDRMUtils::DrmFbGetFromBo - using modifier: INTEL_Y_TILED
2022-11-04 14:44:01.233 T:937      info <general>: Attempting to update the database Epg16 from version 13 to 16
2022-11-04 14:44:01.233 T:937     debug <general>: Cleaning indexes from database Epg16.db at /storage/.kodi/userdata/Database/
2022-11-04 14:44:01.235 T:937     debug <general>: Cleaning views from database Epg16.db at /storage/.kodi/userdata/Database/
2022-11-04 14:44:01.235 T:937     debug <general>: Cleaning triggers from database Epg16.db at /storage/.kodi/userdata/Database/
2022-11-04 14:44:01.236 T:937     error <general>: SQL: [Epg16.db] SQLite error SQLITE_ERROR (duplicate column name: iChannelGroup)

[statomm]

I cleared all the PVR data in kodi and deleted the database Epg16.db but the guide still disappears.

One thing I should have included is, this happened with both (computer 1) a clean install of Libreelec 11 and installing just the server and client and (computer 2, this one) installed Libreelec11 then restored my Libreelec 10 backup file then installed the server and client for NextPVR.

So if you want I have a second computer just like this one (running libreelec) I can do a clean install on and get the logs, it will just not be until saturday before I could do that.

Installing the server was very easy and uneventful.  Just had to enable install from unknown sources in the settings.

[mvallevand]

Yes now it is failing because of this Kodi PR https://github.com/xbmc/xbmc/pull/20442

SQL: Field not found: sParentalRatingCode

I can give you a sqlite3 command to create it sParentalRatingCode varchar(64) if you want.

Martin

[statomm]

Sure I'll give it a try.

[mvallevand]

I would stop Kodi and then replace Epg16.db with the file in the attached.https://forums.nextpvr.com/

As for the install, I guess you didn't get the package from the LibreElec repo.  You might want to update to that one.

If you want to experiment with sqlite3 first you would stop Kodi and then run the missing piece from the Kodi build.

Code:

sqlite3 /storage/.kodi/userdata/Database/Epg16.db
ALTER TABLE epgtags ADD sParentalRatingCode varchar(64);
.exit

Martin

[statomm]

I tried the sqllite3 command and it did not fix the problem.

I replaced the Epg16.db with the one you provided and it is working now (the epg doesn't disappear).

On post #7 you asked if you could share my logs with Team Kodi, I don't have a problem with you sharing the logs.

I got the install image of Libreelec11 from their website:
https://test.libreelec.tv/11.0/Generic/Generic/