| Author |
 Topic  |
|
xx ENIGMA xx
Junior Member
166 Posts |
 Posted - 17 November 2003 : 14:20:39
|
I was just made aware of new users trying to signup
and getting an error, and this is after several mods
have been installed and I have no clue how to fix this?
This happens after they have filled out all info and then
try to submit.
================================================================
error:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/bbs/register.asp, line 600
================================================================
my line 600 = my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
text version of my register.asp http://www.pointblankrecon.com/temp/register.asp.txt
thanks for any speedy help 
|
my little forum playground
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 14:34:45
|
Can you put this on line 599 and copy what you get back here :
Response.Write strSql |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 14:39:25
|
Actually, I think you should move your AU MOD (lines 584-590) 3 lines down, so that whole area looks like this :
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
'####################### ACTIVE USERS MOD #############################
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
'##################################################################
strSql = strSql & ", 1"
|
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 14:43:25
|
thanks laser, I now get this after adding that line in:
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_AUHIDE, M_SHA256, M_AVATAR_URL) VALUES ('Spiritual Rage', '9dc415325a95c6e2558bf141a8772a175de49b08f0a027c8720ad942d6ec63f7', 'mike.howard@mchsi.com', '20031117133640', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20031117133640', 1, '1', '24.155.36.30', '24.155.36.30', ' ', 1, 1, ' ', ' ', ' ', '', ' ', '', '', ' ', '', '', ' ', '', '', '', '', '', 1, 'noavatar.gif')
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/bbs/register.asp, line 603
the line number has changed because I commented the addition
into the file, but it now looks like this in register.asp
line: 602 Response.Write strSql
line: 603 my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
|
my little forum playground
|
Edited by - xx ENIGMA xx on 17 November 2003 14:48:28 |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 14:56:43
|
quote:
Originally posted by laser
Actually, I think you should move your AU MOD (lines 584-590) 3 lines down, so that whole area looks like this :
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
'####################### ACTIVE USERS MOD #############################
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
'##################################################################
strSql = strSql & ", 1"
Ok, so now here you are saying to remove lines 591-593
completely - (shown below)
else
strSql = strSql & ", ''"
end if
|
my little forum playground
|
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 15:02:22
|
well removing those 3 lines:
else
strSql = strSql & ", ''"
end if
produces this error now
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/bbs/register.asp, line 692
else
^
so I am getting more confused by the minute 
|
my little forum playground
|
Edited by - xx ENIGMA xx on 17 November 2003 15:06:09 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 16:09:40
|
quote:
Ok, so now here you are saying to remove lines 591-593
completely - (shown below)
Who said where ? I said nothing of the sort 
edit: ok, I can see where you got confused, but your SQL statement has 38 columns, and 37 values. |
Edited by - laser on 17 November 2003 16:14:57 |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 16:12:04
|
no you didnt mention deleting the 3 lines, guess
I took your comment of moving 3 lines down as
replacing/deleting those 
so what exactly do you mean?
how would moving that segment down 3 lines fix
this? or am I just blind |
my little forum playground
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 16:15:41
|
| I was trying to get the statement to have 38 values .... I editted my post above. |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 16:20:07
|
| This will help ... undo your changes until you get what you posted at "17 November 2003 : 14:43:25" but when you create the user, fill in EVERY field and use the field name .... so fill in the occupations as -> occupation. |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 16:25:14
|
edit: I believe I have lost my mind today - forgive me
I will try this again but I cannot say I'm not
confused about the 38/37 and how this might have
happened
I'll post results in just a couple minutes
btw, thnaks for your help....I'm lost |
my little forum playground
|
Edited by - xx ENIGMA xx on 17 November 2003 16:30:48 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 16:32:11
|
| I just noticed that line 493 is commented - should it be ? |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 16:37:11
|
quote:
Originally posted by laser
I just noticed that line 493 is commented - should it be ?
line 493 is within the email validation mod
which is within the original snitz code.
It is actually line 472 in an unmodded register.asp
and "YES" it is commented out |
my little forum playground
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2003 : 16:42:04
|
Can you go back to make it work like this :
quote:
Can you put this on line 599 and copy what you get back here :
Response.Write strSql
then we can see what is wrong. |
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 16:47:42
|
but back to the post where you stated I should make mine look
like your example, I feel like an idiot because I am flat
out confused since you say "Don't" delete 3 lines or that
you didnt say to delete 3 lines. But then I see 2-3 lines that
do not match your example?
help me understand this 
from my register.asp
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
'####################### ACTIVE USERS MOD #############################
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
'##################################################################
else
strSql = strSql & ", ''"
end if
strSql = strSql & ", 1"
can you alter the color to red of what I should take out here?
|
my little forum playground
|
|
|
|
xx ENIGMA xx
Junior Member
166 Posts |
Posted - 17 November 2003 : 16:51:06
|
quote:
Originally posted by laser
Can you go back to make it work like this :
quote:
Can you put this on line 599 and copy what you get back here :
Response.Write strSql
then we can see what is wrong.
ok, adding that line in produces this:
INSERT INTO FORUM_MEMBERS (M_NAME, M_PASSWORD, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_AUHIDE, M_SHA256, M_AVATAR_URL) VALUES ('Spritual Rage', '9dc415325a95c6e2558bf141a8772a175de49b08f0a027c8720ad942d6ec63f7', 'test@test.com', '20031117154634', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20031117154634', 1, '1', '24.155.36.30', '24.155.36.30', ' ', 1, 1, ' ', ' ', ' ', '', ' ', '', '', ' ', '', '', ' ', '', '', '', '', '', 1, 'noavatar.gif'
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/bbs/register.asp, line 602
|
my little forum playground
|
|
|
|
Topic |
|
|
|
Topic Locked
