| Author |
 Topic  |
|
modifichicci
Average Member
Italy
787 Posts |
 Posted - 08 November 2006 : 18:27:56
|
We get sometimes this error
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cLng'
/forum/inc_func_secure.asp, line 167
in active_users.asp but I cannot find why.
This doesn't happen every time, but sometimes expecially when I have some spiders in the forum.
Someone has sone advices?
The forum is modded, but I cannot figure where is the bug.. |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 08 November 2006 : 18:30:05
|
| sounds like the spiders are maybe trying to index a private forum |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 09 November 2006 : 11:36:54
|
Yes I was thinking the same, but how can I fix it?
The lines are
strSql = "SELECT F_PRIVATEFORUMS, F_SUBJECT, F_PASSWORD_NEW "
strSql = strSql & " FROM " & strTablePrefix & "FORUM "
strSql = strSql & " WHERE FORUM_ID = " & cLng(fForum)
and I have tryed to put a control before with an if fForum <> "" then to avoid null value, but error come again.
How can I check the value the function is working on? I have put a response.write fforum , buty it show the number when all is ok but not when there is the error.
It is not a great issue, but it is ugly, as it happens sometimes.. |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
|
sylunt1
Starting Member
16 Posts |
Posted - 09 November 2006 : 18:54:55
|
Does this mod work with the new version of Snitz? If so does anyone have the files/instructions? I had in installed but can not find the files/instructions and now that I upgraded it doesnt work.
Thanks,
Chris |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 10 November 2006 : 10:42:15
|
sylunt1
yes this mod works with the new snitz forums and if you follow the readme for the 3.4 install you will be able to install this. I have the latest version of snitz and the latest version of active users. Both work wonderfully.
|
|
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 12 January 2007 : 15:48:26
|
May be I have solved:
I inserted thi snew function in active_users.asp
:
sub ForumPrivati(fForum_ID)
strSql = "SELECT F_SUBJECT, F_PRIVATEFORUMS, F_PASSWORD_NEW FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & fForum_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
rst.close
set rst = nothing
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("F_SUBJECT")
fPrivateForums = rst("F_PRIVATEFORUMS")
fFPasswordNew = rst("F_PASSWORD_NEW")
rst.close
set rst = nothing
end if
end sub
then I have changed all
if chkForumAccess(fForum_ID, MemberID, false) then
with
call ForumPrivati(fForum_ID)
if chkForumAccessNew(fPrivateForums, fFPasswordNew, fSubject, fForum_ID, MemberID) then
I haven't had error and if someone is in a private forum there is the message "private forum"
advices welcome... |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
Edited by - modifichicci on 12 January 2007 15:49:36 |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 05 June 2007 : 15:30:25
|
Tried these changes, modifichicci and got this error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'chkForumAccessNew'
/forum/active_users.asp, line 803
Line 803 being:
if chkForumAccessNew(fPrivateForums, fFPasswordNew, fSubject, fForum_ID, MemberID) then
 |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 05 June 2007 : 19:46:42
|
I'm getting this error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Invalid column name 'eply'.
/forum/active_users.asp, line 1043
sub ForumPrivati(fForum_ID)
strSql = "SELECT F_SUBJECT, F_PRIVATEFORUMS, F_PASSWORD_NEW FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & fForum_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
rst.close
set rst = nothing
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("F_SUBJECT")
fPrivateForums = rst("F_PRIVATEFORUMS")
fFPasswordNew = rst("F_PASSWORD_NEW")
rst.close
set rst = nothing
end if
end sub
Thing is, I randomly got that error before I put your code in. I've never got to the bottom of it.  |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Hermes
Junior Member
Croatia
113 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 June 2007 : 08:48:45
|
| Yeah, but the kicker is that neither field is in the SQL statement... nor is it accepting user input - unless wherever ForumPrivati is being called from on the times it errors isn't checking what its passing as fForum_ID properly... have fun tracking that down. |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 06 June 2007 : 12:19:08
|
This one comes up to; before and after adding modifichicci's code ie. it's an old bug!
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/forum/active_users.asp, line 724
case "forum.asp"
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
if fForum_ID = "" then
strPage = fscript & "?" & fquery 'fLang(strLangMOD_Ls3kAU_01270)
else
strSql = "SELECT F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & fForum_ID
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fscript & "?" & fquery' fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("F_SUBJECT")
rst.close
set rst = nothing
call ForumPrivati(fForum_ID
quote:
I’m total newb. considering this theme, but that eply sound to me like misspelling reply.
It's something to do with the word "reply", without a doubt. I just wish that somebody had an inkling of why these errors come up. |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
Topic |
|
Topic Locked
