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: MOD Implementation
 '80040e14' in active_users.asp
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

JBaldwin
Junior Member

USA
137 Posts

Posted - 19 November 2005 :  20:09:35  Show Profile
Any ideas?

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'TOPIC_ID==72'.

/forum/forum2/active_users.asp, line 413



    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
'Line 413        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
      end if


AbsolutelyFreerolls.com - Poker Freeroll Listings, Poker Forum and Poker News


laser
Advanced Member

Australia
3859 Posts

Posted - 19 November 2005 :  20:41:16  Show Profile
Looks like you have one too many = in there, just before Line 413 add this line (for testing only):

response.write strSql

and post what you get if you can't see what's wrong.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 November 2005 :  02:21:16  Show Profile  Send ruirib a Yahoo! Message
What Active Users version are you using? I've seen this error before, I thought it was corrected in the mod's latest version...


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 20 November 2005 :  06:23:27  Show Profile
Not sure on version, 4017 rings a bell though but I've had it installed for years.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 November 2005 :  09:59:52  Show Profile  Send ruirib a Yahoo! Message
Search is the answer: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=52939&SearchTerms=TOPIC_ID==


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 November 2005 :  10:01:52  Show Profile  Send ruirib a Yahoo! Message
Funny thing, laser, seems like you provided the fix for this exact issue...


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07