| Author |
 Topic  |
|
|
szinski
Starting Member
12 Posts |
 Posted - 08 April 2001 : 09:24:46
|
when I login and tyr to access the moderator section I get this error:
Microsoft JET Database Engine error '80040e14'
Syntax error in query expression 'FORUM_ID = LastVisit=2001%2D01%2D22+09%3A03%3A27 AND MEMBER_ID = 1'.
/forum/inc_functions.asp, line 1089
Am I to delete the User No.1??
|
|
|
szinski
Starting Member
12 Posts |
Posted - 09 April 2001 : 11:05:18
|
I think I found the problem!
I can access the moderator setup from a another CPU. Meaning that something is wrong with the cookie. I deleted all my cookies.
(But it do not work LOL)
Any Ideas?
|
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 April 2001 : 12:51:38
|
What moderator section are you talking about?
|
|
|
|
szinski
Starting Member
12 Posts |
Posted - 10 April 2001 : 03:55:01
|
The one in Admin Options /Moderator Setup
When i access this page I get that error.
But When I access it from another cpu, I do not get this error.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 10 April 2001 : 17:07:30
|
Hmmm, don't know why it is doing that. The FORUM_ID should be a number, not your last visit date. It is getting that from your cookie. I don't know why. Here is something you can try, in your admin_moderators.asp page, do a search for "chkForumModerator". You will find 2 of them on one line. They should look something like this:chkForumModerator(Request("Forum"), rs("M_NAME"))Now I want you to change it, so it looks like this:chkForumModerator(Request.QueryString("Forum"), rs("M_NAME"))Add the part in red and let me know if it works.
|
|
|
|
szinski
Starting Member
12 Posts |
Posted - 11 April 2001 : 04:04:28
|
Sorry i get this error now, and I tested to delete the cookie:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_ID = AND MEMBER_ID = 1'.
/forum/inc_functions.asp, line 1089
And the line you wanted me to change like this:
<% if chkForumModerator(Request.QueryString("Forum"), rs("M_NAME")) then %><b><% end if %><a href="admin_moderators.asp?forum=<%=Request("Forum")%>&UserID=<%=rs("MEMBER_ID")%>"><%=rs("M_NAME")%></a><%If chkForumModerator(Request.QueryString("Forum"), rs("M_NAME")) Then%></b><%End If%>
by the way. I have added some mods:
Poll (slemmy)
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 11 April 2001 : 10:21:57
|
It shouldn't be doing that, unless you modified the inc_functions.asp or the admin_moderators.asp page.
Can you post a .txt version of your inc_functions.asp and admin_moderators.asp files, so I can take a look at them?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 12 April 2001 : 20:38:59
|
ok, well i tried your files on my forum and didn't get any error when using them. I'm guessing it might be a cookie issue.
Can you post a link to your forum so i can see first hand, the error you're getting?
You would need to email me your admin username and password.
|
|
|
|
szinski
Starting Member
12 Posts |
Posted - 21 April 2001 : 09:02:36
|
I found the problem!!
The cookie get weird if you are behind a proxy.
So I disabeld the proxy for my homepage...
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 April 2001 : 09:48:37
|
Glad you got it working! 
|
|
|
|
eduardo
Starting Member
1 Posts |
Posted - 01 June 2001 : 16:33:30
|
What did you make for desable the proxy?
I have the same error but I'm not using proxy! Any idea?
|
|
|
| |
Topic |
|
Topic Locked
