[tbcurtis]

The Setup: Mythbuntu backend running MythTV 0.27, HDHomerun Prime Tuner, 2 Amazon FireTV 4K for the frontends, Kodi 16 with modified AdvancedSettings.xml to set the FireTV tweaks and link the video/music databases with mysql.

The Issue: TV Guide Data gets corrupted and shows the same show all day for that channel.
See attached photo of the TV Guide via link.
I've been fighting this issue about every other day. I can clear data, and re-setup everything and it works for a day or so then it gets corrupted. However, the guide is showing correctly in MythWeb. And is also shows the correct show recording in the live TV folder, all in while the guide says something totally different.

AdvancedSettings.xml

Code:

<advancedsettings>
<splash>false</splash>
<loglevel hide="true">-1</loglevel> <!-- Disables logging -->
<playcountminimumpercent>95</playcountminimumpercent>
<skiploopfilter>0</skiploopfilter> <!-- For low CPU device use 16 or higher -->
<nodvdrom>true</nodvdrom>

<network>
  <curlclienttimeout>10</curlclienttimeout>  <!-- Timeout in seconds for libcurl (http/ftp) connections -->
  <curllowspeedtime>20</curllowspeedtime>  <!-- Time in seconds for libcurl to consider a connection lowspeed -->
  <curlretries>2</curlretries>             <!-- Amount of retries for certain failed libcurl operations (e.g. timeout) -->
  <httpproxyusername></httpproxyusername>  <!-- username for Basic Proxy Authentication -->
  <httpproxypassword></httpproxypassword>  <!-- password for Basic Proxy Authentication -->
  <cachemembuffersize>157286400</cachemembuffersize>  <!-- number of bytes used for buffering streams in memory  default :20971520
   WARNING: for the bytes set here, Kodi will consume 3x the amount of RAM
   When set to 0 the cache will be written to disk instead of RAM, as of v12 Frodo -->
  <buffermode>1</buffermode>  <!-- Choose what to buffer:
    0) Buffer all internet filesystems (like "2" but additionally also ftp, webdav, etc.) (default)
    1) Buffer all filesystems (including local)
    2) Only buffer true internet filesystems (streams) (http, etc.)
    3) No buffer -->
  <readbufferfactor>20</readbufferfactor> <!-- this factor determines the max readrate in terms of readbufferfactor * avg bitrate of a video file.
     This can help on bad connections to keep the cache filled. It will also greatly speed up buffering. Default value 4.0. -->
</network>

<videodatabase>
   <type>mysql</type>
   <host>mythtv</host>
   <port>3306</port>
    <name>MyVideo</name>
   <user>user</user>
   <pass>password</pass>
</videodatabase>

<musicdatabase>
   <type>mysql</type>
   <host>mythtv</host>
   <port>3306</port>
    <name>MyMusic</name>
   <user>user</user>
   <pass>password</pass>
</musicdatabase>

<videolibrary>
   <cleanonupdate>true</cleanonupdate> <!-- Also clean library during library update -->
   <importwatchedstate>true</importwatchedstate>
   <hideallitems>true</hideallitems> <!-- removes the "*All" items from the video library -->
   <hideemptyseries>true</hideemptyseries>  <!-- hide empty series in the video library -->
</videolibrary>
<videoscanner>
   <ignoreerrors>true</ignoreerrors> <!-- Silently ignore errors while scanning videos. -->
</videoscanner>
</advancedsettings>[/code

[Chadarius]

I have the same issue on my Android device. But my install is vanilla. Also, clearing the guide cache doesn't seem to help at all. Everything is fine in the actual MythTV guide.

[tbcurtis]

Glad I'm not alone. I think I might have solved my own problem though. I linked the EPG and TV Databases to the mySQL instance and the issue went away for now. We'll see if it comes back.

Here's my entire AdvancedSettings.xml

Code:

<advancedsettings>
<splash>false</splash>
<loglevel hide="true">-1</loglevel> <!-- Disables logging -->
<playcountminimumpercent>95</playcountminimumpercent>
<skiploopfilter>0</skiploopfilter> <!-- For low CPU device use 16 or higher -->
<nodvdrom>true</nodvdrom>

<network>
  <curlclienttimeout>10</curlclienttimeout>  <!-- Timeout in seconds for libcurl (http/ftp) connections -->
  <curllowspeedtime>20</curllowspeedtime>  <!-- Time in seconds for libcurl to consider a connection lowspeed -->
  <curlretries>2</curlretries>             <!-- Amount of retries for certain failed libcurl operations (e.g. timeout) -->
  <httpproxyusername></httpproxyusername>  <!-- username for Basic Proxy Authentication -->
  <httpproxypassword></httpproxypassword>  <!-- password for Basic Proxy Authentication -->
  <cachemembuffersize>157286400</cachemembuffersize>  <!-- number of bytes used for buffering streams in memory  default :20971520
   WARNING: for the bytes set here, Kodi will consume 3x the amount of RAM
   When set to 0 the cache will be written to disk instead of RAM, as of v12 Frodo -->
  <buffermode>1</buffermode>  <!-- Choose what to buffer:
    0) Buffer all internet filesystems (like "2" but additionally also ftp, webdav, etc.) (default)
    1) Buffer all filesystems (including local)
    2) Only buffer true internet filesystems (streams) (http, etc.)
    3) No buffer -->
  <readbufferfactor>20</readbufferfactor> <!-- this factor determines the max readrate in terms of readbufferfactor * avg bitrate of a video file.
     This can help on bad connections to keep the cache filled. It will also greatly speed up buffering. Default value 4.0. -->
