Active.asp error - نوشته شده در (1394 Views)
Junior Member
phoenixtaz13
مطلب: 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....












<
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Forum Admin
HuwR
مطلب: 20611
20611
there should be a comma between these 'T.T_MSGICON F.F_PRIVATEFORUMS'
like so 'T.T_MSGICON ,F.F_PRIVATEFORUMS'
<
نوشته شده در
Junior Member
phoenixtaz13
مطلب: 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....

<
نوشته شده در
Forum Moderator
AnonJr
مطلب: 5768
5768
If memory serves, you'll want to search for the "Active Users" MOD. Don't have the link handy at the moment.<
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
The original location for the Active Users' mod no longer exists so I uploaded it at SnitzBitz.<
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
نوشته شده در
Snitz Forums Admin
ruirib
مطلب: 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.<
نوشته شده در
Advanced Member
Carefree
مطلب: 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.<
نوشته شده در
Forum Admin
HuwR
مطلب: 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.<
نوشته شده در
Junior Member
phoenixtaz13
مطلب: 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... <
نوشته شده در
Support Moderator
Shaggy
مطلب: 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.”
شما باید یک متن وارد کنید