[mythtv-users] Recommendation page in mythweb

[Anthony Giggins]

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

> On Tue, Oct 22, 2013 at 12:21 AM, Anthony Giggins <
> seven at seven.dorksville.net> wrote:
>
>>
>>
>>
>> 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
>>
>
> Hmm... Well I'm not sure I can help you. The person responsible for the
> recommendation portion is Rob Smith (kormoc) but I don't know that I've
> seen him on this list. The only other thing I could suggest is maybe your
> system (PHP, apache, firewall, etc.) is not allowing the mythweb php
> scripts to retrieve the data from the myth-recommendations website. But if
> metadata lookup through mythweb works, then that's probably not the cause
> (although I'm not sure they use the same methods to retrieve data).
>
> Karl
>
>
Yes metadata lookup via mythweb is working fine, I'll keep digging.

Cheers,

Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131023/09aef5ea/attachment-0001.html>