Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Internationalization (v4-archive)
 Syntax Error
 New Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  10:39:10  Show Profile  Reply with Quote
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  Show Profile  Send ruirib a Yahoo! Message
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
<
Go to Top of Page

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  13:54:44  Show Profile
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<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2002 :  14:02:16  Show Profile  Send ruirib a Yahoo! Message
What about the mods?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
<
Go to Top of Page

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  14:30:32  Show Profile
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<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2002 :  17:23:09  Show Profile  Send ruirib a Yahoo! Message
Is it when you try to go to forum.asp that that happens?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
<
Go to Top of Page

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  17:30:02  Show Profile
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<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2002 :  17:50:04  Show Profile  Send ruirib a Yahoo! Message
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
<
Go to Top of Page

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  18:22:46  Show Profile
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<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2002 :  18:43:44  Show Profile  Send ruirib a Yahoo! Message
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
<
Go to Top of Page

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  19:21:39  Show Profile
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<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2002 :  19:27:41  Show Profile  Send ruirib a Yahoo! Message
Don't know whats happening there...

have you changed inc_moderation.asp?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
<
Go to Top of Page

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  19:28:01  Show Profile
No


------------------------------
Magic is an Orange
http://www.magicorange.tk<
Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts

Posted - 25 June 2002 :  19:29:09  Show Profile  Visit crash's Homepage
could you post the database query that starts a few lines above line number 1108?



Crash's Site | Crash is from
<
Go to Top of Page

Tmpj
Junior Member

Denmark
467 Posts

Posted - 25 June 2002 :  19:32:00  Show Profile
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<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2002 :  19:34:31  Show Profile  Send ruirib a Yahoo! Message
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
<
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07