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