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

[Jeremy Davis]

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)

Date:
Tue Aug 23 08:19:02 2011

Headers:
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Cache-Control: max-age=0
Connection: keep-alive
Content-Length: 1089
Content-Type: application/x-www-form-urlencoded
Cookie: pxt-session-cookie=194278x53700a92f83c93ab6de74fd0855c4710
Host: spacewalk.intranet.gdg
Origin: https://spacewalk.intranet.gdg
Referer:
https://spacewalk.intranet.gdg/network/systems/groups/admin_list.pxt?sgid=10
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML,
like Gecko) Chrome/13.0.782.112 Safari/535.1

Form variables:
alphabar_column =>
first_lower => 1
first_upper => 500
formvars => sgid
formvars => sgid
last_lower => 1
last_upper => 73
list_action_label_update_system_group_membership => Update
list_action_url_update_system_group_membership =>
list_mode => group_admins
lower => 1
next_lower => 1
next_upper => 73
prev_lower => 1
prev_upper => 500
pxt:trap => rhn:user_list_cb
sgid => 10
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
sguid => 86
upper => 73
user_253_is_admin => 1
user_295_is_admin => 1

User Information:
User jddavis (id 2, org_id 1)

Error notes:
(none)

Initial Request:
Yes

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
from rhnUserServerGroupPerms usgp
where usgp.user_id = :p1
and usgp.server_group_id = :p2
and exists (
select 1
from rhnServerGroup sg,
web_contact wc
where wc.id = usgp.user_id
and sg.id = usgp.server_group_id
and sg.org_id = wc.org_id
)<*>;
') [for Statement " select usgp.server_group_id, usgp.user_id
from rhnUserServerGroupPerms usgp
where usgp.user_id = ?
and usgp.server_group_id = ?
and exists (
select 1
from rhnServerGroup sg,
web_contact wc
where wc.id = usgp.user_id
and sg.id = usgp.server_group_id
and sg.org_id = wc.org_id
);
"]
RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm <http://db.pm/> 228
RHN::Exception::DB::throw
RHN::DB::User /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/User.pm<http://user.pm/>
1687
RHN::DB::handle_error
Sniglets::ListView::UserList
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/UserList.pm<http://userlist.pm/>
175
RHN::DB::User::revoke_servergroup_permission
Sniglets::ListView::List /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ListView/
List.pm <http://list.pm/> 374 Sniglets::ListView::UserList::group_admin_cb
Sniglets::Lists
/usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Lists.pm<http://lists.pm/>
135
Sniglets::ListView::List::callback
PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm<http://apachehandler.pm/>
513
Sniglets::Lists::listview_cb
PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm<http://apachehandler.pm/>
117
PXT::ApacheHandler::pxt_parse_data
PXT::ApacheHandler
/usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm<http://apachehandler.pm/>
117
(eval)
main -e 0 PXT::ApacheHandler::handler
main -e 0 (eval)

Thanks,
Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110823/d13d6e54/attachment.htm>