| Author |
 Topic  |
|
|
phoenixtaz13
Junior Member
129 Posts |
 Posted - 19 February 2009 : 00:40:04
|
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....
< |
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 19 February 2009 : 01:45:16
|
there should be a comma between these 'T.T_MSGICON F.F_PRIVATEFORUMS'
like so 'T.T_MSGICON ,F.F_PRIVATEFORUMS'
< |
 |
|
|
phoenixtaz13
Junior Member
129 Posts |
Posted - 19 February 2009 : 03:10:11
|
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
Moderator
United States
5768 Posts |
Posted - 19 February 2009 : 07:47:05
|
| If memory serves, you'll want to search for the "Active Users" MOD. Don't have the link handy at the moment.< |
|
|
|
Carefree
Advanced Member
Philippines
4212 Posts |
Posted - 19 February 2009 : 08:06:21
|
| The original location for the Active Users' mod no longer exists so I uploaded it at SnitzBitz.< |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 19 February 2009 : 08:45:47
|
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.” |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Carefree
Advanced Member
Philippines
4212 Posts |
Posted - 19 February 2009 : 09:04:00
|
quote:
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
Forum Admin
United Kingdom
20593 Posts |
Posted - 19 February 2009 : 11:15:16
|
| 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
Junior Member
129 Posts |
Posted - 19 February 2009 : 11:45: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
Support Moderator
Ireland
6780 Posts |
Posted - 19 February 2009 : 11:51:13
|
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.” |
|
|
|
texanman
Junior Member
United States
410 Posts |
Posted - 19 February 2009 : 12:25:04
|
quote:
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.....
god bless...
Here< |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 19 February 2009 : 12:36:27
|
Good man, Texanman; had forgotten that one.
< |
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.” |
|
|
|
phoenixtaz13
Junior Member
129 Posts |
Posted - 19 February 2009 : 12:40:16
|
thanks for the time guys..... :)
i'll work on the mod now... :)
god bless....
< |
|
|
| |
Topic |
|
Active.asp error
