[mythtv-users] SQL problem preventing 0.19 upgrade

Sim simon.hampton at freebel.net
Thu Feb 23 19:35:14 UTC 2006

Am trying to upgrade mythtv 0.19 cannot change channels.

I have a Winfast card, with PAL analogue cable TV system in europe - no set 
top box and no channel change scripts.

I compiled the source on a mandriva 2006 system, and had had no such problems 
with any previous version of mythtv.  I've pasted below the messages when I 
ran mythbackend - there is clearly an SQL problem, but I don't know how to fix 

Can anyone help?


2006-02-16 21:30:49.340 Using runtime prefix = /usr/local
2006-02-16 21:30:49.488 New DB connection, total: 1
2006-02-16 21:30:49.641 Connected to database 'mythconverg' at host: localhost
2006-02-16 21:30:49.679 Current Schema Version: 1123
Starting up as the master server.
2006-02-16 21:30:49.812 New DB connection, total: 2
2006-02-16 21:30:49.842 Connected to database 'mythconverg' at host: localhost
2006-02-16 21:30:49.983 DB Error (fetchtuningparams):
Query was:
SELECT finetune, freqid, tvformat, freqtable,        atscsrcid, commfree, 
mplexid FROM channel, videosource WHERE 
videosource.sourceid = channel.sourceid AND                                     
channum = '2' AND channel.sourceid = '1'
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'atscsrcid' in 'field list'

2006-02-16 21:30:49.983 Channel(/dev/v4l/video0): CheckChannel failed because 
it                               could not
                        find channel number '2' in DB for source '1'.
2006-02-16 21:30:50.036 New DB scheduler connection
2006-02-16 21:30:50.037 Connected to database 'mythconverg' at host: localhost
2006-02-16 21:30:50.076 mythbackend version: 0.19.20060121-2 www.mythtv.org

Celeron D @ 2.2GHz
XFX FX5200 Personal Cinema	Leadtek Winfast TV2000 XP Deluxe
Lite-on 16x DVD+-R +-RW

More information about the mythtv-users mailing list