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: MOD Implementation
 Simple slash mod problem.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Dstructr
Starting Member

12 Posts

Posted - 21 May 2006 :  05:08:01  Show Profile
I'm having a strange problem with the simple slash mod.

After awhile not sure when yet, i'm getting an error when running
inc_simple_slash.asp in my browser, 500 Internal server error.

Error when viewing the page in IE:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/inc_func_common.asp, line 212

If i look at the code:
function chkBadWords(fString)
---snip
rsBadWord.open strSqlb, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

The rsBadWord.open fails.

To solve this i need to visit the actual forum
http://<mydomain>/forum, after that the
viewing of http://<mydomain>/forum/inc_simple_slash.asp
works again.

So what can cause this ? I can't really require that they
visit the forum before reading the news on the frontpage ;).

When visiting http://<mydomain> i execute this:
http://<mydomain>/forum/inc_simple_slash.asp and display it
on the front page.

Also the includes in inc_simple_slash are:
<!--#include file="config.asp"-->
<!--#include file="inc_func_common.asp" -->

Anyone has any idea how to fix this ?














AnonJr
Moderator

United States
5768 Posts

Posted - 21 May 2006 :  08:25:39  Show Profile  Visit AnonJr's Homepage
Sounds like some problems with the server.

Just to make sure I understand right, you are pulling inc_simple_slash.asp up in the browser? Last I checked, it was intended to be included in another page...
Go to Top of Page

Dstructr
Starting Member

12 Posts

Posted - 21 May 2006 :  20:14:10  Show Profile
It's not a server problem.
If i visit the forum, everything is back to normal.

I know it's supposed to be included in another page, but by displaying the page in IE
you get a more detailed error description compared to 500 - internal server error.
And IE can display raw page tables without html/head/body tags too.

I tried clearing all offline content in IE and all cookies,
still the page works, but if i wait not sure how long, maybe 30 minutes
the page fails...
Visit the forum and everything is back to normal.

Dst



Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 21 May 2006 :  21:21:38  Show Profile  Visit AnonJr's Homepage
What initially led me to my prior statement was that given the information at hand it sounded like a problem with the server variables. Running the forum in the proper context re-set those. This has nothing to do with cookies or local content.
Go to Top of Page

Dstructr
Starting Member

12 Posts

Posted - 22 May 2006 :  09:13:55  Show Profile
It seems to be caused my my_conn = nothing.
The mod doesn't include inc_header.asp. or inc_header_short.asp.

So i just turned off the bad word stuff and it works.

Dst
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 22 May 2006 :  15:02:41  Show Profile  Visit AnonJr's Homepage
Did you modify it in any way? I can't seem to reproduce the problem...

Where is my_conn being set to nothing?
Go to Top of Page

Dstructr
Starting Member

12 Posts

Posted - 22 May 2006 :  17:49:13  Show Profile
my_conn is created in inc_header.asp or inc_header_short.asp.
The slash mod doesnt include any of these headers. Neither do i on my frontpage.
So when a user visits my homepage the inc_header are not included.
Only inc_simple_slash is executed.

It seems like the server remembers my_conn after a foum visit somehow.
After awhile the server cleans out my_conn and my frontpage fails.

Anyway disabling bad words, fixes it so that my_conn is not used.

Dst






Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 22 February 2007 :  12:06:01  Show Profile  Visit MarkJH's Homepage
I've had exactly the same problem of late.

Not sure exactly if this is right but what I've done is strip down my inc_header_short to this:

<%
'#################################################################################
'## Copyright (C) 2000-02 Michael Anderson, Pierre Gorissen,
'##                       Huw Reddick and Richard Kinser
'##
'## This program is free software; you can redistribute it and/or
'## modify it under the terms of the GNU General Public License
'## as published by the Free Software Foundation; either version 2
'## of the License, or any later version.
'##
'## All copyright notices regarding Snitz Forums 2000
'## must remain intact in the scripts and in the outputted HTML
'## The "powered by" text/logo with a link back to
'## http://forum.snitz.com in the footer of the pages MUST
'## remain visible when the pages are viewed on the internet or intranet.
'##
'## This program is distributed in the hope that it will be useful,
'## but WITHOUT ANY WARRANTY; without even the implied warranty of
'## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
'## GNU General Public License for more details.
'##
'## You should have received a copy of the GNU General Public License
'## along with this program; if not, write to the Free Software
'## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
'##
'## Support can be obtained from support forums at:
'## http://forum.snitz.com
'##
'## Correspondence and Marketing Questions can be sent to:
'## reinhold@bigfoot.com
'##
'## or
'##
'## Snitz Communications
'## C/O: Michael Anderson
'## PO Box 200
'## Harpswell, ME 04079
'#################################################################################
strArchiveTablePrefix = strTablePrefix & "A_"
scriptname = split(request.servervariables("SCRIPT_NAME"),"/")

set my_Conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString

strDBNTUserName = Request.Cookies(strUniqueID & "User")("Name")
strDBNTFUserName = trim(chkString(Request.Form("Name"),"SQLString"))
if strDBNTFUserName = "" then strDBNTFUserName = trim(chkString(Request.Form("User"),"SQLString"))
if strAuthType = "nt" then
	strDBNTUserName = Session(strCookieURL & "userID")
	strDBNTFUserName = Session(strCookieURL & "userID")
end if

chkCookie = 1
mLev = cLng(chkUser(strDBNTUserName, Request.Cookies(strUniqueID & "User")("Pword"),-1))
chkCookie = 0
%>


Then rename it inc_header_slash.asp and include it at the top of my slash file, below the include for inc_func_common. It's working right now... does this look okay?

Bandlink.net - http://www.bandlink.net/
Bandlink Music Forums - http://www.bandlink.net/forum/
Go to Top of Page

rkp
New Member

59 Posts

Posted - 12 June 2007 :  12:23:14  Show Profile
Any resolve??
Go to Top of Page

rkp
New Member

59 Posts

Posted - 12 June 2007 :  12:29:54  Show Profile
I have the same issue that the first gentleman had. What is the best work around for this?
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.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07