[mythtv-users] what is mythcommflag doing?

Chris Pinkham cpinkham at bc2va.org
Fri Nov 21 18:53:15 EST 2003


> >Try running the following query:
> >
> >SELECT recorded.chanid,starttime,endtime,title,subtitle,
> >		description,channel.channum,channel.callsign,
> >		channel.name
> >	FROM recorded,channel
> >	WHERE recorded.chanid = 1009
> >		AND starttime = 20030419200000
> >		AND recorded.chanid = channel.chanid;
> >
> >That's the query that gets run to check to retrieve program info from
> >the DB when you're running mythcommflag.

> Hmm. I don't really understand this. If I do it exactly as you have 
> written I get an empty set. But why do you want me to do the
> AND recorded.chanid = channel.chanid;
> line?

Try running this query instead and see if it returns any rows:

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;


-- 

Chris



More information about the mythtv-users mailing list