From spacewalk-list: List: I'm getting the following ISE when trying to create a notification method for my Spacewalk user. -----Original Message----- From: dev-null [dev-null] Sent: Tuesday, December 14, 2010 4:57 PM To: Trevor T Kates (Services - 6) Subject: WEB TRACEBACK (Tue Dec 14 16:56:53 2010) The following exception occurred while executing this request: POST /network/users/details/contact_methods/create.pxt HTTP/1.1 (from browser) /network/users/details/contact_methods/create.pxt (from Apache) Date: Tue Dec 14 16:56:53 2010 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.7 Accept-Encoding: gzip,deflate Accept-Language: en-us,en;q=0.5 Connection: keep-alive Content-Length: 165 Content-Type: application/x-www-form-urlencoded Cookie: pxt-session-cookie=138218x34f7fc33389a5e50917adedefc6421fe Host: redacted Keep-Alive: 115 Referer: https://redacted/network/users/details/contact_methods/create.pxt?uid=1 User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101209 CentOS/3.6-2.el5.centos Firefox/3.6.13 Form variables: create_method => Create Method method_email => trevor.t.kates method_name => DomMail pxt:trap => rhn:contact-method-create-cb redirect_to => index.pxt?uid=1 uid => 1 User Information: User trevor (id 1, org_id 1) Error notes: (none) Initial Request: Yes Error message: RHN::Exception: DBD::Oracle::st execute failed: ORA-00904: "CM"."LAST_UPDATE_DATE": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 192 in 'INSERT INTO rhn_contact_methods (recid, method_name, contact_id, schedule_id, method_type_id, pager_email, pager_split_long_messages, email_address, last_update_user, notification_format_id, <*>CM.last_update_date) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, SYSDATE)') [for Statement "INSERT INTO rhn_contact_methods (recid, method_name, contact_id, schedule_id, method_type_id, pager_email, pager_split_long_messages, email_address, last_update_user, notification_format_id, CM.last_update_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE)" with ParamValues: :p5="2", :p8='trevor.t.kates', :p10="4", :p2='DomMail', :p3='1', :p6=undef, :p1="3", :p7=0, :p4=1, :p9="1"] RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228 RHN::Exception::DB::throw RHN::DB::ContactMethod /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/ContactMethod.pm 225 RHN::DB::handle_error Sniglets::ContactMethod /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ContactMethod.pm 208 RHN::DB::ContactMethod::commit Sniglets::ContactMethod /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ContactMethod.pm 207 (eval) PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 515 Sniglets::ContactMethod::contact_method_edit_cb PXT::Request /usr/lib/perl5/vendor_perl/5.8.8/PXT/Request.pm 585 PXT::ApacheHandler::pxt_parse_data PXT::Handlers /usr/lib/perl5/vendor_perl/5.8.8/PXT/Handlers.pm 114 PXT::Request::include PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 141 PXT::Handlers::pxt_include_handler PXT::Parser /usr/lib/perl5/vendor_perl/5.8.8/PXT/Parser.pm 72 PXT::Parser::expand_tag PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 489 PXT::Parser::expand_tags PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117 PXT::ApacheHandler::pxt_parse_data PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 117 (eval) main -e 0 PXT::ApacheHandler::handler main -e 0 (eval)
fixed in commit a8ef42bbe7fb6ad9d78710047d933006e3fd9b54
another instance fixed in commit 95e3b42d011bdb0aae4be67ea7bbdf9872512cc3
Moving ON_QA ...
This bug has been fixed in Spacewalk 1.3.