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
 Active Users with the Calendar Mod
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

DaMegz
Junior Member

126 Posts

Posted - 25 October 2002 :  17:40:45  Show Profile
Here's the error I'm getting. WHen I go to the Active users page, I get
quote:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'TOPIC_ID==78'.

/forum/active_users.asp, line 411


I noticed that this error only occurs when a user is viewing an event from the calendar mod. The user doesnt get any errors, only the admin when I am checking out "active users". As soon as the user goes on to a "non" event topic, the error goes away, and there are no errors.
I am not a programmer or an asp expert at all, but it seems to me that the problem is Topic_id==78.
Thanks!

laser
Advanced Member

Australia
3859 Posts

Posted - 25 October 2002 :  17:48:35  Show Profile
Interesting !!!

I have been getting this problem on the AU page VERY occassionally, so I couldn't put my finger on what was wrong. I'll check it out, but the == does look sus.
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 25 October 2002 :  17:54:13  Show Profile
I just tested this ... it seems to crash whilst trying to populate the 'Current Page' field. Anyone know what's wrong here ?
Go to Top of Page

DaMegz
Junior Member

126 Posts

Posted - 25 October 2002 :  18:01:33  Show Profile
Thanks laser...any help would be great.
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 25 October 2002 :  18:42:01  Show Profile
Now THAT was a tricky problem ... there are two potential methods to fix this, I'll present both :

A. In cal.asp, replace all instances of

topic_ID="

with

TOPIC_ID="

(it is only a change in case, and there should be two instances to change, green->red)


B. In active_users.asp, find :


function analyzeQuery(strQuery, varName)
  strQuery = Mid(strQuery, instr(strQuery, varName)+1+Len(varName))
  if instr(strQuery, "&") then
    strQuery = Mid(strQuery, 1, instr(strQuery, "&"))
    strQuery = Mid(strQuery, 1, Len(strQuery)-1)
  end if
  analyzeQuery = strQuery 
end function


replace with


function analyzeQuery(strQuery, varName)
  strQuery = Mid(strQuery, instr(1,strQuery, varName,1)+1+Len(varName))
  if instr(strQuery, "&") then
    strQuery = Mid(strQuery, 1, instr(strQuery, "&"))
    strQuery = Mid(strQuery, 1, Len(strQuery)-1)
  end if
  analyzeQuery = strQuery 
end function


The original code is case sensitive, so it only searches for TOPIC_ID and not topic_ID, so I prefer this solution because it guards against further case insensitive mods.


Hope it helps


Edited by - laser on 25 October 2002 18:43:43
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 25 October 2002 :  19:43:44  Show Profile  Visit Jeepaholic's Homepage
Wow. Great catch. Just validated that it works on my system (Fix B).

Al Bsharah
Aholics.com

Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight

Edited by - Jeepaholic on 25 October 2002 19:44:01
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 25 October 2002 :  19:50:19  Show Profile
It took me a while to track down, but seeing that every MOD I want/need has already been invented then I have no option but to do this sort of thing LOL.

It was only some links in cal.asp that have the lower case option.
Go to Top of Page

Jeepaholic
Average Member

USA
697 Posts

Posted - 25 October 2002 :  19:58:38  Show Profile  Visit Jeepaholic's Homepage
Not bad for just waking up. <grin>

Al Bsharah
Aholics.com

Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
Go to Top of Page

OpenIntro
Junior Member

USA
126 Posts

Posted - 21 November 2002 :  21:52:20  Show Profile  Send OpenIntro an AOL message
DANG ya'll are good!!!! Worked like a charm!

Let's All Do Kamikaze Shots!
http://www.kamikazeshots.com
http://www.kamikazeshots.com/forum
*DO YOUR CLICKS!*
http://dailyclicks.kamikazeshots.com

Edited by - OpenIntro on 22 November 2002 03:19:13
Go to Top of Page

hmmm
Starting Member

35 Posts

Posted - 11 January 2003 :  21:14:53  Show Profile
This should be mentioned in the install instructions for this mod maybe. Its a very easy fix for a problem that everyone using these two mods together will undoubtedly see.

Thanks laser!!
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.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07