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 Bug Reports (Closed)
 V33: BUG+FIX Can't post in new forum		  Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

thephantomnl
New Member

Netherlands
66 Posts
Posted - 25 July 2001 :  17:24:12  Show Profile  Visit thephantomnl's Homepage  Send thephantomnl an ICQ Message
what does this mean?
--------
Please don't attempt to edit the URL
to gain access to locked Forums/Categories.
--------
i deleted the Testing Forum and Snitz Forums 2000 cat and make my own. now i can't post anywhere and get this error. can't fint what i'am doing wrong??

if i place the original database back the i can post in test forums and forums of my own till i delete the first forum

Morten
Junior Member

Denmark
251 Posts
Posted - 25 July 2001 :  17:37:12  Show Profile
The same problem here. I have tryed out all the subcribe settings and everything else that I had an idea that it might solve the problem, but nothing seems to help
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 26 July 2001 :  03:39:43  Show Profile  Visit gor's Homepage
This problem is caused by an error in the checks in post.asp and post_info.asp
The error doesn't show if there allready are topics in a forum so if you upgrade you probably didn't notice it.
Still it is better to fix it then also.

In post.asp
Starting line: 99
Replace this code:
	'## Forum_SQL - Find out if the Category/Forum/Topic is Locked or Un-Locked and if it Exists
	strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_STATUS, " & strTablePrefix & "FORUM.F_STATUS, " 
	strSql = strSql & strActivePrefix & "TOPICS.T_STATUS "
	strSql = strSql & " FROM " & strTablePrefix & "CATEGORY, " & strTablePrefix & "FORUM, " & strActivePrefix & "TOPICS "
	strSql = strSql & " WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & strRqCatID
'	strSql = strSql & " AND " & strTablePrefix & "FORUM.FORUM_ID = " & strRqForumID
'	strSql = strSql & " AND " & strTablePrefix & "FORUM.CAT_ID = " & strRqCatID
	strSql = strSql & " AND " & strTablePrefix & "FORUM.FORUM_ID = " & strActivePrefix & "TOPICS.FORUM_ID "
	strSql = strSql & " AND " & strTablePrefix & "FORUM.CAT_ID = " & strActivePrefix & "TOPICS.CAT_ID "
	if strRqMethod <> "Topic" then
		strSql = strSql & " AND " & strActivePrefix & "TOPICS.TOPIC_ID = " & strRqTopicID
'		strSql = strSql & " AND " & strActivePrefix & "TOPICS.FORUM_ID = " & strRqForumID
'		strSql = strSql & " AND " & strActivePrefix & "TOPICS.CAT_ID = " & strRqCatID
        end if
 
	set rsStatus = my_Conn.Execute(strSql)
	if rsStatus.EOF or rsStatus.BOF then
		Go_Result "Please don't attempt to edit the URL<br>to gain access to locked Forums/Categories."
	else
		blnCStatus = rsStatus("CAT_STATUS")
		blnFStatus = rsStatus("F_STATUS")
		blnTStatus = rsStatus("T_STATUS")
		rsStatus.close
		set rsStatus = nothing
	end if

With:

	if strRqMethod <> "Topic" then
		'## Forum_SQL - Find out if the Category, Forum or Topic is Locked or Un-Locked and if it Exists
		strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_STATUS, " &_
		strTablePrefix & "FORUM.F_STATUS, " &_
		strActivePrefix & "TOPICS.T_STATUS " &_
		" FROM " & strTablePrefix & "CATEGORY, " &_
		strTablePrefix & "FORUM, " &_
		strActivePrefix & "TOPICS " &_
		" WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & strActivePrefix & "TOPICS.CAT_ID " &_
		" AND " & strTablePrefix & "FORUM.FORUM_ID = " & strActivePrefix & "TOPICS.FORUM_ID " &_
		" AND " & strActivePrefix & "TOPICS.TOPIC_ID = " & strRqTopicID & ""
	else
		'## Forum_SQL - Find out if the Category or Forum is Locked or Un-Locked and if it Exists
		strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_STATUS, " &_
		strTablePrefix & "FORUM.F_STATUS " &_
		" FROM " & strTablePrefix & "CATEGORY, " &_
		strTablePrefix & "FORUM " &_
		" WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & strTablePrefix & "FORUM.CAT_ID " &_
		" AND " & strTablePrefix & "FORUM.FORUM_ID = " & strRqForumID & ""
        end if
 
	set rsStatus = my_Conn.Execute(strSql)
	if rsStatus.EOF or rsStatus.BOF then
		Go_Result "Please don't attempt to edit the URL<br>to gain access to locked Forums/Categories."
	else
		blnCStatus = rsStatus("CAT_STATUS")
		blnFStatus = rsStatus("F_STATUS")
		if strRqMethod <> "Topic" then
			blnTStatus = rsStatus("T_STATUS")
		else
			blnTStatus = 1
		end if
		rsStatus.close
		set rsStatus = nothing
	end if


