| Author |
 Topic  |
|
Tmpj
Junior Member
Denmark
467 Posts |
 Posted - 25 June 2002 : 10:39:10
|
Today when I will test my new International Forum I found a suntax error.
When I have created a forum (Only members could Access) and go into it and logs out there I get this:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'mo.FORUM_ID = AND mo.MEMBER_ID = me.MEMBER_ID AND me.M_NAME = 'Admin''.
/forum/inc_functions.asp, line 1108
------------------------------
Magic is an Orange
http://www.magicorange.tk
[moved by bozden on 02 October 2002]
< |
Edited by - Deleted on 02 October 2002 22:38:06 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 June 2002 : 13:00:34
|
There is a value missing where indicated:
mo.FORUM_ID = value missing hereAND mo.MEMBER_ID = me.MEMBER_ID AND me.M_NAME = 'Admin'.
What version are you using. Have you applied all the patches? Any mods?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
 |
|
|
Tmpj
Junior Member
Denmark
467 Posts |
Posted - 25 June 2002 : 13:54:44
|
quote:
There is a value missing where indicated:
mo.FORUM_ID = value missing hereAND mo.MEMBER_ID = me.MEMBER_ID AND me.M_NAME = 'Admin'.
What version are you using. Have you applied all the patches? Any mods?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
I use the beta 3 and Yes I have applied all the patches
------------------------------
Magic is an Orange
http://www.magicorange.tk< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Tmpj
Junior Member
Denmark
467 Posts |
Posted - 25 June 2002 : 14:30:32
|
quote:
What about the mods?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
I have theese:
Private Messages
My Personalization
Header Cell Image
Flood Control
MSN Messenger (The big version with Messenger filed in registration)
------------------------------
Magic is an Orange
http://www.magicorange.tk< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Tmpj
Junior Member
Denmark
467 Posts |
Posted - 25 June 2002 : 17:30:02
|
quote:
Is it when you try to go to forum.asp that that happens?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
When I'm in a forum (Only for members) and logsout from there.
------------------------------
Magic is an Orange
http://www.magicorange.tk< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 June 2002 : 17:50:04
|
What I can tell you is that is a problem with the code modifications you inserted. My v. 4.0Beta3Patch04 version runs perfectly Ok in that situation.
There is only one thing I can suggest: start with a fresh forum.asp. Test to see if the situation happens. It should not happen with the unchanged forum.asp that comes in the v4 download. Then add the modifications for each of your mods, one mod a time. After adding a mod, test to see if the problem shows up. If it shows, review the changes you made. If it doesn't then you're done.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
Tmpj
Junior Member
Denmark
467 Posts |
Posted - 25 June 2002 : 18:22:46
|
quote:
What I can tell you is that is a problem with the code modifications you inserted. My v. 4.0Beta3Patch04 version runs perfectly Ok in that situation.
There is only one thing I can suggest: start with a fresh forum.asp. Test to see if the situation happens. It should not happen with the unchanged forum.asp that comes in the v4 download. Then add the modifications for each of your mods, one mod a time. After adding a mod, test to see if the problem shows up. If it shows, review the changes you made. If it doesn't then you're done.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
I looked in my forum.asp and I see that I never have make modifications in it, I have tryed to replace it with a fresh one, but it gives me the same error, but the sql line that gives the error is in inc_functions.asp I have tryed to replace the lines with some fresh, but still with the same result.
In your first reply you say that there are some missing could you what it is?
------------------------------
Magic is an Orange
http://www.magicorange.tk< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Tmpj
Junior Member
Denmark
467 Posts |
Posted - 25 June 2002 : 19:21:39
|
quote:
That's a weird problem. It looks like some parameters are not being sent to the function. I saw a similar situation happening at that same line. Read this: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26004
Maybe try to apply the same fix. Keep a copy of the files before changing them, so that you can revert it.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Are you sure that is the right topic? There are only a link to the Easy Moderation Setup MOD.
I will anyway have it installed so I have done it, but it have not fixed the problem 
------------------------------
Magic is an Orange
http://www.magicorange.tk< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 June 2002 : 19:27:41
|
Don't know whats happening there...
have you changed inc_moderation.asp?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
Tmpj
Junior Member
Denmark
467 Posts |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 25 June 2002 : 19:29:09
|
could you post the database query that starts a few lines above line number 1108?
Crash's Site | Crash is from 
< |
|
|
|
Tmpj
Junior Member
Denmark
467 Posts |
Posted - 25 June 2002 : 19:32:00
|
Sure here it is:
function chkForumModerator(fForum_ID, fMember_Name)
'## Forum_SQL
strSql = "SELECT mo.FORUM_ID "
strSql = strSql & " FROM " & strTablePrefix & "MODERATOR mo, " & strTablePrefix & "MEMBERS me "
strSql = strSql & " WHERE mo.FORUM_ID = " & fForum_ID & " "
strSql = strSql & " AND mo.MEMBER_ID = me.MEMBER_ID "
------------------------------
Magic is an Orange
http://www.magicorange.tk< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 June 2002 : 19:34:31
|
The problem Crash is that FORUM_ID is not being passed with a value to the function...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs< |
|
|
|
Topic |
|
