Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Strange Problem Occasionally With the Active Users
 New Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bobby131313
Senior Member

USA
1163 Posts

Posted - 16 August 2016 :  18:20:22  Show Profile  Visit bobby131313's Homepage  Reply with Quote
Here is the error I get occasionally, this has been going on for years, only happens once in a while and it's a Staff only page so I didn't worry about it too much.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 5.1 Driver][mysqld-5.5.29-log]Unknown column 'e' in 'where clause'
/active_users.asp, line 578



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
strSQL = Replace(strSql,"==","=")
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 target=""_blank"" href=""topic.asp?" & fQuery & """>"
else
strPage = fLang(strLangMOD_Ls3kAU_01320) & "<br><a target=""_blank"" href=""topic.asp?" & fQuery & """>"
end if
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01330)
end if
end if
end if


Line in red is 578.

Screenshot of where it quits



I'm going to hazard a guess and say it quits when there is an obscure character it the subject since that's where the page quits and column 'e' is the fifth letter and the subject is the fifth column.

This is on my stamp forum which uses a MySql DB.

Switch the order of your title tags

Edited by - bobby131313 on 16 August 2016 18:24:11

HuwR
Forum Admin

United Kingdom
20577 Posts

Posted - 16 August 2016 :  20:27:25  Show Profile  Visit HuwR's Homepage
The error is most likely in here fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID") since that is what sets the topicid may be worth checking the result of that isnumeric anf if it isn't write it to screen, that may hep see what is causing the error

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 16 August 2016 :  20:58:11  Show Profile  Visit bobby131313's Homepage
Thanks Hu, I'll give it a try.

Switch the order of your title tags
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 27 August 2016 :  15:09:44  Show Profile  Visit bobby131313's Homepage
I couldn't get it to write anything but that was the issue. I added this line...

if not IsNumeric(fTopic_ID) then fTopic_ID = ""

Then it just handles it like any other "Invalid Location"

Thanks again.

Switch the order of your title tags

Edited by - bobby131313 on 27 August 2016 15:10:03
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07