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)
 (already fixed)strMemberTablePrefix strTablePrefix
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bjlt
Senior Member

1144 Posts

Posted - 07 December 2001 :  14:35:39  Show Profile
I just installed a copy, met two problems as I changed strMembertablePrefix. just search in inc_functions

strTablePrefix & "MEMBERS

about line 1095

function chkForumModerator(fForum_ID, fMember_Name)
'## Forum_SQL
strSql = "SELECT mo.FORUM_ID "
'##yx: bug: changed to below: strSql = strSql & " FROM " & strTablePrefix & "MODERATOR mo, " & strTablePrefix & "MEMBERS me "


btw, here's a good search/replace tool if you don't have a handy one.
InfoRapid Search & Replace

(Version 3.1a, released 09/09/01, 1026 KB)

http://www.inforapid.org/sr/sr.exe

same problem could be found in some mods.



Got another one.



Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'MEMBER_FORUM' does not match with a table name or alias name used in the query.

/snitz33033/default.asp, line 211


it's in line199 of default.asp


strMemberTablePrefix & "FORUM.F_SUBSCRIPTION, " &_


Edited by - bjlt on 07 December 2001 14:40:29

Edited by - bjlt on 07 December 2001 16:42:12

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 07 December 2001 :  17:04:39  Show Profile
first one was fixed here: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=17761

second one was fixed here: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=17046
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.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07