[mythtv] Re: debian package mythtv-database 0.16-1

[Matt Zimmerman]

On Tue, Dec 28, 2004 at 01:55:49PM +0100, Bart Peeters wrote:
> from deb http://dijkstra.csh.rit.edu/~mdz/debian unstable mythtv
> When I install this package, a table should be created in the mythtv db.
> I think is't a wrong table. In table channel, there is no outputfilters
> field, and the mythfrontend 0.16-1 need this field. 

The package does not create database tables anymore; this is all handled
within mythtv.

> 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'

-- 
 - mdz