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

catfish catfish at halfdone.com
Sat Sep 23 19:01:49 UTC 2006

>> 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.
>> DBD::mysql::st execute failed: Unknown column 'suggested' in 'field 
>> list' at tvwish line 925.
>> DBD::mysql::st fetchrow_hashref failed: Unknown column 'suggested' in 
>> 'field list' at tvwish line 675.

> I have a patch (not checked into mythtv CVS) that
> adds a 'suggested' column to the myth database
> you can fix this by commenting out or removing these lines:
>         if( $mythTVDBVersion > 1141 ) {
>             $extrafields .= ", suggested ";
>             $extraparams .= ", ? ";
>             push( @storeargs, $envir->{"suggested"} || 0 );
>             }
> I have also uploaded a version with appropriate changes to my web site.

Ah, thanks! I was wondering about that field since older backups of the 
DB didn't have that column either and thought that perhaps tvwish 
stopped working earlier then I thought. Originally I created the column 
manually but I just undid that and copied over the updated tvwish file 
from the site. Works great, thanks again.

More information about the mythtv-users mailing list