| Author |
 Topic  |
|
Capt_Dunzell
Junior Member
USA
160 Posts |
 Posted - 09 November 2001 : 23:35:44
|
I was able to create an archive successfully, I can see it in the database, but when I click on the link in the forum to see the archive I get this error:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/forum.asp, line 245
Line 245 of forum.asp starts with this:
rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = strPageSize
maxpages = cint(rs.pagecount)
rs.absolutepage = mypage
end if
Any ideas?
http://66.34.117.92/forum/ |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 00:00:58
|
I'm guessing your using access 2000? or access 97 with the access 2000 connstring?
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
 |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 00:07:28
|
can you put a response.write right before the recordset? I looked through the sql code but didnt see anything right off. Can you change that code to look like the below?
response.write(strSql)
rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = strPageSize
maxpages = cint(rs.pagecount)
rs.absolutepage = mypage
end if
And then post the results here?
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 10 November 2001 : 00:11:18
|
That gives me this:
SELECT FORUM_A_TOPICS.T_STATUS, FORUM_A_TOPICS.CAT_ID, FORUM_A_TOPICS.FORUM_ID, FORUM_A_TOPICS.TOPIC_ID, FORUM_A_TOPICS.T_VIEW_COUNT, FORUM_A_TOPICS.T_SUBJECT, FORUM_A_TOPICS.T_AUTHOR, FORUM_A_TOPICS.T_REPLIES, FORUM_A_TOPICS.T_LAST_POST, FORUM_A_TOPICS.T_LAST_POST_AUTHOR, FORUM_A_TOPICS.T_MSGICON, FORUM_MEMBERS.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME FROM FORUM_MEMBERS, FORUM_A_TOPICS, FORUM_MEMBERS AS MEMBERS_1 WHERE FORUM_MEMBERS.MEMBER_ID = FORUM_A_TOPICS.T_AUTHOR AND FORUM_A_TOPICS.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID AND FORUM_A_TOPICS.FORUM_ID = 4 ORDER BY FORUM_TOPICS.T_INPLACE DESC , FORUM_TOPICS.T_LAST_POST DESC
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum.asp, line 246
http://66.34.117.92/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 00:29:35
|
Ok I found the problem, searching the code to make a fix...
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 00:34:25
|
Ok someone I need help with this. The problem is the following
ORDER BY FORUM_TOPICS.T_INPLACE DESC , FORUM_TOPICS.T_LAST_POST DE
Nothing is being called from FORUM_TOPICS - thats where the error is being generated, BUT I cant find that sql anywhere! This is what I found and it shouldnt generate the above line.
strSql = strSql & " ORDER BY " & strActivePrefix & "TOPICS.T_LAST_POST DESC "
Any Idea's? I did a global search for T_INPLACE and couldnt find anything
Did you install a mod that altered the code at all Dunzell?
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource
Edited by - da_stimulator on 10 November 2001 00:36:49 |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 00:39:30
|
Yeah I'm guessing you installed the sticky topics mod, which alters some of that to show topics up top first right? If so I need you to post the code you have from lines 170-185 please so I can take a look at the altered code.
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 10 November 2001 : 00:55:14
|
170 - 185
strSql = strSql & strActivePrefix & "TOPICS.T_AUTHOR, "
strSql = strSql & strActivePrefix & "TOPICS.T_REPLIES, "
strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST, "
strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST_AUTHOR, "
strSql = strSql & strActivePrefix & "TOPICS.T_MSGICON, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & "MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS, "
strSql = strSql & strActivePrefix & "TOPICS, "
strSql = strSql & strMemberTablePrefix & "MEMBERS AS MEMBERS_1 "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strActivePrefix & "TOPICS.T_AUTHOR "
strSql = strSql & " AND " & strActivePrefix & "TOPICS.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID "
strSql = strSql & " AND " & strActivePrefix & "TOPICS.FORUM_ID = " & Forum_ID & " "
if nDays = "-1" then
strSql = strSql & " AND " & strActivePrefix & "TOPICS.T_STATUS <> 0 "
end if
http://66.34.117.92/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 01:08:32
|
Ok I'm really sorry :( but I need the code 15 lines down from that... I hate to do this but could you count down 15 lines and give me 10 lines from that? Just say so if I'm confusing you
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 10 November 2001 : 01:11:19
|
200 - 210
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_INPLACE DESC "
strSql = strSql & " , " & strTablePrefix & "TOPICS.T_LAST_POST DESC "
if strDBType = "mysql" then 'MySql specific code
if mypage > 1 then
intOffset = CInt((mypage-1) * strPageSize)
strSql = strSql & " LIMIT " & intOffset & ", " & strPageSize & " "
end if
'## Forum_SQL - Get the total pagecount
strSql2 = "SELECT COUNT(" & strActivePrefix & "TOPICS.TOPIC_ID) AS PAGECOUNT "
Not a problem, I appreciate your help 
http://66.34.117.92/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 01:15:03
|
Ok - heres the problem. Change this:
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_INPLACE DESC "
strSql = strSql & " , " & strTablePrefix & "TOPICS.T_LAST_POST DESC "
to this
strSql = strSql & " ORDER BY " & strActivePrefix & "TOPICS.T_LAST_POST DESC "
Let me know if it works :)
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 10 November 2001 : 01:21:00
|
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum.asp, line 244
244 - 250
rs.open strSql, my_conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = strPageSize
maxpages = cint(rs.pagecount)
rs.absolutepage = mypage
end if
http://66.34.117.92/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 01:27:58
|
ok I'm stumped, can you just send me your forum.asp through email?
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 November 2001 : 01:53:05
|
This was discussed before, but I think it was lost with the messages we lost.
For any MOD that modifies either the FORUM_TOPICS OR FORUM_REPLY table, it will also need to modify the FORUM_A_TOPICS and FORUM_A_REPLY table. If it doesn't, then when you try to view a topic in the archive, the Database field won't exist and you'll get the error that you are seeing. |
|
|
|
Topic |
|
Topic Locked
