| Author |
 Topic  |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
 Posted - 22 March 2005 : 01:35:44
|
I installed the Active Users MOD, not for the first time, but this time I get this error on every page:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'MEMBER_ID ='.
/forums/inc_func_common.asp, line 58
Line 58 is the part of code that the Active Users MOD adds to inc_func_common . It's like the forum doesn't know my UserID, am I interpreting that right? |
eXtremeGossip  |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 22 March 2005 : 06:18:23
|
Can you do a response.write on the SQL string and post the output 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.” |
 |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 22 March 2005 : 16:01:59
|
SELECT AU_LASTACTIVETIME FROM FORUM_ACTIVE_USERS WHERE MEMBER_ID =
Like I said, it appears it doesn't retrieve my Member ID number  |
eXtremeGossip |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 22 March 2005 : 18:06:43
|
| Im suspecting that the error might be caused by some missing code in inc_header.asp. What happens if you comment out ActiveUserTracker() in inc_header.asp? Do the forum work as normal? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 23 March 2005 : 12:23:03
|
| Yes, apart from not showing any users online it works fine then. |
eXtremeGossip |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 24 March 2005 : 05:05:42
|
You're calling ActiveUsersTracker() before you call chkUser() which assigns a value to the MemberID variable. Try moving the call to ActiveUsersTracker() below the if statement it currently appears above.
|
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.” |
|
|
|
Jorrit787
Average Member
Netherlands
681 Posts |
Posted - 24 March 2005 : 19:20:24
|
| That seemed to do it... Thanks. |
eXtremeGossip |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 29 March 2005 : 07:47:25
|
You're welcome, Jorrit  Did the same meself once before, should've spotted it sooner.
|
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.” |
|
|
| |
Topic |
|
Topic Locked
