EPG Timeline Empty - Printable Version

EPG Timeline Empty - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: PVR & Live TV Support (https://forum.kodi.tv/forumdisplay.php?fid=167)
+---- Forum: MythTV (https://forum.kodi.tv/forumdisplay.php?fid=170)
+---- Thread: EPG Timeline Empty (/showthread.php?tid=178804)

EPG Timeline Empty - killachaos - 2013-11-24

I've recently installed XBMC (Frodo Stable) + MythTvPVR (dev e6e61904c714ae6075c8c7fbadfa9a20b9115724) on my OS X 10.7 Lion Machine. Mostly everything works thus far and I can import the channels from the MythTv Backend to XBMC. However the EPG Timeline is empty and it isn't clear how to populate it. Currently the MythTv Frontend links with SchedulesDirect but I'm unsure how to get this functionality into XBMC.

RE: EPG Timeline Empty - nickr - 2013-11-25

It should populate from the backend if everything is set up right. Not in front of mine now, but what options do you have configured?

RE: EPG Timeline Empty - killachaos - 2013-11-25

Not sure which options you were referring to so I will list everything (skipping some stuff that is default)
MythTv Settings:

Code:
CableTV Info:

Comcast - Bay Area

MythTv Settings:

1.) General

  [x] Listen on Link-Local addresses 

  Security Pin: 0000 

  TV Format : NTSC 

  VBI Format: NTSC Closed caption

  Channel Freq. Table : us-bcast

  Everyother setting: All default

2.) Capture Cards

  3x HD HomeRun PRIME

  Recording Options Default, except Max Records set to 1

3.) Recording Profiles

  Unchanged 

4.) Video Sources

  Video Source Name : Comcast Source

  Listings Grabber : NorthAmerica (SchedulesDirect.org)

  [User ID and Pass for SchedulesDirect + Membership]

  Perform EIT scan unchecked

  Channel Freq Table: unchecked

  Network ID: -1

5.) Input Connections

  3x HD HomeRun -> comcast Source

  Use quicktuning: Never

  [Channel's Fetched, Starting Channel : 1]

  Input Priority : 0

  Schedule Order : 1

  Input group 1 & 2 : Generic

6.) Channels

  Channels are Listed and Icons are downloaded (and also show up in XBMC)

7.) Storage Directive

  Default: /path/to/my/ssd

8.) System Events:

  Nothing

XBMC

Code:
MythTv: (V. https://github.com/fetzerch/xbmc-pvr-addons/commit/e6e61904c714ae6075c8c7fbadfa9a20b9115724), 1.6.13 IIRC)

  Myth Backend IP : 127.0.0.1

  Backend Port : etc..

  User/Pass : mythtv/password (works, as far as I can tell)

  Database name is default

  Live TV enabled

  Live TV allowed to move scheduled shows

  Conflict: Prefer Live TV

  Template Provider: MythTv

  Enable Demuxing set to false

Code:
XBMC (Frodo, OSX, Stable (as in downloaded from xbmc.org homepage))

TV Settings

General:

  Enabled : true

  Synch with backends : True

  Always use backend channel order: true

  Use backend channel numbers : true

Menu/OSD:

  [x] Show channel info

  [x] Auto hide channel info

EPG:

  Default Window: Timeline

  Days: 2

  EPG update: 120min

  Prevent EPG : false

  Do not store EPG : true (this was originally false I changed it to see if it would fix things)

  Do not show no info available: true

I think thats all the relevant info. I'll also try poking around in mysql.

For the record the EPG in MythFrontend works.

After poking around in the logs my error could be related to:

Code:
20:54:29 T:140735219620192   DEBUG: CGUIEPGGridContainer - SetStartEnd - start=11/25/2013 4:30:00 AM end=12/31/1969 11:30:00 PM

20:54:29 T:140735219620192   ERROR: CGUIEPGGridContainer - UpdateItems - invalid start and end time set

Not sure how to fix it.

RE: EPG Timeline Empty - killachaos - 2013-11-25

Fixed it finally. After digging in the code finally figured out the problem. Explaining for Google's sake.

XBMC Frodo, Mac OS X Lion, EPG Electronic Programming Guide Empty

In setting up MythTv you have to import the timezones as explained here http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables (MythTV will not work if you don't do this).
In my version of mysql (installed from brew)

Code:
Server version: 5.6.14 Source distribution
There is a bug in mysql_tzinfo_to_sql that causes it to return bad SQL, which will cause half your timezones to be loaded. (Which it explained why MythTv and MythFrontend works)
Error is :
Code:
ERROR 1406 (22001) at line 38408: Data too long for column 'Abbreviation' at row 1
(http://bugs.mysql.com/bug.php?id=68861)
This causes the UTC timezone not to be loaded which causes problems for the mythtv addon.

Quick Fix:
On OSX instead of running the command listed in the mythtv wiki run this:

Code:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

run this instead:

Code:
mysql_tzinfo_to_sql /usr/share/zoneinfo | sed "s/'Local time zone must be set--see zic manual page'/'UNSET'/g" | mysql -u root -p mysql

What this does is fixes the SQL that comes from mysql_tzinfo_to_sql by replacing the offending data with 'UNSET'. After this is done, run mythfill again and restart xbmc and the guide should work.

Re: EPG Timeline Empty - nickr - 2013-11-25

Well I never would have found that!