[mythtv-users] Recommendation page in mythweb

[Anthony Giggins]

On 22 October 2013 00:51, Karl Newman <newmank1 at asme.org> wrote:

> 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
>
>
Yep getting shows listed in the "My Recommendations" page at
http://myth-recommendations.aws.af.cm/, I thought your right that they dont
match any upcoming schedules however Rules of engagement, In Plain sight,
Suits & Major Crimes I can find in my recommendations and in upcoming
schedules....

Cheers,

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