Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

Error when UserID is the same as a previous one.

Quote Reply
Error when UserID is the same as a previous one.
Hi Alex,

Got this error when attempting to "join" with a UserID that had previously been used..

The previous userID was never validated and then deleted.

The previous "join" info is still in - Webmail_dgraph

Error
---------------------------------------------------------------------------------------
Content-Type: text/html

Could not do ' INSERT INTO Webmail_dgraph
(dgraph_userid,dgraph_state,dgraph_zip,dgraph_country,dgraph_last_name,dgraph_address,dgraph_email,dgraph_first_name,dgraph_city)
VALUES ('12', 'Inebriated','9876','AU','Nobody','123 Avenue St','nhiggid@ozemail.com.au','Dave','Somewhere') '. Reason:
'Duplicate entry '12' for key 1'


CGI INPUT
======================================
dgraph_address => 123 Avenue St
dgraph_city => Somewhere
dgraph_country => AU
dgraph_email => nhiggid@ozemail.com.au
dgraph_first_name => Dave
dgraph_last_name => Nobody
dgraph_state => Inebriated
dgraph_zip => 9876
password => 12
userid => 12


CURRENT USER
======================================
template => default


ENVIRONMENT
======================================
CONTENT_LENGTH => 215
CONTENT_TYPE => application/x-www-form-urlencoded
DOCUMENT_ROOT => /usr/home/cooee/html
GATEWAY_INTERFACE => CGI/1.1
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, image/png, */*
HTTP_ACCEPT_CHARSET => iso-8859-1,*,utf-8
HTTP_ACCEPT_ENCODING => gzip
HTTP_ACCEPT_LANGUAGE => en
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => WebmailTest=1; LookSmartPIN=000806x3dcf35b35fbd55f5791; dis_dgraph=yes; dis_prefs=yes; mysqlman_host=; mysqlman_username=cooee; mysqlman_password=gillian
HTTP_HOST => www.cooeemail.com.au
HTTP_REFERER => http://www.cooeemail.com.au/cgi-bin/webmail/user/join.cgi
HTTP_USER_AGENT => Mozilla/4.73 [en]C-CCK-MCD snapN45b1 (Win98; U)
HTTP_VIA => 1.1 proxy.ozemail.com.au (NetCache 4.1R1D6)
HTTP_X_FORWARDED_FOR => 203.108.21.222
PATH => /sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/root/bin
QUERY_STRING =>
REMOTE_ADDR => 203.108.0.58
REMOTE_HOST => UNKNOWN
REMOTE_PORT => 39820
REQUEST_METHOD => POST
REQUEST_URI => /cgi-bin/webmail/user/join.cgi
SCRIPT_FILENAME => /usr/home/cooee/html/cgi-bin/webmail/user/join.cgi
SCRIPT_NAME => /cgi-bin/webmail/user/join.cgi
SERVER_ADDR => 209.50.251.232
SERVER_ADMIN => webmaster@cooeemail.com.au
SERVER_NAME => www.cooeemail.com.au
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.0
SERVER_SIGNATURE =>
Apache/1.3.9 Server at www.cooeemail.com.au Port 80


SERVER_SOFTWARE => Apache/1.3.9 (Unix) PHP/3.0.16


STACK TRACE
======================================
(Webmail::generate_error_msg) called from (/usr/home/cooee/html/cgi-bin/webmail/admin/Webmail.pm) line (1605)
(Webmail::cgierr) called from (/usr/home/cooee/html/cgi-bin/webmail/user/join.cgi) line (126)
(main::sign_up) called from (/usr/home/cooee/html/cgi-bin/webmail/user/join.cgi) line (40)
(main::main) called from (/usr/home/cooee/html/cgi-bin/webmail/user/join.cgi) line (29)

---------------------------------------------------------------------------------------

If the previous info is deleted via "SQL Monitor" new "join" will be successful

Should this be managed by the script?

Dave

Subject Author Views Date
Thread Error when UserID is the same as a previous one. DDave 1968 Aug 11, 2000, 6:07 PM
Thread Re: Error when UserID is the same as a previous one.
Alex 1885 Aug 23, 2000, 11:29 AM
Thread Re: Error when UserID is the same as a previous one.
DDave 1875 Aug 24, 2000, 1:27 AM
Post Re: Error when UserID is the same as a previous one.
Alex 1867 Aug 25, 2000, 5:10 PM