Active.asp error - Posted (1393 Views)
phoenixtaz13
Junior Member
phoenixtaz13
Posts: 129
129
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....












<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
HuwR
Forum Admin
HuwR
Posts: 20611
20611
there should be a comma between these 'T.T_MSGICON F.F_PRIVATEFORUMS'
like so 'T.T_MSGICON ,F.F_PRIVATEFORUMS'
<
Posted
phoenixtaz13
Junior Member
phoenixtaz13
Posts: 129
129
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....

<
Posted
AnonJr
Forum Moderator
AnonJr
Posts: 5768
5768
If memory serves, you'll want to search for the "Active Users" MOD. Don't have the link handy at the moment.<
Posted
Carefree
Advanced Member
Carefree
Posts: 4224
4224
The original location for the Active Users' mod no longer exists so I uploaded it at SnitzBitz.<
Posted
Shaggy
Support Moderator
Shaggy
Posts: 6780
6780
Carefree, please remove it from SnitzBitz; it is only available here.
<
Search is your friend “I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
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.<
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
Carefree
Advanced Member
Carefree
Posts: 4224
4224
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.<
Posted
HuwR
Forum Admin
HuwR
Posts: 20611
20611
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.<
Posted
phoenixtaz13
Junior Member
phoenixtaz13
Posts: 129
129
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... <
Posted
Shaggy
Support Moderator
Shaggy
Posts: 6780
6780
No. And I'm pretty sure the last version of that add-on is a couple of years out of date by now.
<
Search is your friend “I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
You Must enter a message