Description of problem: There is a Syntax-failure in the SQL-statement _query_parent_channel_subscribed in rhnChannel.py: select 1 from rhnChannel c, join rhnServerChannel sc on c.parent_channel = sc.channel_id where sc.server_id = :sid and c.label = :channel it should be select 1 from rhnChannel c join rhnServerChannel sc on c.parent_channel = sc.channel_id where sc.server_id = :sid and c.label = :channel The comma is too much. This rises an SQL-Exception. Version-Release number of selected component (if applicable): min. 2.2 How reproducible: Just one example, how we found the problem, i think, there are more ways to do it. Steps to Reproduce: 1. try to add a channel via spacewalk-channel -a -c $NAME in a client 2. look in the rhn_server_xmlrpc.log on the server 3. you will see a message like "server/apacheRequest.call_function('ERROR', 'rhnSQL.SQLError caught', SQLStatementPrepareError('FEHLER: ... ... " Actual results: The client recieves an internal error from the server and nothing happens. Expected results: The channel should be added. Additional info: nope
spacewalk.git master: 4bf063f97ae66d889236e11ea237dfd785dbce29
*** Bug 1126877 has been marked as a duplicate of this bug. ***
Any progress on this, we also encountered this after upgrade to 2.2.
Come on RedHat.. this bug has been around for almost 4 months... and still no movement... This bug is a major show stopper for the project I am working on.. please give us a workaround or bug fix.
Created attachment 958521 [details] syntax error in sql request
The attachment proposed in comment #5 looks to fix the issue.
(In reply to Dan Creed from comment #4) > Come on RedHat.. this bug has been around for almost 4 months... and still > no movement... This bug is a major show stopper for the project I am working > on.. please give us a workaround or bug fix. Dan, I am using workaround with 'spacecmd' spacecmd {SSM:0}> system_addchildchannels system_addchildchannels: Add child channels to a system usage: system_addchildchannels <SYSTEMS> <CHANNEL ...>
Moving bugs to ON_QA as we move to release Spacewalk 2.3
Spacewalk 2.3 has been released. See https://fedorahosted.org/spacewalk/wiki/ReleaseNotes23