<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Mike Holden wrote:
<blockquote
cite="mid:d3f54405a8164a63022b55b1f2971f7e.squirrel@www.mikeholden.org"
type="cite">
<pre wrap="">Paul wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Mike Holden wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Paul wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
- <a class="moz-txt-link-freetext" href="http://www.mythtv.org/wiki/Custom_Recording">http://www.mythtv.org/wiki/Custom_Recording</a> 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;
</pre>
</blockquote>
<pre wrap="">What error message are you getting?
Have you tried it from the frontend rather than mythweb?
</pre>
</blockquote>
<pre wrap="">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'
</pre>
</blockquote>
<pre wrap=""><!---->
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!
</pre>
</blockquote>
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 ?<br>
<br>
Thanks for the help...<br>
<br>
Paul.<br>
</body>
</html>