[killachaos]

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.

[nickr]

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?

[killachaos]

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.

[killachaos]

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

1. 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).
   
2. 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)
   
3. 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.

[nickr]

Well I never would have found that!