<div dir="ltr"><br><div class="gmail_extra"><div class="gmail_quote">On Tue, Oct 8, 2013 at 1:23 PM, 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:0 0 0 .8ex;border-left:1px #ccc solid;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>
<br><br></blockquote><div><br></div><div>Where is this option in MythWeb? </div></div></div></div>