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
 New Forum in old Category
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Nina
Starting Member

34 Posts

Posted - 20 March 2006 :  14:01:16  Show Profile  Visit Nina's Homepage
I've never had this problem before, but when I just tried to add a new forum in one of my categories, I got this message:

Microsoft JET Database Engine error '80040e14'

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

/post_info.asp, line 1242


I tried adding a new forum to one of the other categories, but still get the same message. Does anyone know what it means?

Thanks-
Nina

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 March 2006 :  17:17:55  Show Profile  Send ruirib a Yahoo! Message
You changed post_info.asp and there was some mistake in the changes you made.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Nina
Starting Member

34 Posts

Posted - 20 March 2006 :  17:27:38  Show Profile  Visit Nina's Homepage
Thanks, Rui.

My web host added the mod that sets time limits on members editing or deleting posts found here:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=56791

Would the erroneous line be easy to find by the number used: "line 1242"?

Thanks-
Nina
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 March 2006 :  19:57:35  Show Profile  Send ruirib a Yahoo! Message
It's the SQL statement imediately before that line. Probably he should write it using Response.Write and find out the error.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 21 March 2006 :  12:31:37  Show Profile
Sounds like its missing one of the code blocks marked in red below. Just above line 1242
	if Err_Msg = "" then
		'## Forum_SQL - Do DB Update
		strSql = "INSERT INTO " & strTablePrefix & "FORUM "
		strSql = strSql & "(CAT_ID"
		strSql = strSql & ", F_STATUS"
		if strPrivateForums = "1" then
			strSql = strSql & ", F_PRIVATEFORUMS"
			if Request.Form("AuthPassword") <> " " then
				strSql = strSql & ", F_PASSWORD_NEW"
			end if
		end if
		'strSql = strSql & ", F_LAST_POST"
		strSql = strSql & ", F_SUBJECT"
		strSql = strSql & ", F_DESCRIPTION"
		strSql = strSql & ", F_TYPE" 
		strSql = strSql & ", F_L_ARCHIVE "
		strSql = strSql & ", F_ARCHIVE_SCHED "
		strSql = strSql & ", F_L_DELETE "
		strSql = strSql & ", F_DELETE_SCHED "
	        strSql = strSql & ", F_SUBSCRIPTION"
	      	strSql = strSql & ", F_MODERATION"
		strSql = strSql & ", F_ORDER "
		strSql = strSql & ", F_DEFAULTDAYS "
		strSql = strSql & ", F_COUNT_M_POSTS "
'## Edit Time Mod ### ADD Code below ##############################################################################################################
                if Time_Limits then
                        strSql = strSql & ", F_EDIT_TIME "
                end if
'## End Add on ####################################################################################################################################
		strSql = strSql & ") VALUES ("
		strSql = strSql & Cat_ID
		strSql = strSql & ", 1 "
		if strPrivateForums = "1" then
			strSql = strSql & ", " & Request.Form("AuthType") & ""
			if Request.Form("AuthPassword") <> " " then
				strSql = strSql & ", '" & ChkString(Request.Form("AuthPassword"),"SQLString") & "'"
			end if
		end if
		'strSql = strSql & ", " & "'" & DateToStr(strForumTimeAdjust) & "'"
		strSql = strSql & ", '" & txtSubject & "'"
		strSql = strSql & ", '" & txtMessage & "'"
		strSql = strSql & ", " & ChkString(Request.Form("Type"), "SQLString")
		strSql = strSql & ", '' "
		strSql = strSql & ", 30 "
		strSql = strSql & ", '' "
		strSql = strSql & ", 365 "
	        ' DEM --> Start of Code added for moderation and subscription
	        if strSubscription > 0 and CatSubscription > 0 and strEmail = "1" then
	                strSql = strSql & ", " & fSubscription
	        else
	                strSql = strSql & ", 0"
	        end if
	        if strModeration = 1 and CatModeration = 1 then
	                strSql = strSql & ", " & ChkString(Request.Form("Moderation"), "SQLString")
	        else
	                strSql = strSql & ", 0"
	        end if
	        ' DEM --> End of Code added for moderation and subscription
		strSql = strSql & ", 1 "
		strSql = strSql & ", " & ChkString(Request.Form("DefaultDays"), "SQLString")
		strSql = strSql & ", " & ChkString(Request.Form("ForumCntMPosts"), "SQLString")
'## Edit Time ### Add code below #######################################################################################################################
                if Time_Limits then
                        strSql = strSql & ", '" & strTimeArr & "'"
                end if
'## End code add on ####################################################################################################################################
	        strSql = strSql & ")"

		my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords

    _-/Cripto9t\-_
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.43 seconds. Powered By: Snitz Forums 2000 Version 3.4.07