[mythtv-users] what is mythcommflag doing?

[Chris Pinkham]

> Here is what I get:
> 
> mysql> SELECT 
> recorded.chanid,starttime,endtime,title,subtitle,description,channel.channum,channel.callsign,channel.name
>     -> FROM recorded
>     -> LEFT JOIN channel ON recorded.chanid = channel.chanid
>     -> WHERE chanid = 1009
>     -> AND starttime = 20030419200000;
> ERROR 1052: Column: 'chanid' in where clause is ambiguous
> 
> Thanks,
> Cedar

Change "WHERE chanid" to "WHERE record.chanid" and see if that works.

If so I can fix CVS so this won't happen to you or anyone else that
changes chanids for any reason.

-- 

Chris