Bug 663304

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)