Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Access 2000 error?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Big B
Starting Member

USA
49 Posts

Posted - 06 March 2001 :  00:01:52  Show Profile  Visit Big B's Homepage  Send Big B an AOL message  Send Big B an ICQ Message
When a new member is registering, the get the following error right after they click submit. The user account is created but they can not log in at all. [Access 2000]

Microsoft VBScript runtime error '800a01c9'

This key is already associated with an element of this collection

/forum/register.asp, line 311

## Here is lines 300 to 322 in register.asp

'########################### PM NEW MEMBER #####################
strSql = strSql & ")"

my_Conn.Execute (strSql)

docount

regHomepage = ""

'########################### PM NEW MEMBER #####################
if intNewMemberPM = "1" then
Dim objDict
Set objDict = Server.CreateObject("Scripting.Dictionary")
set objRec = my_Conn.execute("SELECT * FROM " & strTablePrefix & "MODS WHERE M_NAME = 'NewMemPM'")

while not objRec.EOF
objDict.Add objRec.Fields.Item("m_code").Value, objRec.Fields.Item("m_value").Value
objRec.moveNext
wend

Admin = GetMemberID(objDict.Item("Admin"))
Subject = chkString(objDict.Item("Subject"),"message")
Message = chkString(objDict.Item("Message"),"message")


Any help appreciated






Big B
Starting Member

USA
49 Posts

Posted - 06 March 2001 :  00:43:56  Show Profile  Visit Big B's Homepage  Send Big B an AOL message  Send Big B an ICQ Message
Fixed it for now. Renamed register.asp and replaced it with the one from r2 and registration works fine now.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07