</network>

<videodatabase>
   <type>mysql</type>
   <host>MythTV</host>
   <port>3306</port>
    <name>MyVideo</name>
   <user>user</user>
   <pass>password</pass>
</videodatabase>

<musicdatabase>
   <type>mysql</type>
   <host>MythTV</host>
   <port>3306</port>
    <name>MyMusic</name>
   <user>user</user>
   <pass>password</pass>
</musicdatabase>

<epgdatabase>
   <type>mysql</type>
   <host>MythTV</host>
   <port>3306</port>
    <name>MyEPG</name>
   <user>user</user>
   <pass>password</pass>
</epgdatabase>

<tvdatabase>
   <type>mysql</type>
   <host>MythTV</host>
   <port>3306</port>
    <name>MyTV</name>
   <user>user</user>
   <pass>password</pass>
</tvdatabase>

<videolibrary>
   <cleanonupdate>true</cleanonupdate> <!-- Also clean library during library update -->
   <importwatchedstate>true</importwatchedstate>
   <hideallitems>true</hideallitems> <!-- removes the "*All" items from the video library -->
   <hideemptyseries>true</hideemptyseries>  <!-- hide empty series in the video library -->
</videolibrary>
<videoscanner>
   <ignoreerrors>true</ignoreerrors> <!-- Silently ignore errors while scanning videos. -->
</videoscanner>
</advancedsettings>

[tbcurtis]

It came back....And accessing the TV Guide via MySQL is super slow compared to the local sqlite3 database.

[Chadarius]

Bummer... I didn't get a chance to check mine this morning before work. It looked like most of the channels had correct programming data after 12am. This is making me wonder if I should go back to version 15.

[tbcurtis]

So I got to playing with the number of days to store. I set it to 1 and it seems to be staying current. Give that a try and see if it helps. We'll see what happens in a couple of days or so.

[waverz]

Lol In having the same exact problem on 15rc2. I did a Google search and the first post I found was from exactly a year ago, right before DST.

I think it's a daylight savings time issue. If you have your TV settings 》guide 》days to display setting set for a length of time that it runs into DST the guide is corrupt. Changing it to a shorter amount of time like 1 day fixes the issue.

I think one DST passes it will be OK to turn it back to 3 days out.

[rpcameron]

This is odd. I have a similar setup: MythTV 0.27.6, 2 HDHR Prime tuners, several Linux Kodi systems (2x Jarvis, 2x Isengard), and I haven't had any guide issues. I usually keep 2 weeks of guide on the main TV, so I've seen the DST times in the guide (11pm News running at 10pm for next week's programming), but no corruption issues.

Maybe it's my data provider, or maybe it's because I often use mythfilldatabase with --dd-grab-all ... Who knows?

[waverz]

Lol In having the same exact problem on 15rc2. I did a Google search and the first post I found was from exactly a year ago, right before DST.

I think it's a daylight savings time issue. If you have your TV settings 》guide 》days to display setting set for a length of time that it runs into DST the guide is corrupt. Changing it to a shorter amount of time like 1 day fixes the issue.

I think one DST passes it will be OK to turn it back to 3 days out.

The weird part is under listings in mythweb my guide is correct. What version of the pvr client are you using? I am using version 2.7.4 on amazon devices.

[rpcameron]

Just upgraded to 3.4.9 for Jarvis. Isengard devices are running 2.8.5.

[waverz]

Mine fixed itself sometime this afternoon.

[tbcurtis]

I have not see this issue since moving to Kodi 17 Beta 2.