<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On 9 October 2013 03:53, Karl Newman <span dir="ltr"><<a href="mailto:siliconfiend@gmail.com" target="_blank">siliconfiend@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div class="h5"><div class="gmail_extra"><div class="gmail_quote">On Tue, Oct 8, 2013 at 10:23 AM, Karl Newman <span dir="ltr"><<a href="mailto:siliconfiend@gmail.com" target="_blank">siliconfiend@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div>Thanks to Rich Freeman's work in Gentoo I was able to easily upgrade to 0.27 last night after holding out on 0.26. So far, so good (except for having to disable the fanart for readability and kid-friendliness reasons). I noticed the new "Recommended Programs" option in mythweb and thought I'd check it out. So I set up an account on <a href="http://myth-recommendations.aws.af.cm/" target="_blank">http://myth-recommendations.aws.af.cm/</a> (*) and entered the resulting API key. However, it throws a SQL error when I try to access the "Recommended Programs" page.<br>
<br>Backtrace here: <a href="http://pastebin.com/wxY8zy6H" target="_blank">http://pastebin.com/wxY8zy6H</a> The suspicious part is the SELECT statement, where there's a AND () just before the ORDER BY clause. In other words, there's an AND with an empty condition.<br>
<br>Here's the commit which adds this "Recommended Programs" feature to mythweb: <a href="https://github.com/MythTV/mythweb/commit/15080f2e2f80ab78fe5982405829f0ff735b337e" target="_blank">https://github.com/MythTV/mythweb/commit/15080f2e2f80ab78fe5982405829f0ff735b337e</a><br>
<br></div><div>Has anyone tried this feature yet? I'll dig into the code a little bit and see if I can find what's causing that empty AND condition.<br><br></div>* That website has a couple broken links. A few examples--the "Register" and "Genres" links in the header are broken until you add a trailing slash.<br>
<br></div>Thanks,<br><br>Karl<br></div>
</blockquote></div><br></div></div></div><div class="gmail_extra">I solved this. The problem was that I had not rated any shows so my recommendations were empty. This could be handled more gracefully, though. I put a patch here: <a href="http://code.mythtv.org/trac/ticket/11898" target="_blank">http://code.mythtv.org/trac/ticket/11898</a><span class=""><font color="#888888"><br>
<br></font></span></div><span class=""><font color="#888888"><div class="gmail_extra">Karl<br></div></font></span></div>
<br></blockquote><div>How did you add recommendations? I've tried adding them from mythweb recorded and via <a href="http://myth-recommendations.aws.af.cm/" target="_blank">http://myth-recommendations.aws.af.cm/ </a><br>
</div><div>and I still get the same error as your backtrace.<br><br></div><div>Cheers,<br></div><div><br></div><div>Anthony<br></div><div><a href="http://myth-recommendations.aws.af.cm/" target="_blank"></a></div></div><br>
</div></div>