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

Wed Sep 20 23:35:55 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.

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.

[root at dvr tvwish]# pwd
/usr/share/mythtv/tvwish
[root at dvr tvwish]# perl tvwish +v -v=1 -t personal/master
[root at dvr tvwish]# perl tvwish +v -v=1 -t personal/master
Recording movie: Arsenic and Old Lace /
    on Ch. TCM at 2006-10-01 08:00:00
         A theater critic (Cary Grant) learns his two elderly
         aunts serve poisoned elderberry wine to lonely gentlemen
         callers.
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.
Skipping '' (x 2 showings) - already seen or queued
Skipping '' (x 2 showings) - already seen or queued
Skipping '' (x 2 showings) - already seen or queued
Skipping '' (x 2 showings) - already seen or queued
Skipping '' (x 1 showings) - already seen or queued
Recording movie: Kill Bill: Vol. 1 /
    on Ch. TNT at 2006-09-21 21:00:00
         Awaking from a coma, an assassin (Uma Thurman) seeks
         vengeance against her former boss and his ruthless
         gang (Lucy Liu, Vivica A. Fox).
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 643.
Skipping '' (x 1 showings) - already seen or queued
Recording movie: Kill Bill: Vol. 2 /
    on Ch. TNT at 2006-09-21 23:10:00
         Before confronting her former boss (David Carradine),
         an assassin (Uma Thurman) goes after the man's younger
         brother (Michael Madsen) and her one-eyed counterpart.
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 643.
Skipping '' (x 1 showings) - already seen or queued
Recording movie: North by Northwest /
    on Ch. TCM at 2006-09-29 02:30:00
         Mistaken identity spurs a foreign spy (James Mason)
         to pursue an innocent New Yorker (Cary Grant), all
         the way to Mount Rushmore.
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.
Recording movie: Stagecoach /
    on Ch. TCM at 2006-09-23 12:00:00
         An outlaw (John Wayne), a prostitute (Claire Trevor),
         a drunken doctor and assorted others go through Indian
         country.
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.
Recording movie: Stalag 17 /
    on Ch. TCM at 2006-09-20 20:00:00
         In a Nazi prison barracks, other POWs believe that
         a cynical American sergeant (William Holden) is an
         informer.
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.
Recording movie: The Bridge on the River Kwai /
    on Ch. TCM at 2006-09-21 00:00:00
         A British POW colonel (Alec Guinness) orders his men
         to build their Japanese captor (Sessue Hayakawa) a
         railway bridge in the jungle.
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.
Skipping '' (x 1 showings) - already seen or queued
Skipping '' (x 3 showings) - already seen or queued
Recording movie: The Green Mile /
    on Ch. FX at 2006-09-24 18:30:00
         In 1935 a head prison guard (Tom Hanks) realizes a
         man (Michael Clarke Duncan) on death row may be innocent
         and have a supernatural ability to heal others.
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 643.
Skipping '' (x 3 showings) - already seen or queued
Recording movie: The Life of Emile Zola /
    on Ch. TCM at 2006-09-22 09:00:00
         The 1800s French novelist (Paul Muni) defends Capt.
         Alfred Dreyfus (Joseph Schildkraut) against treason
         charges.
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.
Skipping '' (x 2 showings) - already seen or queued
Recording movie: The Night of the Hunter /
    on Ch. TCM at 2006-09-21 21:15:00
         A wise matron (Lillian Gish) protects children hiding
         from a corrupt preacher (Robert Mitchum).
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.
Recording movie: The Third Man /
    on Ch. TCM at 2006-09-30 20:00:00
         Visiting postwar Vienna, Austria, a pulp writer (Joseph
         Cotten) probes the death of a shady friend (Orson
         Welles).
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 643.
Skipping '' (x 1 showings) - already seen or queued
Skipping '' (x 1 showings) - already seen or queued
Recording movie: Henry V /
    on Ch. WGBX at 2006-09-23 17:30:00
         Shakespeare's king of England (Kenneth Branagh) attacks
         France and declares his love for the French king's
         daughter.
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.
Skipping '' (x 2 showings) - already seen or queued
Recording movie: The Running Man /
    on Ch. TBS at 2006-09-27 02:15:00
         A police-state scapegoat (Arnold Schwarzenegger) must
         play a TV host's (Richard Dawson) deadly game show
         for the 21st-century masses.
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.