Snitz Forums 2000 - BUG+FIX (3.1sr5a7): Password can't be zero length

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 DEV-Group

DEV Bug Reports (Closed)

BUG+FIX (3.1sr5a7): Password can't be zero length

Forum Locked

Topic Locked

Printer Friendly

Author

Topic

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 19 February 2001 : 23:19:59

when creating a new forum... gives password can't be zero length if you don't fill something in

Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a

Reopened and moved from DEV Bug Reports (Closed) by Richard

Edited by - Richard Kinser on 04 March 2001 04:32:13

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 February 2001 : 00:16:59

I manually edited the database and changed the Allow Zero Length property from No to Yes for the field F_PASSWORD_NEW

gor
Retired Admin

Netherlands
5511 Posts

Posted - 20 February 2001 : 00:54:30

Remember though, that when the forum is set to "Allowed Members Only & Password", this means "be on the memberslist or know the password". In that case the password shouldn't allowed to be zero length. So we would need a check for that in the code still.

Pierre

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 February 2001 : 01:24:12

Ok, how about this:


		'## Forum_SQL - Do DB Update
		strSql = "INSERT INTO " & strTablePrefix & "FORUM "
		strSql = strSql & "(CAT_ID"
		if strPrivateForums = "1" then
			strSql = strSql & ", F_PRIVATEFORUMS"
			if Request.Form("AuthPassword") <> " " then
				strSql = strSql & ", F_PASSWORD_NEW"
			end if
		end if
		strSql = strSql & ", F_LAST_POST"
		strSql = strSql & ", F_SUBJECT"
		strSql = strSql & ", F_DESCRIPTION"
		strSql = strSql & ", F_TYPE" 
		strSql = strSql & ") VALUES ("
		strSql = strSql & Request.Form("CAT_ID")
		if strPrivateForums = "1" then
			strSql = strSql & ", " & Request.Form("AuthType") & ""
			if Request.Form("AuthPassword") <> " " then
				strSql = strSql & ", '" & ChkString(Request.Form("AuthPassword"),"password") & "'"
			end if
		end if
		strSql = strSql & ", " & "'" & DateToStr(strForumTimeAdjust) & "'"
		strSql = strSql & ", '" & txtSubject & "'"
		strSql = strSql & ", '" & txtMessage & "'"
		strSql = strSql & ", " & Request.Form("Type")
		strSql = strSql & ")"

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 20 February 2001 : 21:54:58

fixed in the source of sf2k_31sr5a8.zip

Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 04 March 2001 : 04:28:54

We need one more check for when the Forum is edited.

This is for v3.2a04 (but it has existed since 3.1sr5a7 also)

Starting at line #905:

Change this:


		if strPrivateForums = "1" then
			strSql = strSql & ",    F_PRIVATEFORUMS = " & Request.Form("AuthType") & ""
			strSql = strSql & ",    F_PASSWORD_NEW = '" & ChkString(Request.Form("AuthPassword"),"password") & "'"
		end if

to this:


		if strPrivateForums = "1" then
			strSql = strSql & ",    F_PRIVATEFORUMS = " & Request.Form("AuthType") & ""
			if Request.Form("AuthPassword") <> " " then
				strSql = strSql & ",    F_PASSWORD_NEW = '" & ChkString(Request.Form("AuthPassword"),"password") & "'"
			end if
		end if

Edited by - Richard Kinser on 04 March 2001 04:33:25

Reinsnitz
Snitz Forums Admin

USA
3545 Posts

Posted - 06 March 2001 : 20:57:38

fixed in the source of sf2k_32a5.zip

Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a

Topic

Forum Locked

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.16 seconds.