[Spacewalk-list] 500 Internal Server Error - Group Admin Page

[Michael Mraka]

Jeremy Davis wrote:
% Hello List,
% 
% I am getting the following error when trying to add admins to groups within
% Spacewalk. I can add the users to the groups via the user management area
% but not from the Admins page within the group. When I click submit after
% selecting users I get an 500 Internal Server Error. Any ideas you may have
% to resolve this issue would be greatly appreciated.
% 
% The following exception occurred while executing this request:
% POST /network/systems/groups/admin_list.pxt HTTP/1.1 (from browser)
% /network/systems/groups/admin_list.pxt (from Apache)

Hi Jeremy,

...
% Error message:
% RHN::Exception: DBD::Oracle::db selectall_arrayref failed: ORA-00911:
% invalid character (DBD ERROR: error possibly near <*> indicator at char 425
% in ' select usgp.server_group_id, usgp.user_id
...
% )<*>;

it looks like forgotten semicolon after some postgresql changes.
I've fixed the query in spacewalk nightly (spacewalk-base-1.6.17-1).
You may also manually apply the folowing patch to your system:
http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=cde1c64c0a0fc62615347109699c4a798d9d8a9f

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat