[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