| Author |
 Topic  |
|
german
Starting Member
23 Posts |
 Posted - 25 November 2002 : 23:07:33
|
Hi @tomic
I get this error:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/content.asp, line 122
That line is:
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText
I imagine it has has to do with the SQL string somehow, but I am not sure.
I am using v 3.4.03 and I have the message icon mod and the custom avatar mods installed.
I believe i did everything correctly in the read me, just can't figure out where in the string the error is occurring, or what value is missing.
Any insight would be appreciated!
|
www.deeko.com |
 |
|
|
Aquillar
Starting Member
Canada
41 Posts |
Posted - 26 November 2002 : 10:21:32
|
| We're both having the same problem :S |
 |
|
|
|
german
Starting Member
23 Posts |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 27 November 2002 : 19:17:54
|
OK, I don't necessarily have an answer but I do have suggestions. Unfortunately, I have been unable to replicate this but these variations may help a few of you.
First. Here are the ado variable values from adovbs.inc(or adovbs.asp)
Const adOpenStatic = 3 (Cursor)
Const adLockReadOnly = 1 (Lock)
Const adCmdText = &H0001 (Command)
This is the default line 122 from the download:
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText
(3 = adOpenStatic)
Variation #1:
rs.open strSql, my_Conn, 3, 1, &H0001
Variation #2:
rs.open strSql, my_Conn, 3, 3
Variation #3:
rs.open strSql, my_Conn, 3, , &H0001
Variation #4:
rs.open strSql, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
(I believe this is the original from Rob Poretti's version)
Give these a try. If they don't work, posting some information about your server and database would be extremely useful considering the nature of this error. Just saying I have an error in line 122 when it's this particular line just tells me your not on my server, using my database. I had to play around with these variables myself to get this to work so I guess it's not surprising that you may need to as well.
@tomic
|
SportsBettingAcumen.com |
|
|
|
german
Starting Member
23 Posts |
Posted - 27 November 2002 : 23:33:40
|
Hi @tomic,
thanks for the suggestions. However none of them worked, and I have been able to determine that problem actully resides in the SQL string building (i think). I know this because i was able to simplify the sql string down to:
"Select * from forum_topics where topic_ID = 166"
and the error went away. The data obviously was not formatted correctly or of the right type, but at least it was calling the right record and the error went away.
So the code that builds that SQL string in the subroutine is, in my opinion, causing the problem. Could this be possible? |
www.deeko.com |
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 27 November 2002 : 23:42:20
|
Whoops, I should have looked more closely at your error. Yes, considering it said you are missing a parameter that is quite possible.
Do a Response.Write strSql immediately before line 122 and post the resulting string here.
What is your sub call anyway? Leaving one of those parameters out, any one og them, will result in that error.
@tomic |
SportsBettingAcumen.com |
|
|
|
german
Starting Member
23 Posts |
Posted - 28 November 2002 : 22:46:53
|
Here is the string when written out using response.write:
SELECT F.F_SUBJECT, F.F_DESCRIPTION, T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_MESSAGE, T.T_VIEW_COUNT, T.T_LAST_POST, T.T_DATE, T.T_REPLIES, T.T_AUTHOR, T.T_MSGICON, M.MEMBER_ID, M.M_NAME, M.M_EMAIL, M.M_RECEIVE_EMAIL, M.M_HOMEPAGE, M.M_PHOTO_URL, M.M_AVATAR_URL FROM ((FORUM_FORUM F INNER JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) INNER JOIN FORUM_MEMBERS M ON T.T_AUTHOR = M.MEMBER_ID) WHERE T.TOPIC_ID = 166 ORDER BY T.T_LAST_POST DESC
Here is my sub call:
DisplayContent 2, 166, 2, 12, 0, 1, 200, 0, 0, 0, 1, 0, "Top News Stories", 450, "test.asp"
Thanks for the help!
|
www.deeko.com |
|
|
|
german
Starting Member
23 Posts |
Posted - 01 December 2002 : 20:16:29
|
I figured it out.....
The sql string was trying to include a field that doesn't exist in the database - 'm_avatar_url'. My database field name for that item (because i have a different avatar mod installed) is 'm_avatar'.
That is what was causing the error.
Everything seems to work fine now. |
www.deeko.com |
|
|
|
Aquillar
Starting Member
Canada
41 Posts |
Posted - 01 December 2002 : 21:16:30
|
SELECT F.F_SUBJECT, F.F_DESCRIPTION, T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_MESSAGE, T.T_VIEW_COUNT, T.T_LAST_POST, T.T_DATE, T.T_REPLIES, T.T_AUTHOR, T.T_MSGICON, M.MEMBER_ID, M.M_NAME, M.M_EMAIL, M.M_RECEIVE_EMAIL, M.M_HOMEPAGE, M.M_PHOTO_URL, M.M_AVATAR_URL FROM ((FORUM_FORUM F INNER JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) INNER JOIN FORUM_MEMBERS M ON T.T_AUTHOR = M.MEMBER_ID) WHERE T.FORUM_ID = 3 ORDER BY T.T_LAST_POST DESC
That could be it german, where can we change that? |
|
|
|
|
german
Starting Member
23 Posts |
Posted - 02 December 2002 : 13:09:42
|
Look in your content.asp file, around line 75.
If you are using the custom avatar mod, then you need to change the 'M.M_AVATAR_URL' to 'M.M_AVATAR' in the SQL string.
Hope this helps! |
www.deeko.com |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
Aquillar
Starting Member
Canada
41 Posts |
Posted - 08 December 2002 : 11:39:14
|
Didn't work:
SELECT F.F_SUBJECT, F.F_DESCRIPTION, T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_SUBJECT, T.T_MESSAGE, T.T_VIEW_COUNT, T.T_LAST_POST, T.T_DATE, T.T_REPLIES, T.T_AUTHOR, T.T_MSGICON, M.MEMBER_ID, M.M_NAME, M.M_EMAIL, M.M_RECEIVE_EMAIL, M.M_HOMEPAGE, M.M_PHOTO_URL, M.M_AVATAR FROM ((FORUM_FORUM F INNER JOIN FORUM_TOPICS T ON F.FORUM_ID = T.FORUM_ID) INNER JOIN FORUM_MEMBERS M ON T.T_AUTHOR = M.MEMBER_ID) WHERE T.FORUM_ID = 3 ORDER BY T.T_LAST_POST DESC
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/forums/content.asp, line 123
|
|
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 14 December 2002 : 13:03:15
|
Well I am going to try this again. I was hopping this mod is farther along. Has anyone got it to work?
I have reinstalled a fresh version of the forum and installed avitar and msgicon mods...all good
I have installed the content display as per the instructions and have put below on my front asp page:
<!--#INCLUDE VIRTUAL="/funforum/config.asp"-->
<!--#INCLUDE VIRTUAL="/funforum/inc_func_secure.asp" -->
<!--#INCLUDE VIRTUAL="/funforum/inc_sha256.asp"-->
<!--#INCLUDE VIRTUAL="/funforum/inc_header.asp" -->
<!--#INCLUDE VIRTUAL="/funforum/content.asp" -->
<!--#INCLUDE VIRTUAL="/funforum/inc_contentdisplay.asp" -->
and put:
<% DisplayContent 0, 3, 2, 12, 0, 5, 200, 0, 5, 1, 1, 0, "Top News Stories", 300, "topic.asp" %>
where I want the messages to appear but this is error I am getting:
Microsoft JET Database Engine error '80004005'
'D:\html\users\funinbccom\xxxx\xxx_forums_2000.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/funforum/inc_header.asp, line 114
My goal is to get this going like Jeep Aholics site @
http://www.jeepaholics.com/default.asp
I know this thread is long but can anyone give me a hand?
|
Edited by - funinbc on 26 December 2002 15:01:40 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 15 December 2002 : 18:24:41
|
@tomic, thanks for making this mod. I've installed it now and it works like a charm. The new parameters are very handy, and it is easy to add new functions and modify the existing ones (as it was in the 3.3.xx version).
Good job. 
Is CD still in beta, or? Are there any known bugs remaining to be fixed?
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Heynow
Junior Member
374 Posts |
Posted - 15 December 2002 : 18:33:54
|
Does anyone know of a fix for the flash? I get an error on the front page when someone posts flash. The only way for me to do this is to post flash in a reply which is ok, but my members don't know this. I did warn them, but not all read very well.
Thanks |
Political Forums:::Stay n Chat
 |
|
|
|
Topic |
|
|
|
Topic Locked
