| Author |
 Topic  |
|
|
Nijii
Starting Member
Greenland
49 Posts |
 Posted - 22 February 2006 : 17:54:16
|
The following error occurs when new members want to register to my forum. I saw it after installing the avatar Mod 3.4 by Richard Kinser, adapted by Hamlin. I have the active users installed and got some other problem which was solved from this topic and don't really know if they are related http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61084
I need some help on this error.
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/snitz/register.asp, line 593
A text file of the register.asp can be seen here |
Edited by - Nijii on 22 February 2006 18:28:30 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Nijii
Starting Member
Greenland
49 Posts |
Posted - 22 February 2006 : 19:34:24
|
quote:
Originally posted by ruirib
Check the changes made in register.asp, specially around line 593 and previous. You are surely forgetting to add some code around that area od the file.
I cant see the error but here is some code before the two MODS and after.
----------------------------BEFORE------------------------
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
strSql = strSql & ", 1"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
--------------------------AFTER-------------------
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
strSql = strSql & ", ''"
end if
strSql = strSql & ", 1"
strSql = strSql & ", '" & ChkString(Request.Form("Avatar_URL"),"SqlString") & "'"
strSql = strSql & ")"
Line 593: my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords |
Edited by - Nijii on 22 February 2006 19:44:28 |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 22 February 2006 : 20:08:02
|
Just before line 593, do this :
Response.Write strSql
You will find that if you count the number of fields and the number of values, they won't match. |
|
|
|
Nijii
Starting Member
Greenland
49 Posts |
Posted - 22 February 2006 : 20:12:01
|
Hi many thanks! I found the error and now the code looks like this:
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
|
Edited by - Nijii on 22 February 2006 20:22:25 |
|
|
| |
Topic |
|
|
|
Topic Locked
