[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mythtv-dev
Subject:    Re: [mythtv] problem with favorites in mythweb
From:       gludie <gludie () chello ! at>
Date:       2011-01-29 20:37:48
Message-ID: 1296333468.6842.10.camel () dgtv-desktop
[Download RAW message or body]

Sorry, the affected file is:

mythweb/modules/tv/includes/channels.php

Am Samstag, den 29.01.2011, 21:31 +0100 schrieb gludie:
> Hi,
> 
> just installed the mythweb plugin under ubuntu 10.04 and tried to
> decrease the amount of channels in the programm list. But having checked
> the option show only favorites in the settings, an error occure with the
> next update of the program list, because the underlying sql statement
> tries to link table channel with favorites, which do not exist.
> I saw, that there was already a path last March for it. Am I got an old
> package for ubuntu 10.04 LTS ?
> 
> Quick fix:
> < $sql = 'SELECT channel.* FROM channel, favorites WHERE channel.chanid
> = favorites.chanid AND';
> ---
> > $sql = 'SELECT channel.* FROM channel WHERE channel.chanid in (select
> distinct chanid from channelgroup) AND';
> 
> here the info about the bug from March 2010 I found:
> http://mythtv.org/pipermail/mythtv-d...ch/067949.html
> 
> best regards, gludie
> 
> 

best regards, gludie

_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev

[prev in list] [next in list] [prev in thread] [next in thread]