[mythtv-users] Mythweb <-> program guide in mythfrontend

Joris Van Puyenbroeck Joris.vanpuyenbroeck at ped.kuleuven.ac.be
Mon Jul 26 04:02:14 EDT 2004


Hello,

I'm experiencing a rather strange problem: I can see listings of 
programs in Mythweb, but not in the Program guide of Mythfrontend.
Similarly, I can schedule a recording in Mythweb (and play it afterwards 
with Xine), but I cannot see the recording showing up in Mythfrontend.
the weirdest thing is I can look up a program in Mythfrontend's "program 
finder". Still, nothing shows up in the Program Guide ("unknown program").

The problem is I'm Belgian, I think :) I run a customised 
'Mythfilldatabase.sh' which fetches a pre-built "guide.xmltv" from 
http://nerdhero.org (see Belgian Mythtv Howto).
This file is read directly into the mythconverg database.
I've dumped the first 10 records of the resulting mysql 'program'-table 
in a sql-file (see attachment). What's wrong with this data? Why can't 
mythfrontend read it properly?

Thanks for any suggestions.

Joris

ps: channelID's in channel table and program table correspond
-------------- next part --------------
# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 26, 2004 at 09:56 AM
# Server version: 4.0.18
# PHP Version: 4.3.4
# 
# Database : `mythconverg`
# 

# --------------------------------------------------------

#
# Table structure for table `program`
#

CREATE TABLE program (
  chanid int(10) unsigned NOT NULL default '0',
  starttime timestamp(14) NOT NULL,
  endtime timestamp(14) NOT NULL default '00000000000000',
  title varchar(128) NOT NULL default '',
  subtitle varchar(128) NOT NULL default '',
  description text NOT NULL,
  category varchar(64) NOT NULL default '',
  category_type varchar(64) NOT NULL default '',
  airdate year(4) NOT NULL default '0000',
  stars float unsigned NOT NULL default '0',
  previouslyshown tinyint(4) NOT NULL default '0',
  title_pronounce varchar(128) NOT NULL default '',
  stereo tinyint(1) default NULL,
  subtitled tinyint(1) default NULL,
  hdtv tinyint(1) default NULL,
  closecaptioned tinyint(1) default NULL,
  partnumber int(11) default NULL,
  parttotal int(11) default NULL,
  seriesid varchar(12) NOT NULL default '',
  originalairdate date default NULL,
  showtype varchar(30) NOT NULL default '',
  colorcode varchar(20) NOT NULL default '',
  syndicatedepisodenumber varchar(20) NOT NULL default '',
  programid varchar(12) NOT NULL default '',
  PRIMARY KEY  (chanid,starttime),
  KEY endtime (endtime),
  KEY title (title),
  KEY title_pronounce (title_pronounce),
  KEY seriesid (seriesid),
  KEY programid (programid)
) TYPE=MyISAM;

#
# Dumping data for table `program`
#

INSERT INTO program VALUES (1031, 20040723090000, 20040723090500, 'Nieuws', '', '', 'nieuws', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723090500, 20040723100000, 'Julia - eine ungewöhnliche Frau', '', 'Familieserie.', 'serie', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723100000, 20040723100300, 'Nieuws', '', '', 'nieuws', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723100300, 20040723102500, 'Brisant', '', '', 'actua', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723102500, 20040723120000, 'Resan Till Melonia', '', 'Animatiefilm van Per Ahlin.', 'film', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723120000, 20040723121500, 'Nieuws', '', '', 'nieuws', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723121500, 20040723130000, 'ARD-Buffet', '', '', 'actua', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723130000, 20040723140000, 'ZDF-Mittagsmagazin', '', '', '', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723140000, 20040723141500, 'Nieuws', '', '', 'nieuws', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');
INSERT INTO program VALUES (1031, 20040723141500, 20040723150000, 'In aller Freundschaft', 'Adel verpflichtet', 'Ziekenhuisserie.', 'serie', '', '2004', '0', 0, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', '', '');


More information about the mythtv-users mailing list