[mythtv-users] How to schedule a Power Search for Actor and Category ?

Mike Holden mythtv at mikeholden.org
Mon Jan 4 11:57:36 UTC 2010


Paul wrote:
> I'm trying to setup a schedule for actor = 'Will Smith' and category =
> 'film' (I've seen most of the fresh prince.  I found a page on the wiki
> - http://www.mythtv.org/wiki/Custom_Recording that suggests;
>
>     * Additional tables = "JOIN credits AS c ON c.chanid=program.chanid
>       AND c.starttime=program.starttime JOIN people AS p ON
>       p.person=c.person"
>     * Search phrase = "p.name = 'Will Smith' AND program.category_type =
>       'Film'"
>
> However, when i try this (from mythweb) I get a SQL error around the
> additional tables part.  My system is running on Mythbuntu Karmic (9.10)
> and Myth 0.22.  I can succesfully run it as pure SQL;

What error message are you getting?

Have you tried it from the frontend rather than mythweb?
-- 
Mike Holden

http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts



More information about the mythtv-users mailing list