register.asp error - Snitz™ Forums 2000

The Forum has been Updated

The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.

phoenixtaz13

Junior Member

Innlegg: 129

129

hello... good day to all...
need help again..... :)

heres the error message:
Microsoft JET Database Engine (0x80040E14)
Number of query values and destination fields are not the same. /forum/register.asp, line 659

line 659 is in red
strSql = strSql & ", 1"
strSql = strSql & ", '" & ChkString(Request.Form("Avatar_URL"),"SqlString") & "'"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

i get this error when i activate the quote in MEMBERS DETAILS CONFIGURATION.
how do i fix this?....
thanks in advance.... :)

<

Postet den 19 Feb 2009

AnonJr

Forum Moderator

Innlegg: 5768

5768

Looks like a problem with a MOD you installed.
Right before line 659, add the part in green:

Code:

strSql = strSql & ", 1"
strSql = strSql & ", '" & ChkString(Request.Form("Avatar_URL"),"SqlString") & "'"
strSql = strSql & ")"
Response.Write(strSql)
Response.End
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

This will output the SQL statement, and help you figure out where the problem is.
Once you've got the SQL statement copied down somewhere you can remove those two lines.<

Postet den 19 Feb 2009

phoenixtaz13

Junior Member

Innlegg: 129

129

thanks for ur time.....
heres what appeared:
INSERT INTO FORUM_MEMBERS_PENDING (M_NAME, M_PASSWORD, M_KEY, M_LEVEL, M_APPROVE, 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 ('fuzz', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', '3e3mt5go134j3x9s776wklzf5g9b2t6j', -1, 1, 'emailtest@yahoo.com', '20090220020347', ' ', ' ', ' ', ' ', ' ', 0, ' ', '20090220020347', 0, 1 , '124.6.185.192', '124.6.185.192', ' ', 1, 1, ' ', ' ', ' ', '', ' ', '', '', '', '', '', ' ', ' ', '', ' ', '', ' ', 1, ' ')

what will i do next?....
thanks again for ur help.... :)

<

Sist redigert av

Postet den 19 Feb 2009

MaD2ko0l

Senior Member

Innlegg: 1053

1053

check your installation of the avatar mod, seems as tho you are missing somthing at the end of the insert statement.<

Postet den 20 Feb 2009

phoenixtaz13

Junior Member

Innlegg: 129

129

i rechecked my installation of avatar mod, everything is in order, i still get the error... :(

just thinking, if the cause of the problem is my avatar mod, how come it only occurs when i activate the quote in the member detail configuration?.... i dont get errors if the quote is deactivated....
any ideas?.... <

Postet den 20 Feb 2009

Carefree

Advanced Member

Innlegg: 4224

4224

Post a link to a copy of your "register.asp" in .txt format for us to review.<

Postet den 21 Feb 2009

phoenixtaz13

Junior Member

Innlegg: 129

129

carefree, good day to you.... :)

unfortunately, i have an error.... :(

error message:
Microsoft VBScript compilation (0x800A03F6)
Expected 'End'
/forum/register.asp, line 692

heres LINE 692 in red:
strMessage = strMessage & "You can change your information at our website by selecting the ""Profile"" link." & vbNewline & vbNewline
strMessage = strMessage & "Happy Posting!"
%>

<%
end if
else Response.Write " There Was A Problem With Your Details" & vbNewLine & _
" <table align=""center"" border=""0"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td><ul>" & Err_Msg & "</ul></td>" & vbNewLine & _
" </tr>" & vbNewLine & _
" </table>" & vbNewLine & _
" <a href=""JavaScript:history.go(-1)"">Go Back To Enter Data</a>" & vbNewLine
WriteFooter
Response.End
end if

hope to hear from u soon....
thanks...
god bless....<