Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 JET ENGINE ERROR
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  15:44:08  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
Microsoft JET Database Engine error '80040e14'

Number of query values and destination fields are not the same.

/vertical/forum/register.asp, line 576


Any suggestings? I cant finish my forum.

Here is the script, btw:

strSql = strSql & ", 1"
strSql = strSql & ")"

LINE 576 my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

if strEmail = "1" and strEmailVal = "1" then

Edited by - ruirib on 28 November 2004 16:49:30

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  15:45:11  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
someone tried to register, but it messed up. I guess adding that mod did something to it
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 28 November 2004 :  15:47:55  Show Profile
the error is just as it sounds. somewhere in your sql statement, you added a field name but did not add the value or visa versa. go over the changes for whatever mod you added.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  15:58:37  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
Would this mess up my active users page if i reinstalled the non-modded version?
Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts

Posted - 28 November 2004 :  16:09:42  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
If you're talking about the whole forum then, yes, it would... The active/inactive status wouldn't be processed anymore, and some other problems would occur - I wouldn't recommend it. I would get a version of register.asp when it was still working, and re-edit it for the MOD you want to install.

eXtremeGossip
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  16:12:35  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
well, i didnt try to install another mod...its still the same mod. can i send you the register.asp code?
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  16:13:38  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
you can visit the register.asp, but it that error comes up when trying to submit the registration information
Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts

Posted - 28 November 2004 :  16:19:19  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
quote:
Originally posted by JohnJohn1186

well, i didnt try to install another mod...its still the same mod. can i send you the register.asp code?

Sure you can, I'll have a look

eXtremeGossip
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  16:22:45  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
whats ur email?
Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts

Posted - 28 November 2004 :  16:26:00  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
Jorrit787@aol.com

eXtremeGossip
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  16:30:50  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
you got mail
Go to Top of Page

Jorrit787
Average Member

Netherlands
681 Posts

Posted - 28 November 2004 :  16:43:25  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
So do you

eXtremeGossip
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  22:48:07  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
Oh no man! You made it worse! Now i cant even open the register.asp heres da error:

Microsoft VBScript compilation error '800a03f6'

Expected 'End'

/vertical/forum/register.asp, line 610

else
^


CODE:

<!--#INCLUDE FILE="inc_mail.asp" -->
<%
end if
LINE 610 else
Response.Write " <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """ color=""" & strHiLiteFontColor & """>There Was A Problem With Your Details</font></p>" & vbNewLine & _
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  22:49:48  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
n/m about that man...i just added another end if and got it to work! Wow, your rubbing off on me lol
Go to Top of Page

JohnJohn1186
Junior Member

103 Posts

Posted - 28 November 2004 :  22:53:21  Show Profile  Send JohnJohn1186 an AOL message  Send JohnJohn1186 a Yahoo! Message
Ok, it works and all now, however, when ever i try to register it doesnt save it or something because i tried to register a new name, and it does not save that registration data...kinda like the poll mod i tried to install...it doesnt save the configuration on that either. >_<...any help?
Go to Top of Page

Tam
New Member

Sweden
56 Posts

Posted - 29 November 2004 :  04:20:44  Show Profile  Visit Tam's Homepage
Try to update your forumvariables with "Check installation" in the admin-settings.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07