Snitz Forums 2000 - v3.3(.03) BUG+FIX: Incorrect table syntax

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 DEV-Group

DEV Bug Reports (Closed)

v3.3(.03) BUG+FIX: Incorrect table syntax

Forum Locked

Topic Locked

Printer Friendly

Author

Topic

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 15 November 2001 : 05:56:33

In inc_functions.asp in the "chkForumModerator()" function, line 1097, one of the selected tables in this SQL statement has the wrong table prefix.

'## Forum_SQL 
	strSql = "SELECT mo.FORUM_ID "	
	strSql = strSql & " FROM " & strTablePrefix & "MODERATOR mo, " & strTablePrefix & "MEMBERS me "	
	strSql = strSql & " WHERE mo.FORUM_ID = " & fForum_ID & " "	
	strSql = strSql & " AND   mo.MEMBER_ID = me.MEMBER_ID "

It should be strMemberTablePrefix.

- David

Edited by - Davio on 15 November 2001 06:30:48

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 15 November 2001 : 06:02:12

I think its strMemberTablePrefix... not strTableMemberPrefix

----
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, Huw's code, and Davio's code
Need a Mod? Check out the Mod Resource

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 15 November 2001 : 06:31:48

Fixed it in my post.

- David

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 15 November 2001 : 06:40:53

Fixed for 3.4

----
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, Huw's code, and Davio's code
Need a Mod? Check out the Mod Resource

Deleted
deleted

4116 Posts

Posted - 01 December 2001 : 13:24:34

Fixed in [v40b03patch001]...

Think Pink
Test Site not ready yet | Post v40b03 Patches

Topic

Forum Locked

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.43 seconds.