<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Thu, Oct 10, 2013 at 4:13 AM, Anthony Giggins <span dir="ltr"><<a href="mailto:seven@seven.dorksville.net" target="_blank">seven@seven.dorksville.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><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><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><font color="#888888"><br>
<br></font></span></div><span><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></div></div></blockquote><div> <br><br></div><div>On the myth-recommendations website. I had to rate a few shows before it would work. Note that there is a bit of delay so it doesn't work immediately. You can check the "My Recommendations" link to see if it has anything listed. If it's empty, you'll continue to have the problem. You can force a refresh of that My Recommendations page, which I think also makes the mythweb page work.<br>
<br></div><div>Karl<br></div></div></div></div>