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

[Paul]

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:

check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'JOIN credits AS c ON c.chanid=program.chanid 
AND c.starttime=program.starttime J' at line 1 [#1064]

Backtrace
Array
(
    [0] => Array
        (
            [file] => 
/usr/share/mythtv/mythweb/classes/Database/Query/mysql.php
            [line] => 85
            [function] => error
            [class] => Database
            [object] => Database_mysql Object
                (
                    [dbh] => Resource id #18
                    [error] => You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'JOIN credits AS c ON c.chanid=program.chanid 
AND c.starttime=program.starttime J' at line 1 [#1064]
                    [err] => You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right 
syntax to use near 'JOIN credits AS c ON c.chanid=program.chanid AND 
c.starttime=program.starttime J' at line 1
                    [errno] => 1064
                    [last_sh] => Database_Query_mysql Object
                        (
                            [dbh] => Resource id #18
                            [query] => Array
                                (
                                    [0] => 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'
                                )

                            [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'
                            [warnings] => Array
                                (
                                )

                            [num_args_needed] => 0
                            [num_rows] =>
                            [affected_rows] => -1
                            [insert_id] => 0
                            [db] => Database_mysql Object
 *RECURSION*
                            [sh] =>
                        )

                    [fatal_errors] =>
                    [query_count] => 156
                    [query_time] => 0.0633826255798
                    [global_name] => db
........
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100109/653f0982/attachment.htm>