[mythtv-users] 0.19 : Unknown column 'atscsrcid' ????

Sim simon.hampton at freebel.net
Fri Feb 17 18:41:45 UTC 2006


Am trying to upgrade but I can't get mythtvthen to 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 
it.

Simon

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, 
mplexi                              d 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

-- 
--------------------
EZ-Buddie2: 
http://www.ecs.com.tw/ECSWeb/Products/ProductsDetail.aspx?MenuID=84&LanID=0&DetailID=444&DetailName=Specification
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