bjlt
Senior Member
   
1144 Posts |
Posted - 07 December 2001 : 14:35:39
|
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 |
|