<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/">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">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">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>