[mythtv-users] TVWish and 0.20, "Unknown column 'suggested' in 'field list'" errors

[Brad Templeton]

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.