[mythtv] Recent scheduler.cpp changes introduced a bug.

J. Donavan Stanley jdonavan at jdonavan.net
Mon Apr 19 18:11:08 EDT 2004


Bruce Markey wrote:

>
> Could you try these queries from the mysql prompt? The expectation
> is that the first one may fail but the second should succeed.
>
> UPDATE record,channel SET record.station=channel.callsign
> WHERE record.station='' AND record.chanid=channel.chanid;
>
> UPDATE record LEFT JOIN channel ON (record.chanid=channel.chanid) SET 
> record.station=channel.callsign WHERE record.station='';

Both of these fail :/

ERROR 1064: You have an error in your SQL syntax near 'LEFT JOIN channel 
ON (record.chanid=channel.chanid) SET record.station=channel.c' at line 1



More information about the mythtv-dev mailing list