[mythtv-users] what is mythcommflag doing?

[Chris Pinkham]

> I'm running gentoo with the 0.12 ebuild.
> 
> $ mythcommflag --all
> 
> MythTV Commercial Flagging, started at Thu Nov 20 23:57:10 2003
> 
> Flagging commercial breaks for:
> ChanID  Start Time      Title                                         
> Breaks
> ------  --------------  --------------------------------------------  
> ------
> No program data exists for channel 1009 at 20030419200000
> No program data exists for channel 1009 at 20030426200000
> No program data exists for channel 1022 at 20030428003000
> <snip>lots more</snip>
> 
> If I look in my recordings directory there is a corresponding file 
> name. If I look in the database in the recorded table,  this 
> corresponds to:
> |   1009 | 20030419200000 | 20030419203000 | Mr. Bean                   
>                      | Mr. Bean                        | An exam; 
> sneezing; swim trunks.                                                  
>                      | sagan     | NULL     |       0 | NULL    | NULL   
>    |          0 |

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.

-- 

Chris