Reply to thread

Message

<blockquote data-quote="Big_Kev" data-source="post: 310515" data-attributes="member: 52102">Try running this query in MySQL query browser (if you get a &quot;database not selected&quot; error, just double click the mptvdbrc1 database on the schemata tab to open it)select DISTINCT t.name, t.idChannel, c.displayName from channel c, groupmap g, tuningdetail t where&nbsp; t.idChannel = g.idChannel and c.isRadio = 0 and g.idChannel = c.idChannel and c.idChannel in (select idChannel from channelgroup c, groupmap g where c.groupName ='Freesat' and g.idGroup = c.idGroup) and g.idGroup in (select c.idGroup from channelgroup c, groupmap g where c.groupName ='Freesat' and g.idGroup = c.idGroup) order by&nbsp; g.sortOrderYou will see that there are duplicate displayName entries for different name entries. Web Interface uses displayName (as this is the name that users enter for display).for example, see:BBC ONE = BBC ONEBBC 1 W Mids = BBC ONEBBC 2 England = BBC TWOBBC TWO = BBC TWOSo you can change the display names so they are non-ambiguous or make the redundant channels not visible or re-arrange your groups into smaller numbers of channels etc.Hope this helps...Kev</blockquote>

[QUOTE="Big_Kev, post: 310515, member: 52102"] Try running this query in MySQL query browser (if you get a "database not selected" error, just double click the mptvdbrc1 database on the schemata tab to open it) select DISTINCT t.name, t.idChannel, c.displayName from channel c, groupmap g, tuningdetail t where t.idChannel = g.idChannel and c.isRadio = 0 and g.idChannel = c.idChannel and c.idChannel in (select idChannel from channelgroup c, groupmap g where c.groupName ='Freesat' and g.idGroup = c.idGroup) and g.idGroup in (select c.idGroup from channelgroup c, groupmap g where c.groupName ='Freesat' and g.idGroup = c.idGroup) order by g.sortOrder You will see that there are duplicate displayName entries for different name entries. Web Interface uses displayName (as this is the name that users enter for display). for example, see: BBC ONE = BBC ONE BBC 1 W Mids = BBC ONE BBC 2 England = BBC TWO BBC TWO = BBC TWO So you can change the display names so they are non-ambiguous or make the redundant channels not visible or re-arrange your groups into smaller numbers of channels etc. Hope this helps... Kev [/QUOTE]

Verification