| Author |
 Topic  |
|
|
sanalcafe
Starting Member
18 Posts |
 Posted - 28 July 2003 : 21:47:39
|
i change my forum options forum
Admin home/E-mail Server Configuration
like this:
E-mail Mode off > on
E-mail Validation off >on
Restrict Registration off > on
(but
Require Unique E-mail is on
Require Logon for sending Mail is on)
then i log out, and i try to register like a new member
i fill the form , when i click OK , i see this error:
Microsoft JET Database Engine error '80040e14'
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.
/forum/register.asp, line 580
***** IF I DON'T MAKE A CHANGE ON "E-mail Server Configuration" , register.asp is WORKING *****
my register.asp, 580. line is: :
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
also this is from 563. line:
if strLNews = "1" then
strsql = strsql & ", '" & ChkString(Request.Form("LNews"),"message") & "'"
else
strSql = strSql & ", ''"
end if
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 & ", 1"
strSql = strSql & ", '" & ChkString(Request.Form("Avatar_URL"),"SqlString") & "'"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
where is my problem? can anybody help me?
also i have some add ons...
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
sanalcafe
Starting Member
18 Posts |
Posted - 28 July 2003 : 21:53:01
|
no missing, also in AUHide all users have 1
|
 |
|
|
sanalcafe
Starting Member
18 Posts |
Posted - 28 July 2003 : 21:56:23
|
i say again that if i don't change in E-mail Server Configuration, there is no problem whit registeration...
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
sanalcafe
Starting Member
18 Posts |
Posted - 28 July 2003 : 22:05:07
|
:((((
i saw now i am looking to wrong table
i will make some changes now thanx...
|
|
|
|
sanalcafe
Starting Member
18 Posts |
Posted - 28 July 2003 : 22:34:52
|
nikkol
my new problem is now about asp
my mail server is working (i can send forgetten passwords to mail adress)
but i can't send to new member for reply and pending for forum
also when registeration is complete, it says like that: mail has been sent and reply it...
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
sanalcafe
Starting Member
18 Posts |
Posted - 28 July 2003 : 22:53:55
|
hi nikkol
i change Restrict Registration on to off
and it's now working
a lot of thanks for your help
but i must say i can't understand snitz sometimes
i read other topics and i make some changes like other users
thanks again...
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 29 July 2003 : 01:16:57
|
sanalcafe, please use the forums to ask questions rather than emailing.
Your email mentioned that you are still getting an error in register.asp. My suggestion is that you go over the MOD you added and make sure you didn't miss any important steps.
It is obvious that you must have missed the update to the members pending table, so look at the MOD instructions again and see what needs to be done to add the required fields to the members pending table.
Also, check the code you added in register.asp for the MOD very carefully to make sure you don't have any lines out of place. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
Edited by - Nikkol on 29 July 2003 01:18:08 |
|
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 15 June 2004 : 06:26:48
|
| I had this problem and it was in the members_pending table. Thanks |
|
|
| |
Topic |
|
Topic Locked
