[mythtv-users] How to schedule a Power Search for Actor and Category ?
Michael T. Dean
mtdean at thirdcontact.com
Sat Jan 9 23:30:47 UTC 2010
On 01/09/2010 04:44 PM, 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
>>> * Search phrase = "p.name = 'Will Smith' AND program.category_type =
>>> 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
> There is an error in your custom SQL query:
How is that easier than using the frontend (especially since it doesn't
Try the frontend to make sure they /can/ work on your system/with its
configuration. Then, if so, look into MythWeb.
More information about the mythtv-users