[Spacewalk-list] ISE when attempting to create a notification method for Spacewalk user

[Trevor T Kates]

Miroslav:

The same table_alias problem exists in ContactGroup.pm. I made the same change
you provided for ContactMethod.pm to ContactGroup.pm and it works beautifully.

Thanks again.

________________________________________________________
Trevor T. Kates
Associate Software Systems Engineer

> -----Original Message-----
> From: dev-null at dom.com [mailto:dev-null at dom.com]
> Sent: Wednesday, December 15, 2010 12:01 PM
> To: Trevor T Kates (Services - 6)
> Subject: WEB TRACEBACK (Wed Dec 15 12:00:39 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:
>   Wed Dec 15 12:00:39 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: 168
>   Content-Type: application/x-www-form-urlencoded
>   Cookie: pxt-session-cookie=138246x700305b91f4cf52503a94cef410d8341
>   Host: redacted
>   Keep-Alive: 115
>   Referer:
> https://redacted/network/users/details/contact_methods/crea
> te.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 at dom.com
>   method_name => OA DomMail
>   pxt:trap => rhn:contact-method-create-cb
>   redirect_to => index.pxt?uid=1
>   uid => 1
> 
> User Information:
>   User trevor7 (id 1, org_id 1)
> 
> Error notes:
>   (none)
> 
> Initial Request:
>   Yes
> 
> Error message:
>   RHN::Exception: DBD::Oracle::st execute failed: ORA-00904:
> "CG"."LAST_UPDATE_DATE": invalid identifier (DBD ERROR: error possibly near
> <*> indicator at char 152 in 'INSERT INTO rhn_contact_groups
>  (recid, contact_group_name, customer_id, strategy_id, ack_wait,
> rotate_first, last_update_user, notification_format_id,
> <*>CG.last_update_date) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8,
> SYSDATE)') [for Statement "INSERT INTO rhn_contact_groups
>  (recid, contact_group_name, customer_id, strategy_id, ack_wait,
> rotate_first, last_update_user, notification_format_id,
> CG.last_update_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, SYSDATE)" with
> ParamValues: :p5=0, :p6=0, :p3="1", :p7="1", :p1="8", :p8="4", :p4="1",
> :p2='OA DomMail']
>   RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 228
> RHN::Exception::DB::throw
>   RHN::DB::ContactGroup
> /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/ContactGroup.pm 227
> RHN::DB::handle_error
>   Sniglets::ContactMethod
> /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ContactMethod.pm 209
> RHN::DB::ContactGroup::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)

CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.