[mythtv-users] Recommendation page in mythweb

[Karl Newman]

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
http://myth-recommendations.aws.af.cm/ (*) and entered the resulting API
key. However, it throws a SQL error when I try to access the "Recommended
Programs" page.

Backtrace here: http://pastebin.com/wxY8zy6H  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.

Here's the commit which adds this "Recommended Programs" feature to
mythweb:
https://github.com/MythTV/mythweb/commit/15080f2e2f80ab78fe5982405829f0ff735b337e

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.

* 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.

Thanks,

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131008/2698c9bf/attachment.html>