[mythtv-users] Recommendation page in mythweb

[Phil Bridges]

On Tue, Oct 8, 2013 at 1:23 PM, Karl Newman <siliconfiend at gmail.com> wrote:

> 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
>
>
>
Where is this option in MythWeb?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131009/655d2fb8/attachment.html>