[mythtv-users] Mythbackend gives sql error

Maarten van Ingen nhimf at nhimf.org
Sun May 9 15:49:07 EDT 2004


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 

More information about the mythtv-users mailing list