[mythtv-users] Mythbackend gives sql error

[Maarten van Ingen]

I haven't upgraded anything, cause the linux installation is almost 
brand new.
I have tried this with mysql 4.0.18, but i got errors there. That's why 
i deinstalled it and installed mysql3. (and reinstalled qt cause it was 
built with mysql4 support)
With mysql4 i got a couple of qmysql3 errors and mythtv told me that i 
had to look at the mysql versions.

I know that the query is wrong, but i didn't touch the sources, maybe 
it's a bug created by gentoo so i'll report it there.

But if anyone has an idea how to solve it, it would be very nice.

If anyone has an idea to get my CAM working without mythtv so i can 
watch the scambled channels with  xine (as a temporary workaround) it 
would be nice too.

Maarten van Ingen

Michael Gargiullo wrote:

>On Sun, 2004-05-09 at 15:49, Maarten van Ingen wrote:
><snip>
>  
>
>># 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
>>    
>>
><snip>
>
>Did you recently upgrade something?
>
>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'
>>    
>>
>
>This query isn't a syntacticly correct SQL query, This part in
>particular:
> WHERE 
>  
>
>>dvb_channel.satid=dvb_sat.satid AND chanid='20'(There should be a condition here) SELECT satid FROM 
>>dvb_channel WHERE chanid='20'
>>    
>>
>
>The error may displayed may not be the entire sql query, but from what I
>see, this is a generic MySQL error due to the formatting of the
>sub-query.
>
>Disclaimer.  I'm new to Mythtv, and haven't looked at the source yet. 
>This error may be covered in an FAQ or something like it.
>
>-Mike
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>