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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Need Some Help Here!!!!		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sniper3dr
Starting Member

USA
32 Posts
Posted - 15 May 2002 :  14:41:17  Show Profile  Visit Sniper3dr's Homepage  Send Sniper3dr an ICQ Message
Howdy,

First I have the folling mods installed:
- Active Users
- Private Messages
- Announcement
- Sticky Mod
- IP Ban(kinda of)

My forums worked great until I "tired" to install the IP ban mod, and now I get the following error in my members.asp page:

 
Microsoft JET Database Engine error '80040e14' 

Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_PMRECEIVE FORUM_MEMBERS.M_LASTPOSTDATE'. 

/snitz/members.asp, line 241


I have even replaced the members.asp page with "fresh" one and still the error.??

Second,

I have a hidden section within my forums with the "Allowed Member List (hidden) and everytime I try and add a member so that they can view the section it goes away on the box when I add them. I select everyone I want to view the section, hit the ---> arrow and then I go back to the "edit" part of the section and the right side where all the names should be is blank?

Anybody have any info to what is going on here?

Win2k
Apache 1.3.24
Snitz Forums 2000 Version 3.3.03

Thank you all for you're help!

-----
Alex "Sniper" Togstad
News and Review Editor
Files Retreat :: http://files.3dretreat.com
3d Retreat :: www.3dretreat.com

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 15 May 2002 :  14:53:40  Show Profile  Send ruirib a Yahoo! Message
Add a 

Response.Write strSql

before that line 241 and post the result here.

quote:

I have a hidden section within my forums with the "Allowed Member List (hidden) and everytime I try and add a member so that they can view the section it goes away on the box when I add them. I select everyone I want to view the section, hit the ---> arrow and then I go back to the "edit" part of the section and the right side where all the names should be is blank?

Read this: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26308. You'll need to download a new post.asp, so any mod related changes will need to be inserted again.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs

Edited by - ruirib on 15 May 2002 14:54:49
Go to Top of Page

Sniper3dr
Starting Member

USA
32 Posts
Posted - 15 May 2002 :  15:07:07  Show Profile  Visit Sniper3dr's Homepage  Send Sniper3dr an ICQ Message
Wow, I totally did not find that thread for the post!!

Thank you for the fast response!

Now I'm getting this error 

 
Microsoft JET Database Engine error '80040e14' 

Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_DATE FORUM_MEMBERS.M_PMRECEIVE'. 

/snitz/members.asp, line 235


-----
Alex "Sniper" Togstad
News and Review Editor
Files Retreat :: http://files.3dretreat.com
3d Retreat :: www.3dretreat.com
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 15 May 2002 :  15:11:36  Show Profile  Send ruirib a Yahoo! Message
Like I said before,

Add a Response.Write strSql before that line and post the result here.

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

Sniper3dr
Starting Member

USA
32 Posts
Posted - 15 May 2002 :  15:14:48  Show Profile  Visit Sniper3dr's Homepage  Send Sniper3dr an ICQ Message
sry. . .

 
SELECT FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_STATUS, FORUM_MEMBERS.M_NAME, FORUM_MEMBERS.M_LEVEL, FORUM_MEMBERS.M_EMAIL, FORUM_MEMBERS.M_COUNTRY, FORUM_MEMBERS.M_HOMEPAGE, FORUM_MEMBERS.M_ICQ, FORUM_MEMBERS.M_YAHOO, FORUM_MEMBERS.M_AIM, FORUM_MEMBERS.M_TITLE, FORUM_MEMBERS.M_POSTS, FORUM_MEMBERS.M_LASTPOSTDATE, FORUM_MEMBERS.M_LASTHEREDATE, FORUM_MEMBERS.M_DATE FORUM_MEMBERS.M_PMRECEIVE FROM FORUM_MEMBERS WHERE FORUM_MEMBERS.M_NAME <> 'n/a' ORDER BY FORUM_MEMBERS.M_POSTS DESC, FORUM_MEMBERS.M_NAME ASC 
Microsoft JET Database Engine error '80040e14' 

Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_DATE FORUM_MEMBERS.M_PMRECEIVE'. 

/snitz/members.asp, line 235


-----
Alex "Sniper" Togstad
News and Review Editor
Files Retreat :: http://files.3dretreat.com
3d Retreat :: www.3dretreat.com
Go to Top of Page

nomad_2k
Junior Member

United Kingdom
173 Posts
Posted - 15 May 2002 :  15:20:30  Show Profile
quote:

Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_PMRECEIVE FORUM_MEMBERS.M_LASTPOSTDATE'.


Your missing a comma between FORUM_MEMBERS.M_PMRECEIVE and FORUM_MEMBERS.M_LASTPOSTDATE


Good things come to those who wait.
http://www.freeasphost.co.uk/evolution/
Go to Top of Page

Sniper3dr
Starting Member

USA
32 Posts
Posted - 15 May 2002 :  15:26:48  Show Profile  Visit Sniper3dr's Homepage  Send Sniper3dr an ICQ Message
I'm not finding that line in the members.asp page at all. Could you please direct me to the right page that that line is at?

So the code would look like this then:

'FORUM_MEMBERS.M_PMRECEIVE, FORUM_MEMBERS.M_LASTPOSTDATE'


Thank you!

-----
Alex "Sniper" Togstad
News and Review Editor
Files Retreat :: http://files.3dretreat.com
3d Retreat :: www.3dretreat.com
Go to Top of Page

Sniper3dr
Starting Member

USA
32 Posts
Posted - 15 May 2002 :  15:59:06  Show Profile  Visit Sniper3dr's Homepage  Send Sniper3dr an ICQ Message
w00t!

I fixed it!

I had the Personal Msg mod instaleld, and I needed to put the comma's in the right places. I was not sure what nomad_2k was talking about, then I got the PM mod install readme out, and looked over it and saw where the code was and saw that I needed to add commas after a few lines and it all was clear!

Thank you for you're help!

The two places I changed if anyone cares. . .

 
.
.
.
strMemberTablePrefix & "MEMBERS.M_DATE, "  &_
strMemberTablePrefix & "MEMBERS.M_STATE, "  &_ 
`###Above where the comma is at the end of "STATE"
strMemberTablePrefix & "MEMBERS.M_PMRECEIVE " & _
`###Then I saw that after "PMRECEIVE" and "MEMBERS" below that a "," was not needed after it.
" FROM " & strMemberTablePrefix & "MEMBERS "


and the other part . . .
 
.
.
.
	strMemberTablePrefix & "MEMBERS.M_LASTPOSTDATE, " &_
	strMemberTablePrefix & "MEMBERS.M_LASTHEREDATE, " &_
	strMemberTablePrefix & "MEMBERS.M_DATE, " &_
	strMemberTablePrefix & "MEMBERS.M_PMRECEIVE " & _
	" FROM " & strMemberTablePrefix & "MEMBERS "


-----
Alex "Sniper" Togstad
News and Review Editor
Files Retreat :: http://files.3dretreat.com
3d Retreat :: www.3dretreat.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07