[mythtv] no outputfilters field in channel table

Bart Peeters Bart.Peeters at acunia.com
Mon Dec 27 20:49:15 UTC 2004


Sorry, more problems.
I installed mythtv via apt-get debian packages.
The latest version  0.16.1

When I go in the progam guide menu in the frontend, then there is an exception.
My channel has no outputfilters field.
What is wrong? The code or the tables?


DB Error (ProgramList::FromProgram):
Query was:
SELECT program.chanid, program.starttime, program.endtime,     program.title, program.subtitle, program.description,     program.category, channel.channum, channel.callsign,channel.name, program.previouslyshown, channel.commfree,     channel.outputfilters, program.seriesid, program.programid,     program.stars, program.originalairdate FROM program LEFT JOIN channel ON program.chanid = channel.chanid WHERE program.chanid = 1000 AND program.endtime >= 20041227213000     AND program.starttime <= 20041227233000  GROUP BY program.starttime, channel.channum,   channel.callsign ORDER BY program.starttime, channum + 0 LIMIT 1000
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'channel.outputfilters' in 'field list'

 channel | CREATE TABLE `channel` (
  `chanid` int(10) unsigned NOT NULL default '0',
  `channum` varchar(5) NOT NULL default '',
  `freqid` varchar(5) NOT NULL default '',
  `sourceid` int(10) unsigned default NULL,
  `callsign` varchar(20) default NULL,
  `name` varchar(20) default NULL,
  `icon` varchar(255) default NULL,
  `finetune` int(11) default NULL,
  `videofilters` varchar(255) default NULL,
  `xmltvid` varchar(64) default NULL,
  `recpriority` int(10) NOT NULL default '0',
  `contrast` int(11) default '32768',
  `brightness` int(11) default '32768',
  `colour` int(11) default '32768',
  `hue` int(11) default '32768',
  `tvformat` varchar(10) NOT NULL default 'Default',
  `commfree` tinyint(4) NOT NULL default '0',
  `visible` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`chanid`)
) TYPE=MyISAM |
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20041227/86c567f1/attachment.html


More information about the mythtv-dev mailing list