| Author |
 Topic  |
|
|
phoenixtaz13
Junior Member
129 Posts |
 Posted - 19 February 2009 : 12:25:33
|
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.... :)
< |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 February 2009 : 12:49:42
|
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.< |
 |
|
|
phoenixtaz13
Junior Member
129 Posts |
Posted - 19 February 2009 : 13:05:59
|
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.... :)
< |
Edited by - phoenixtaz13 on 20 February 2009 20:38:33 |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 19 February 2009 : 13:32:11
|
| check your installation of the avatar mod, seems as tho you are missing somthing at the end of the insert statement.< |
© 1999-2010 MaD2ko0l |
|
|
|
phoenixtaz13
Junior Member
129 Posts |
Posted - 20 February 2009 : 20:37:40
|
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?....
< |
|
|
|
Carefree
Advanced Member
Philippines
4212 Posts |
Posted - 20 February 2009 : 20:44:56
|
| Post a link to a copy of your "register.asp" in .txt format for us to review.< |
|
|
|
phoenixtaz13
Junior Member
129 Posts |
|
|
Carefree
Advanced Member
Philippines
4212 Posts |
Posted - 21 February 2009 : 01:50:00
|
| Here, try this.< |
|
|
|
phoenixtaz13
Junior Member
129 Posts |
Posted - 21 February 2009 : 03:00:57
|
thanks carefree.... thanks for the time :)
i'll work on it now.... let u know in awhile....
< |
|
|
|
phoenixtaz13
Junior Member
129 Posts |
Posted - 21 February 2009 : 11:44:52
|
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....< |
|
|
|
phoenixtaz13
Junior Member
129 Posts |
Posted - 21 February 2009 : 12:48:35
|
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.... :)
< |
|
|
|
Carefree
Advanced Member
Philippines
4212 Posts |
Posted - 21 February 2009 : 12:51:42
|
| Good enough. As long as it's working.< |
|
|
| |
Topic |
|
|
|
register.asp error
