When deleting all unmoderated posts in a topic, you will get this error:Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/forum/pop_moderate.asp, line 377
To reproduce this, create a new topic in a moderated forum. As admin/moderator, view the moderated topic, click the "Approve/Hold/Reject all posts for this Topic" icon 
, in the right top hand corner (or right bottom hand corner) of the topic. Select "Delete" from the pop moderate window and you should get the error.
The SQL query look something like this:SELECT R.CAT_ID, R.FORUM_ID, R.TOPIC_ID, R.REPLY_ID, R.R_STATUS, R.R_DATE as Post_Date, M.M_NAME, M.MEMBER_ID
FROM FORUM_REPLY R, FORUM_MEMBERS M
WHERE (R.R_Status = 2 OR R.R_Status = 3) AND R.R_AUTHOR = M.MEMBER_ID AND R.REPLY_ID = X
The code in red is what is giving the error. Since I am deleting all posts, the REPLY_ID shouldn't be used in the query.
Line 371 in pop_moderate.asp, I included the code in red:if ModLevel <> "BOARD" then
if ModLevel = "CAT" then
strSql = strSql & " AND R.CAT_ID = " & CatID
elseif ModLevel = "FORUM" then
strSql = strSql & " AND R.FORUM_ID = " & ForumID
elseif ModLevel = "TOPIC" or ModLevel = "ALLPOSTS" then
strSql = strSql & " AND R.TOPIC_ID = " & TopicID
else
strSql = strSql & "AND R.REPLY_ID = " & ReplyID
end if
end if
This is the same code we use on line 233 when approving all topics.
Forum Locked
Topic Locked
Posted - 06 November 2003 : 02:34:43
