[mythtv-users] Recommendation page in mythweb

[Anthony Giggins]

On 11 October 2013 09:54, Anthony Giggins <seven at seven.dorksville.net>wrote:

>
>
>
> On 10 October 2013 23:38, Karl Newman <newmank1 at asme.org> wrote:
>
>> On Thu, Oct 10, 2013 at 4:13 AM, Anthony Giggins <
>> seven at seven.dorksville.net> wrote:
>>
>>> On 9 October 2013 03:53, Karl Newman <siliconfiend at gmail.com> wrote:
>>>
>>>> On Tue, Oct 8, 2013 at 10:23 AM, 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
>>>>>
>>>>
>>>> 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: http://code.mythtv.org/trac/ticket/11898
>>>>
>>>> Karl
>>>>
>>>> How did you add recommendations? I've tried adding them from mythweb
>>> recorded and via http://myth-recommendations.aws.af.cm/
>>> and I still get the same error as your backtrace.
>>>
>>> Cheers,
>>>
>>> Anthony
>>>
>>
>>
>> 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.
>>
>> Karl
>>
>>
> Thanks Karl, that was the trick, I waited more then 8 hours but had to
> manually refresh.
>
> Cheers,
>
> Anthony
>

Looks like I'm still getting

"No matches found"
"Please rate more shows to get more results"

I've rated almost every show on the site but still no results :(

Cheers,

Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131021/8170e823/attachment.html>