[mythtv-users] Recommendation page in mythweb

[Karl Newman]

On Mon, Oct 21, 2013 at 6:16 AM, Anthony Giggins <seven at seven.dorksville.net
> wrote:

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

Hmm... Are you getting any shows listed on the "My Recommendations" page of
http://myth-recommendations.aws.af.cm/ (after you click the Refresh link)?
If you are, then possibly the recommended shows don't have any matching
upcoming episodes, or maybe there's a communication error between your
mythweb server and the recommendations website server. If you have NO shows
listed on the "My Recommendations" page, I would guess it's because you
rated every show so it doesn't have anything to suggest. I noticed that if
I rated a show as "Liked", it would NOT suggest that show to me, even if I
had no recordings of it. You could try un-rating some shows (just click the
same rating again to turn it gray again) and see if that affects it.

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131021/1bbddd27/attachment.html>