<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On 22 October 2013 23:58, Karl Newman <span dir="ltr"><<a href="mailto:newmank1@asme.org" target="_blank">newmank1@asme.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div><div class="h5">On Tue, Oct 22, 2013 at 12:21 AM, Anthony Giggins <span dir="ltr"><<a href="mailto:seven@seven.dorksville.net" target="_blank">seven@seven.dorksville.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On 22 October 2013 00:51, Karl Newman <span dir="ltr"><<a href="mailto:newmank1@asme.org" target="_blank">newmank1@asme.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><div class="gmail_extra"><div class="gmail_quote">On Mon, Oct 21, 2013 at 6:16 AM, Anthony Giggins <span dir="ltr"><<a href="mailto:seven@seven.dorksville.net" target="_blank">seven@seven.dorksville.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On 11 October 2013 09:54, Anthony Giggins <span dir="ltr"><<a href="mailto:seven@seven.dorksville.net" target="_blank">seven@seven.dorksville.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div>On 10 October 2013 23:38, Karl Newman <span dir="ltr"><<a href="mailto:newmank1@asme.org" target="_blank">newmank1@asme.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div><div>On Thu, Oct 10, 2013 at 4:13 AM, Anthony Giggins <span dir="ltr"><<a href="mailto:seven@seven.dorksville.net" target="_blank">seven@seven.dorksville.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On 9 October 2013 03:53, Karl Newman <span dir="ltr"><<a href="mailto:siliconfiend@gmail.com" target="_blank">siliconfiend@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><div class="gmail_extra"><div class="gmail_quote">On Tue, Oct 8, 2013 at 10:23 AM, Karl Newman <span dir="ltr"><<a href="mailto:siliconfiend@gmail.com" target="_blank">siliconfiend@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div>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 <a href="http://myth-recommendations.aws.af.cm/" target="_blank">http://myth-recommendations.aws.af.cm/</a> (*) and entered the resulting API key. However, it throws a SQL error when I try to access the "Recommended Programs" page.<br>
<br>Backtrace here: <a href="http://pastebin.com/wxY8zy6H" target="_blank">http://pastebin.com/wxY8zy6H</a> 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.<br>
<br>Here's the commit which adds this "Recommended Programs" feature to mythweb: <a href="https://github.com/MythTV/mythweb/commit/15080f2e2f80ab78fe5982405829f0ff735b337e" target="_blank">https://github.com/MythTV/mythweb/commit/15080f2e2f80ab78fe5982405829f0ff735b337e</a><br>
<br></div><div>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.<br><br></div>* 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.<br>
<br></div>Thanks,<br><br>Karl<br></div>
</blockquote></div><br></div></div></div><div class="gmail_extra">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: <a href="http://code.mythtv.org/trac/ticket/11898" target="_blank">http://code.mythtv.org/trac/ticket/11898</a><span><font color="#888888"><br>
<br></font></span></div><span><font color="#888888"><div class="gmail_extra">Karl<br></div></font></span></div>
<br></blockquote><div>How did you add recommendations? I've tried adding them from mythweb recorded and via <a href="http://myth-recommendations.aws.af.cm/" target="_blank">http://myth-recommendations.aws.af.cm/ </a><br>
</div><div>and I still get the same error as your backtrace.<br><br></div><div>Cheers,<br></div><div><br></div><div>Anthony<br></div></div></div></div></blockquote><div> <br><br></div></div></div><div>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.<span><font color="#888888"><br>
<br></font></span></div><span><font color="#888888"><div>Karl<br></div></font></span></div></div></div>
<br></blockquote><div><br></div></div></div><div>Thanks Karl, that was the trick, I waited more then 8 hours but had to manually refresh. <br></div></div><br></div><div class="gmail_extra">Cheers,<br><br></div><div class="gmail_extra">
Anthony<br></div></div>
</blockquote></div><br></div><div class="gmail_extra">Looks like I'm still getting <br><br>"No matches found"<br>"Please rate more shows to get more results"<br><br></div><div class="gmail_extra">
I've rated almost every show on the site but still no results :(<br><br></div><div class="gmail_extra">Cheers,<br><br></div><div class="gmail_extra">Anthony<br></div></div></blockquote></div><br></div></div></div><div class="gmail_extra">
Hmm... Are you getting any shows listed on the "My Recommendations" page of <a href="http://myth-recommendations.aws.af.cm/" target="_blank">http://myth-recommendations.aws.af.cm/</a> (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.<span><font color="#888888"><br>
<br></font></span></div><span><font color="#888888"><div class="gmail_extra">Karl<br></div></font></span></div>
<br></blockquote><div><br></div><div>Yep getting shows listed in the "My Recommendations" page at <a href="http://myth-recommendations.aws.af.cm/" target="_blank">http://myth-recommendations.aws.af.cm/</a>, 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....<br>
<br></div><div>Cheers,<br><br></div><div>Anthony<br></div></div></div></div></blockquote><div><br></div></div></div><div>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).<span class="HOEnZb"><font color="#888888"><br>
<br></font></span></div><span class="HOEnZb"><font color="#888888"><div>Karl<br></div></font></span></div></div></div>
<br></blockquote></div><br></div><div class="gmail_extra">Yes metadata lookup via mythweb is working fine, I'll keep digging.<br><br></div><div class="gmail_extra">Cheers,<br><br></div><div class="gmail_extra">Anthony<br>
</div></div>