DisplayContent 0, 0, 2, 8, 0, 8, 250, 16, 0, 0, 2, 1, "Recent Forum Posts", "98%", "topic.asp"

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/content.asp, line 171

quote:

---

Originally posted by kingfenix

I can tell you that the problem, because I just suffered through getting this mod working myself..

you need to have the MsgIcons MOD installed, or atleast the database upgrades that it provides, I wouldnt recommend fully implementing it though because apparently it isnt ready for 3.4.03 quite yet...

Doug

---

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/content.asp, line 171

quote:

---

Originally posted by famdylan

I ran into something similar to homeacademy except in article.asp instead of content.asp:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/forum/article.asp, line 141

here is the offending line

rsTopic.open strSql, strConnString, 3, adLockReadOnly, adCmdText

anybody know what it is missing?

---

quote:

---

Originally posted by homeacademy

I finally got this mod working, by running the database upgrade files for both the msgicon mod and the avatar mod. Many thanks to kingfenix for the help in getting this working!

quote:

---

Originally posted by famdylan

I ran into something similar to homeacademy except in article.asp instead of content.asp:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/forum/article.asp, line 141

here is the offending line

rsTopic.open strSql, strConnString, 3, adLockReadOnly, adCmdText

anybody know what it is missing?

---

For you and others that are having the same problem as I was, I have zipped up the 2 database upgrades from the msgicon and avatar mods. They can be downloaded by clicking here. Note that the msgicon dbs file is run from Admin Options -> Mod Setup, while the code in the avatar database setup .asp file must be copied in to Admin Options -> Alternative Mod Setup. Also note that it is unnessary to run these files if you already have the msgicon and avatar mods installed. These files just allow this mod to work without msgicons and avatars. Let me know if this helps.

---

quote:

---

Originally posted by famdylan


Thanks fo the info but the problem is I have both those mods installed and still can not get the thing to work. Is the missing parameters related to the databse if I know that then I can maybe figure it out.

---

quote:

---

Originally posted by famdylan

Yeah I have both installed and working as far as I can tell. One thing I want to do is make a clean install of Snitz and redo the installs of those since I seem to have snockered the Active members page but that seems unrelated.

Homeacademy maybe if you email me an empty copy of your database or its layout I can compare it and see what field I am missing.

---

1. Content Display mod -- Have you downloaded any updates?
2. Your Forum - I don't think this works with anything except 3.4.x
3. The msgicon and avatar mods -- Make sure they are up to date as well

quote:

---

Originally posted by homeacademy

I am attempting to implement this mod on my 3.4.03 forum, using and Access database (does this work with Access ) and had a couple of problems. I intend to use it to display the topics from one forum page to the site's main page, located outside the forum directory. I followed the instructions in the readme (upload the images, a couple of .asp pages, and update the getCurrentIcon funtion) to create a file called cdisp.asp with the following DisplayContent call:

<% 
DisplayContent 1, 8, 1, 8, 0, 5, 50, 0, 0, 0, 0, 0, "Example of Community Forum", "75%", "topic.asp" 
%>

I used the INCLUDE VIRTUAL statements at the top/bottom of the page, because cdisp.asp is located outside the forum directory. A Page Not Found error was returned when I attempted to view the page in the browser. When looking at the address bar, it appears that my Access database is the missing file.

I moved the page to the forum directory and changed the include statements to INCLUDE FILE. This time, no Page Not Found error, but I had 2 other problems:

First, my forum is set to require registration, so anyone attempting to access it is first presented with a login screen. Since inc_header.asp is one of the includes, it asks me to login before viewing the cdisp.asp page as well. This is undesirable since I am using this mod on my main page, which needs to be viewable by non-registered members. Does anybody have a fix for this?

Second, after logging in to get past the initial problem, I am given the following error:

Microsoft JET Database Engine error '80040e10' 

No value given for one or more required parameters. 

/forum/content.asp, line 171

The few lines of code before/after 171 in content.asp are as follows:

set rs = Server.CreateObject("ADODB.Recordset")
	rs.cachesize = 21

[Line 171]rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText

if Not rs.EOF then
			arrTopicData = rs.GetRows(TopicCount,1)
			iTopicCount = UBound(arrTopicData, 2)
		else
			iTopicCount = ""
		end if

rs.close
set rs = nothing

Line 171 is in bold. Does anybody have any theories? Thanks!

---

quote:

---

Originally posted by homeacademy


For you and others that are having the same problem as I was, I have zipped up the 2 database upgrades from the msgicon and avatar mods. They can be downloaded by clicking here. Note that the msgicon dbs file is run from Admin Options -> Mod Setup, while the code in the avatar database setup .asp file must be copied in to Admin Options -> Alternative Mod Setup. Also note that it is unnessary to run these files if you already have the msgicon and avatar mods installed. These files just allow this mod to work without msgicons and avatars. Let me know if this helps.

---