Description of problem:
After upgrading to spacewalk 2.8, "rhn-channel -a -c xxx' resulted with 
"Server is not subscribed to parent of channel xxx"


Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. rhn-channel -a -c xxx
2.
3.

Actual results:
"Server is not subscribed to parent of channel xxx"


Expected results:
system subscribes to channel

Additional info:
adding the "where" clause to backend/server/rhnChannel.py fixes the problem

_query_server_parent_channel = rhnSQL.Statement("""
select pc.id, pc.label
  from rhnChannel c
  join rhnServerChannel sc on c.parent_channel = sc.channel_id
  join rhnChannel pc on c.parent_channel = pc.id
where sc.server_id = :sid
 group by pc.id, pc.label
""")

using the spacewalk-client 2.7 or 2.8 made no difference.