The INSERT INTO statement contains the following unknown field name: 'M_AUHIDE'. Make sure you have typed the name correctly, and try the operation again.
/forum2/register.asp, line 538
Line 538: if strQuote = "1" then strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'" else strSql = strSql & ", ''" end if if strAUAnon = "1" then strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'" else strSql = strSql & ", '1'" end if
strSql = strSql & ")"
my_Conn.Execute (strSql)
docount
I suspect that this has something to do with the Email Validation MOD that I have instaled. But I dont know how to fix it!
you'll need to add the M_AUHIDE field to the MEMBERS_PENDING table. You will also probably need to add the field to the code where the info is transferred from the MEMBERS_PENDING table to the MEMBERS table once a user is validated.
I have managed to add M_AUHIDE field to the MEMBERS_PENDING table. Now I get this error:
Microsoft JET Database Engine error '80004005' Field 'FORUM_MEMBERS_PENDING.M_OCCUPATION' cannot be a zero-length string. /forum2/register.asp, line 538
What fieldproperties should this field have?
To add the field to the code where the info is transferred from the MEMBERS_PENDING table to the MEMBERS table once a user is validated is way over my head.
Does someone have this fix/addon... ...or maby a way to bypass this? I wont give my members the opertunity to have the option to be anonomus. So it realy does not matter if this is registered when a new member sign on my forums. Is there a way to make this the default setting when a new member register to the forums?
Topic Locked
Posted - 16 April 2002 : 20:39:32
