[mythtv-users] DB error reported for version 0.18.1.20050523-1

[Pieter Van Gorp]

Hey guys,
is the only way to fix this to rebuild my database?

[MythTVdocs]> $ mysql -u root < mc.sql

Cheers,
Pieter

On 2/7/06, Pieter Van Gorp <pieter at pietervangorp.com> wrote:
> Hi all, I'm running MythTV frontend & backend version
> 0.18.1.20050523-1 (from KnopMyth).
>
> As I live in Antwerp, Belgium I'm loading channel info from
> http://nerdhero.org/guide.xml.gz.
>
> I'm able to view channels in MythWeb but not in MythFrontend.
> MythBackend reports database errors such as the one shown below.
> Strangely, this error was lastly reported at the end of 2004...
> therefore I should add that my installation is an "auto-upgrade" of
> KnopMyth.  Are there any packages that I should check the version of?
> What needs to be rebuilt or so?
>
> Thanks for helping,
> Pieter Van Gorp
> --
> 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.airdate,
> program.stars, program.originalairdate,     program.category_type FROM
> program LEFT JOIN channel ON program.chanid = channel.chanid WHERE
> program.chanid = 1004 AND program.endtime >= 20060207220000     AND
> program.starttime <= 20060208000000 AND program.manualid = 0  GROUP BY
> program.starttime, channel.channum,   channel.callsign, program.title
> 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'
>