[mythtv-users] Mythbackend gives sql error
Maarten van Ingen
nhimf at nhimf.org
Sun May 9 15:49:07 EDT 2004
Hi,
I have a problem to have mythtv getting to run.
I have setup everything as needed (i think :P ), but when i want to run
mythbackend i get an sql error.
Here is the output of mythbackend:
# mythbackend -v
Starting up as the master server.
2004-05-09 21:10:28 DVB#0 Using DVB card 0, with frontend DST SAT.
DB Error (GetChannelOptions - Channel Check):
Query was:
SELECT serviceid, networkid, providerid, transportid, frequency,
inversion, symbolrate, fec, polarity, diseqc_type, diseqc_port,
lnb_lof_switch, lnb_lof_hi, lnb_lof_lo FROM dvb_channel, dvb_sat WHERE
dvb_channel.satid=dvb_sat.satid AND chanid='20'SELECT satid FROM
dvb_channel WHERE chanid='20'
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax near 'SELECT satid FROM dvb_channel
WHERE chanid='20'' at line 1
2004-05-09 21:10:30 DVB#0 ERROR - Could not find dvb tuning parameters
for channel 20 with id 20.
2004-05-09 21:10:30 DVB#0 ERROR - Failed to get channel options for
channel 20.
2004-05-09 21:10:30 mythbackend version: 0.14.20040123-1 www.mythtv.org
2004-05-09 21:10:30 Enabled verbose msgs : important general
2004-05-09 21:10:32 Found changes in the todo list.
This suggests an error in the sql statements (2 sql statments in 1). And
because of that mythbackend cannot find the standard channel.
Before trying to run mythbackend, i have used mythsetup to setup stuff
and mythfilldatabase --manual to setup the channels.
Can anybody tell me how to solve this problem?
My specs are:
Gentoo running the 2.6.5 kernel
A pinnacle pctv sat ci card.
Mythtv version 0.14 (emerged from gentoo)
an asus a7v333 motherboard with an athlon xp 2100+
Mysql 3.23.57 (also emerged from gentoo)
Maarten van Ingen
ps. If i use xine i can see the free-to-air channels so the dvb-s card
works.
More information about the mythtv-users
mailing list