[mythtv-users] SQL problem preventing 0.19 upgrade
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):
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