Bug 54510 - Tracebacks if put space in Address1 in rhn_register
Tracebacks if put space in Address1 in rhn_register
Product: Red Hat Network
Classification: Red Hat
Component: RHN/Backend (Show other bugs)
RHN Devel
i386 Linux
medium Severity high
: ---
: ---
Assigned To: Adrian Likins
Jay Turner
Depends On:
  Show dependency treegraph
Reported: 2001-10-10 14:25 EDT by Jay Turner
Modified: 2015-01-07 18:52 EST (History)
4 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2002-05-15 15:45:54 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Jay Turner 2001-10-10 14:25:40 EDT
Description of Problem:
If the user sets Address1 to one of more spaces, then it does not get
populated with the default of "." and therefore when we attempt to insert
into the web_user_site_info record, we get a traceback.  The error is:

Traceback (innermost last):
  File "/var/www/rhns/server/apacheServer.py", line 37, in __call__
    ret = f(req)
  File "/var/www/rhns/server/rhnServer.py", line 163, in handler
    ret = self.__xmlrpcCall(server, methodName, params, req)
  File "/var/www/rhns/server/rhnServer.py", line 507, in __xmlrpcCall
    raise rhns_oracle.OracleError(e)
OracleError: (1407, 'ORA-01407: cannot update
+("WEB"."WEB_USER_SITE_INFO"."ADDRESS1") to NULL\012', {'SQL': 'update
+web_user_site_info set alt_first_names = :p_alt_first_names, state =
+:p_state, country = :p_country, alt_last_name = :p_alt_last_name, address1 =
+:p_address1 where id = :p0', 'Params': [(':p0', 2049647), (':p_address1',
+''), (':p_alt_first_names', 'C'), (':p_alt_last_name', 'Bailey'),
+(':p_country', 'CA'), (':p_state', 'British Columbia')]})

Version-Release number of selected component (if applicable):

How Reproducible:

Steps to Reproduce:

Actual Results:

Expected Results:
Need to make sure that spaces count as null and therefore those mandatory
fields get populated with "."

Additional Information:
Comment 1 Josef Komenda 2002-03-20 11:40:34 EST
Bret McMillian taking a look at this - but holding off on assigning it for now.
Comment 2 Cristian Gafton 2002-04-11 04:56:46 EDT
This need to be fixed in the rhn_register itself. Assigning to alikins
Comment 3 Adrian Likins 2002-04-11 15:14:58 EDT
The error looks like a oracle server side error to me, but
either way, I cant seem to duplicate this with the client.

jay/joe: Mind showing me how to trigger it?
Comment 4 Adrian Likins 2002-05-15 15:45:43 EDT
ping, can duplicate this... gonna close if no other info
Comment 5 Josef Komenda 2002-07-16 11:45:12 EDT
Seems to work fine. Closing.

Note You need to log in before you can comment on or make changes to this bug.