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.... :)


<

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


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.<

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.... :)

<

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

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?.... <

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

thanks for ur time...
heres the link for my register.asp in TXT
http://cid-712c33ce341411d8.skydrive.live.com/embedgrid.aspx/.Public/register.txt

<

Here, try this.<

thanks carefree.... thanks for the time :)

i'll work on it now.... let u know in awhile....

<

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!"
%>
<!--#INCLUDE FILE="inc_mail.asp" -->
<%
end if
else Response.Write " <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """ color=""" & strHiLiteFontColor & """>There Was A Problem With Your Details</font></p>" & vbNewLine & _
" <table align=""center"" border=""0"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHiLiteFontColor & """><ul>" & Err_Msg & "</ul></font></td>" & vbNewLine & _
" </tr>" & vbNewLine & _
" </table>" & vbNewLine & _
" <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""JavaScript:history.go(-1)"">Go Back To Enter Data</a></font></p>" & vbNewLine
WriteFooter
Response.End
end if

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

carefree,

found out the problem already.... apparently, my prob was with the active users mod, i inserted some statements inside the quote, when it should be outside quote statment...
thanks for taking ur time, greatly appreciate it.... :)

<

Good enough. As long as it's working.<