[mythtv-users] Re: MythTV CVS & DataDirect - Success!

Robert Kulagowski bob at smalltime.com
Wed May 26 14:40:38 EDT 2004


> Yeah, this is weird.  It won't work for me, either, but the UPDATE 
> syntax is correct, according to the mysql docs.  I get the following error:
> 
> mysql> UPDATE channel,channel_copy SET channel.icon=channel_copy.icon 
> WHERE channel.callsign=channel_copy.callsign;
> 
> ERROR 1064: You have an error in your SQL syntax near 'channel_copy SET 
> channel.icon=channel_copy.icon WHERE channel.callsign=channel_c' at line 1
> 
> Anyone have success with this?

You'll have more success if you use the appropriate commands for your 
mysql version.  If you're not running MySQL v4, then don't use the 
one-line version.  Check the HOWTO.



More information about the mythtv-users mailing list