| Author |
 Topic  |
|
|
richfed
Average Member
United States
999 Posts |
 Posted - 10 November 2003 : 18:45:12
|
On occasions, and I haven't been able to figure out the circumstances that might be causing this, I get the following error when accessing active_users.asp:
quote:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/messageboard/active_users.asp, line 496
This text is in a black cell at top of the table. It is followed by the normal table data and then just turns to all black again, making the table incomplete.
The error refers to this section of code, line 496 in red:
quote:
case "topic.asp"
strQuery = fQuery
fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID")
if fTopic_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
strQuery = fQuery
if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
strSql = "SELECT FORUM_ID, TOPIC_ID, T_SUBJECT FROM " & strTablePrefix & "A_TOPICS WHERE TOPIC_ID=" & fTopic_ID
else
strSql = "SELECT FORUM_ID, TOPIC_ID, T_SUBJECT FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & fTopic_ID
end if
set rst = my_conn.execute(strSql)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("T_SUBJECT")
fForum_ID = rst("FORUM_ID")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strQuery = fQuery
if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
strPage = fLang(strLangMOD_Ls3kAU_01310) & "<br><a href=""topic.asp?" & fQuery & """>"
else
strPage = fLang(strLangMOD_Ls3kAU_01320) & "<br><a href=""topic.asp?" & fQuery & """>"
end if
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01330)
end if
end if
Might anyone know the cure? It doesn't happen often. Using 3.4.3 on SQL Server. |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
richfed
Average Member
United States
999 Posts |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 29 November 2003 : 08:09:20
|
I implented the fix as suggested in the reply above but ended up getting another occasional error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Invalid column name 'eply'.
/forum/active_users.asp, line 479
Getting anything similar, Richfed? |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
 |
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 01 December 2003 : 18:29:11
|
| VERY occassionally, but I thought it was related to a record being read and deleted at almost the same time. |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 01 December 2003 : 18:34:41
|
I've seen it a couple of times since I implemented the fix, as have some members. Seems a little too frequent to me to be that.
It was the "Invalid column name 'eply'." that puzzled me. eply being reply without the first character.
|
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 01 December 2003 : 18:36:54
|
| Typo maybe ? |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 01 December 2003 : 18:43:20
|
| CLng is a function. A type mismatch error means you're using an argument of the wrong datatype in that function ... definitely something to be looked at. |
|
|
|
MarkJH
Senior Member
United Kingdom
1722 Posts |
Posted - 01 December 2003 : 20:00:32
|
'## Forum_SQL
strSql = "SELECT F_PRIVATEFORUMS, F_SUBJECT, F_PASSWORD_NEW "
strSql = strSql & " FROM " & strTablePrefix & "FORUM "
strSql = strSql & " WHERE FORUM_ID = " & cLng(fForum)
Set rsStatus = Server.CreateObject("ADODB.Recordset")
rsStatus.open strSql, my_Conn
if rsStatus.EOF or rsStatus.BOF then
rsStatus.close
set rsStatus = nothing
Response.Redirect("default.asp")
else
dim Users
dim MatchFound
If rsStatus("F_PRIVATEFORUMS") <> 0 then
Select case rsStatus("F_PRIVATEFORUMS")
Somebody trying to view a private forum? A spider maybe? |
Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/ |
|
|
| |
Topic |
|
Topic Locked
