[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