Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/68259?pagenum=1
05 November 2025, 10:42
Topic
phoenixtaz13
Active.asp error
19 February 2009, 00:40
good day to all.... :)
i've encountered a problem when i clicked the ACTIVE TOPICS link,
heres the error message: Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression 'T.T_MSGICON F.F_PRIVATEFORUMS' /forum/active.asp, line 310
in active.asp file points to the red: Set rs = Server.CreateObject("ADODB.Recordset") if strDBType <> "mysql" then rs.cachesize = 50 rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText how can i fix this?.... what is the meaning of the error?....
thanks in advance....
<
Replies ...
HuwR
19 February 2009, 01:45
there should be a comma between these 'T.T_MSGICON F.F_PRIVATEFORUMS' like so 'T.T_MSGICON ,F.F_PRIVATEFORUMS' <
phoenixtaz13
19 February 2009, 03:10
many thanks for ur time....
it works now... no more problem.... :)
btw, is there a mod that indicates if a member is online?... example, if i were reading a previous post, in the post, the reader is is aware that the author is online....
again, many, many thanks for ur time....
<
AnonJr
19 February 2009, 07:47
If memory serves, you'll want to search for the "Active Users" MOD. Don't have the link handy at the moment.<
Carefree
19 February 2009, 08:06
The original location for the Active Users' mod no longer exists so I uploaded it at SnitzBitz.<
Shaggy
19 February 2009, 08:45
Carefree, please remove it from SnitzBitz; it is only available here.
<
ruirib
19 February 2009, 08:53
Originally posted by Shaggy Carefree, please remove it from SnitzBitz; it is only available here.
Shaggy is right. The creator does not want the mod at Snitzbitz.<
Carefree
19 February 2009, 09:04
Originally posted by Shaggy Carefree, please remove it from SnitzBitz; it is only available here.
I tried to remove it, it will not allow me to do so. I emailed Davio asking him to remove it.<
HuwR
19 February 2009, 11:15
strictly speaking the author has no say in the matter since if they release it, it must be released under the GPL the same as Snitz, that means anybody can distribute it if they wish.<
phoenixtaz13
19 February 2009, 11:45
many, many, many thanks guyz.... :)
does the active user mod display an offline and online in the author's post?.... like under the avatar and says online or offline....
appreciate the help.....
god bless...
<
Shaggy
19 February 2009, 11:51
No. And I'm pretty sure the last version of that add-on is a couple of years out of date by now.
<
texanman
19 February 2009, 12:25
Originally posted by phoenixtaz13
does the active user mod display an offline and online in the author's post?.... like under the avatar and says online or offline....
appreciate the help.....