in post_info.asp
Starting line: 112
Replace:

	'## Forum_SQL - Find out if the Category/Forum/Topic is Locked or Un-Locked and if it Exists
	strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_STATUS, " & strTablePrefix & "FORUM.F_STATUS, " 
	strSql = strSql & strActivePrefix & "TOPICS.T_STATUS, "& strActivePrefix & "TOPICS.T_AUTHOR "
	strSql = strSql & " FROM " & strTablePrefix & "CATEGORY, " & strTablePrefix & "FORUM, " & strActivePrefix & "TOPICS "
	strSql = strSql & " WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & Cat_ID
	strSql = strSql & " AND " & strTablePrefix & "FORUM.FORUM_ID = " & Forum_ID
	strSql = strSql & " AND " & strTablePrefix & "FORUM.CAT_ID = " & Cat_ID
	if MethodType <> "Topic" then
		strSql = strSql & " AND " & strActivePrefix & "TOPICS.TOPIC_ID = " & Topic_ID
		strSql = strSql & " AND " & strActivePrefix & "TOPICS.FORUM_ID = " & Forum_ID
		strSql = strSql & " AND " & strActivePrefix & "TOPICS.CAT_ID = " & Cat_ID
        end if
 
	set rsStatus = my_Conn.Execute(strSql)
	if rsStatus.EOF or rsStatus.BOF then
		Go_Result "Please don't attempt to edit the URL<br>to gain access to locked Forums/Categories.", 0
	else
		blnCStatus = rsStatus("CAT_STATUS")
		blnFStatus = rsStatus("F_STATUS")
		blnTStatus = rsStatus("T_STATUS")
		strTopicAuthor = rsStatus("T_AUTHOR")
		rsStatus.close
		set rsStatus = nothing
	end if

With:

	if MethodType <> "Topic" then
		'## Forum_SQL - Find out if the Category, Forum or Topic is Locked or Un-Locked and if it Exists
		strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_STATUS, " &_
		strTablePrefix & "FORUM.F_STATUS, " &_
		strActivePrefix & "TOPICS.T_STATUS, " &_
		strActivePrefix & "TOPICS.T_AUTHOR " &_
		" FROM " & strTablePrefix & "CATEGORY, " &_
		strTablePrefix & "FORUM, " &_
		strActivePrefix & "TOPICS " &_
		" WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & strActivePrefix & "TOPICS.CAT_ID " &_
		" AND " & strTablePrefix & "FORUM.FORUM_ID = " & strActivePrefix & "TOPICS.FORUM_ID " &_
		" AND " & strActivePrefix & "TOPICS.TOPIC_ID = " & Topic_ID & ""
	else
		'## Forum_SQL - Find out if the Category or Forum is Locked or Un-Locked and if it Exists
		strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_STATUS, " &_
		strTablePrefix & "FORUM.F_STATUS " &_
		" FROM " & strTablePrefix & "CATEGORY, " &_
		strTablePrefix & "FORUM " &_
		" WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & strTablePrefix & "FORUM.CAT_ID " &_
		" AND " & strTablePrefix & "FORUM.FORUM_ID = " & Forum_ID & ""
        end if
 
	set rsStatus = my_Conn.Execute(strSql)
	if rsStatus.EOF or rsStatus.BOF then
		Go_Result "Please don't attempt to edit the URL<br>to gain access to locked Forums/Categories."
	else
		blnCStatus = rsStatus("CAT_STATUS")
		blnFStatus = rsStatus("F_STATUS")
		if MethodType <> "Topic" then
			blnTStatus = rsStatus("T_STATUS")
			strTopicAuthor = rsStatus("T_AUTHOR")
		else
			blnTStatus = 1
		end if
		rsStatus.close
		set rsStatus = nothing
	end if


Note: After you've fixed this, you'll get another error...I'll post the link to the fix for that here asap.

Pierre
Join a Snitz Mailinglist
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 26 July 2001 :  03:51:34  Show Profile  Visit gor's Homepage
Fix for the C_STRMOVENOTIFY error: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=13678

Pierre
Join a Snitz Mailinglist
Go to Top of Page

watkins
Starting Member

15 Posts
Posted - 26 July 2001 :  06:24:11  Show Profile
I tried this and i cant get it to work, could you email me a copy of your post and post_info file or make an upgrade for me please. I cannot figure this out. Thanks
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 26 July 2001 :  07:00:37  Show Profile  Visit gor's Homepage
quote:

I tried this and i cant get it to work, could you email me a copy of your post and post_info file or make an upgrade for me please. I cannot figure this out. Thanks


I'll probably make a zip-file with all the critical fixes available tonight.

Pierre
Join a Snitz Mailinglist
Go to Top of Page

watkins
Starting Member

15 Posts
Posted - 26 July 2001 :  18:45:08  Show Profile
thank you let me know when you post the zip file please.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000 Version 3.4.07