Created attachment 357802 [details] duplicate channels Description of problem: duplicate channel listings in parent channel combo box See screenshot: recreate: channels -> manage software channels -> create new channel select the parent channel drop down box see duplicates of channels Spoke to zues, he had a fix and wanted a bug on 530. So here it is :)
*** Bug 519696 has been marked as a duplicate of this bug. ***
*** Bug 527202 has been marked as a duplicate of this bug. ***
*** Bug 528923 has been marked as a duplicate of this bug. ***
Looks like this is a regression introduced in perl->java port (/network/software/channels/manage/edit.pxt -> /rhn/channels/manage/Edit.do). spacewalk-java-0.5.44/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml ... <sql-query name="Channel.findAllBaseChannels"> <![CDATA[SELECT {c.*} FROM rhnChannel {c}, rhnUserChannel uc, rhnChannelCloned c_1_ WHERE c.id = uc.channel_id AND c.id = c_1_.id (+) AND uc.org_id = :org_id AND uc.role = 'subscribe' AND c.parent_channel is null]]> <return alias="c" class="com.redhat.rhn.domain.channel.Channel" /> </sql-query> ... This returns duplicate entries if there're multiple channels cloned from the same source channel - i.e., mappings in rhnChannelCloned with the same source channel ID. It needs to filter for unique channels. Resetting Assignee/QA to default for component.
(In reply to comment #0) > recreate: You'll need to clone at least one base channel first in order to see the bug manifesting. > channels -> manage software channels -> create new channel > select the parent channel drop down box > > see duplicates of channels >
Should be fixed here: 30178fd40213afb5c2932443926960fc6f6746dd
test procedure: OLD: 1. have a more channel, more cloned channel 2. channels -> manage software channels -> create new channel # channels were shown multiple times with the same name, as in attachment.jpg NEW: cobbler-1.6.6-8.el5sat.x86_64 spacewalk-java-0.5.44-77.el5sat.noarch spacewalk-base-0.5.23-35.el5sat.noarch channels -> manage software channels -> create new channel one channel in one line, no duplicates
An advisory has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on therefore solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHBA-2010-0498.html