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

Paul paul at paulhurley.co.uk
Mon Jan 11 17:56:50 UTC 2010


Mike Holden wrote:
> 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!
>   
Right, I finally got around to testing it in Myth Frontend, and yes, it 
does work (sorry for the delay).  So it's a mythweb bug.  Should I 
report the bug somewhere ?

Thanks for the help...

Paul.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100111/dcaa7af5/attachment.htm>


More information about the mythtv-users mailing list