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

Mike Holden mythtv at mikeholden.org
Mon Jan 11 16:36:58 UTC 2010


Paul wrote:
> Mike Holden wrote:
>> 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?
>>
> I ahven't tried this from a frontend (I find setting up searches easier
> via mythweb).  From mythweb I get a (very long) SQL error message
>
> Error:
> There is an error in your custom SQL query:
>
>                             [last_query] => SELECT NULL FROM program,
> channel, JOIN credits AS c ON c.chanid=program.chanid AND
> c.starttime=program.starttime JOIN people AS p ON p.person=c.person
> WHERE p.name = 'Will Smith' AND program.category_type = 'Film'

I would suggest in the first instance that this is a bug in mythweb. It is inserting a
comma before the "additional tables" string which shouldn't be there.

I wrote that wiki entry, and I know it works correctly, at least in 0.21, but can't
speak for 0.22 as I haven't upgraded yet. I also never tried it in mythweb, but I know
it works correctly on a standard frontend, because I use several variations on it for my
own searches!
-- 
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