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
 Subforum Mod for MySQL		  New Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

volkerc
Junior Member

Germany
156 Posts
Posted - 29 October 2013 :  04:00:39  Show Profile  Reply with Quote
Hi everybody.
I tried installing the subforum mod. Gettin error(s)
Everything looks normal, but when clicking on editing forum categories i get an error pointing to the post.asp file.
I think this might be entirely MySQL related.
Is there a version of this mod, geared for MySQL ?

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 October 2013 :  04:05:32  Show Profile  Send ruirib a Yahoo! Message
There are a couple statements that need correction. If you post the errors here, I will help fixing them.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 01 November 2013 :  04:16:43  Show Profile
Hi ruirib,
thanks.
When hitting create new forum i get:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.96-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 F_PARENT FROM FORUM_FORUM WHERE FORUM_ID = 0' at line 1

/forum/post.asp, line 585
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 November 2013 :  05:32:05  Show Profile  Send ruirib a Yahoo! Message
Please post the full line here.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 01 November 2013 :  06:05:26  Show Profile
according to araneae line 585 says:

set rsFindSub = my_Conn.Execute(strSQL)
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 01 November 2013 :  06:06:26  Show Profile
Line 584-588

If strRqForumID = "" Then strRqForumID = 0
strSQL = "SELECT TOP 1 F_PARENT FROM FORUM_FORUM WHERE FORUM_ID = " & strRqForumID
set rsFindSub = my_Conn.Execute(strSQL)
if rsFindSub.eof then
strSubForum = NULL
else
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 November 2013 :  06:36:01  Show Profile  Send ruirib a Yahoo! Message
Replace this line:

strSQL = "SELECT TOP 1 F_PARENT FROM FORUM_FORUM WHERE FORUM_ID = " & strRqForumID

with

strSQL = "SELECT F_PARENT FROM FORUM_FORUM WHERE FORUM_ID = " & strRqForumID & " LIMIT 1"

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 01 November 2013 :  07:28:11  Show Profile
Ok. Error is gone. :-)
Wondering now how to add a subforum. Not seeing any new buttons or so....?
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts
Posted - 01 November 2013 :  09:30:51  Show Profile  Visit bobby131313's Homepage
You won't see new buttons. Just create a new forum normally in the category you want, then you will be asked to name a parent forum/category.
Switch the order of your title tags
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 01 November 2013 :  09:45:40  Show Profile
Hmm. Don't see that. When i ran the mod I get this message:

Adding Column F_PARENT...
ALTER TABLE FORUM_FORUM ADD F_PARENT int NULL
ALTER TABLE FORUM_FORUM ADD F_PARENT int NULL
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.96-log]Duplicate column name 'F_PARENT'
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 01 November 2013 :  09:48:05  Show Profile
Never mind. I figured it out. My bad.
Thanks for the help ruirib!!!!! And Bobby131313 !
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 01 November 2013 :  11:40:04  Show Profile
getting a new error. after moving all the topics into the subforums. all topics and subforums dissappeared, giving me this message:
Microsoft VBScript runtime error '800a000d'

Type mismatch: 'rs'

/forum/inc_func_chknew.asp, line 37
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 01 November 2013 :  22:14:06  Show Profile
You can fix that error by replacing the entire first function of "inc_func_cknew.asp" with the following:


Function ChkIsNew(dt)
	If not rs.EOF Then
		if Topic_Author = "" then Topic_Author = rs("T_AUTHOR")
		if (Topic_Author = MemberID OR AdminAllowed = 1) AND UnModeratedFPosts > 0 then
			if Topic_Author = MemberID then
				if (CheckForUnModeratedPosts("POSTAUTHOR", Cat_ID, Forum_ID, Topic_ID) > 0) then
				' Do held code
					ChkIsNew = ChkIsNew1()
				else
				' Do normal code
					ChkIsNew = ChkIsNew2(dt)
				end if
			else
				if ((CheckForUnModeratedPosts("TOPIC", Cat_ID, Forum_ID, Topic_ID) > 0) and AdminAllowed = 1) then
				' Do held code
					ChkIsNew = ChkIsNew1()
				else
				' Do normal code
					ChkIsNew = ChkIsNew2(dt)
				end if
			end if
		else
			' Do normal code
			ChkIsNew = ChkIsNew2(dt)
		end if
	end if
End function
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 06 November 2013 :  17:25:59  Show Profile
hi carefree

that gave me another error, saying runtime error 800a01a8, object required 'rs'
/forum/inc_func_chknew.asp, line 37

sorry for the late reply, had to do some other things....
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 07 November 2013 :  10:11:23  Show Profile
You need to create at least one topic in a root forum. The simplest method would be to move one forum back to the root (no parent):

[scrollcode][code]
<!-- #INCLUDE FILE="config.asp" -->
<!-- #INCLUDE FILE="inc_header.asp" -->
<%
my_Conn.Execute("UPDATE " & strTablePrefix & "FORUM SET F_PARENT='' WHERE FORUM_ID=1")
Response.Write "Moved!<br />"
WriteFooter
%>
Edited by - Carefree on 07 November 2013 10:14:00
Go to Top of Page

volkerc
Junior Member

Germany
156 Posts
Posted - 07 November 2013 :  12:41:38  Show Profile
Yes i noticed that once i have one topic in the subforum area, the subforums all show up. I just thought that there would be no topic necessary next to the subforums....

What's the code above for?
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.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07