| Author |
 Topic  |
|
|
mahvin
Starting Member
48 Posts |
 Posted - 29 April 2008 : 19:11:53
|
This happens when archived posts is selected:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'Topic_Replies'
/forum/search.asp, line 755
Line 755 in search.asp looks like:
sub TopicPaging()
mxpages = (Topic_Replies / strPageSize)
if mxPages <> cLng(mxPages) then
mxpages = int(mxpages) + 1
end if
And then a second error occurs when Archived Posts is NOT selected using the same search string:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'Topic_Replies'
/forum/search.asp, line 497
Line 497 in search.asp looks like:
if ModerateAllowed = "Y" and Topic_UReplies > 0 then
Topic_Replies = Topic_Replies + Topic_UReplies
end if
|
Edited by - mahvin on 29 April 2008 19:23:23 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
mahvin
Starting Member
48 Posts |
Posted - 29 April 2008 : 19:24:11
|
| Poll MOD, which is working great, BTW... is the most recently installed, but I do have Gatekeeper Antispam and Forum Rules installed as well... |
Edited by - mahvin on 29 April 2008 19:28:38 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 April 2008 : 19:31:50
|
| This does not happen in a base version, so I would suggest that you check the changes made to search.asp. Probably starting with a clean search.asp, testing it, and then add the changes required by the mods, while testing it after each mod addition (though I think only the poll mod requires changes to search.asp). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
mahvin
Starting Member
48 Posts |
Posted - 29 April 2008 : 19:54:38
|
Fixed!
I guess my exposure to ASP is paying off, I found two instances of the same code in the search.asp. In the "modify line 211" code suggestions, I had entered the required code for the Poll in addition to the code that already existed, so I had two lines of code competing for the same query:
strSql = strSql & ", T.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST, T.T_ISPOLL"
strSql = strSql & ", T.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST"
I removed the second line and now it works just fine. |
Edited by - mahvin on 29 April 2008 19:55:55 |
|
|
| |
Topic |
|
Topic Locked
