[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