[mythtv-users] TVWish and 0.20, "Unknown column 'suggested' in 'field list'" errors
Brad Templeton
brad+myth at templetons.com
Thu Sep 21 19:04:17 UTC 2006
On Wed, Sep 20, 2006 at 07:35:55PM -0400, catfish wrote:
> Has anyone attempted to use TVWish under Mythtv 0.20? Running FC4 and
> 0.20.20060828-3 (latest atrpm rpm) upgraded from 0.19. TVWish wasn't
> changed from the 0.19 install.
>
> I'm getting the following errors on each movie it wants to add, I assume
> it just need an update/patch for mythtv 0.20. TVWish site seems to only
> have the last update from July 7th which is what I have setup (per the
> changes file). I'm not using the suggested features, mostly the
> goodmovies.txt list it comes with.
>
> I've done some minor perl stuff so perhaps I can patch it but I'm not
> that familiar with backend and db schema related so if anyone has some
> thoughts.
>
My apology. I have a patch (not checked into mythtv CVS) that
adds a 'suggested' column to the myth database so that suggestions can
be more reliably told from human requested recordings. The
schema number got high enough that you started using it.
I am altering how it is enabled, you can fix this by commenting out
or removing these lines:
if( $mythTVDBVersion > 1141 ) {
$extrafields .= ", suggested ";
$extraparams .= ", ? ";
push( @storeargs, $envir->{"suggested"} || 0 );
}
Around like 1180.
The mythtv database schema version system does not really support
parallel development of code that adds features to the database.
(And I've been slow.)
I have also uploaded a version with appropriate changes to my web site.
More information about the mythtv-users
mailing list