| Author |
 Topic  |
|
|
vpwsys
Starting Member
United Kingdom
10 Posts |
 Posted - 11 August 2002 : 16:32:48
|
Hi,
I've literally just installed the current version of Snitz today, on an SQL Server 7.0 installation.
I modified the table prefixes so that the member list used a prefix of "Global_" (so that I can shortly make other sites but share the member list.
I now get:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The column prefix 'Global_FORUM' does not match with a table name or alias name used in the query.
/forum/default.asp, line 211
from the homepage - am I bad? or is there something I should have done first? If not, what needs doing to fix this one?
Cheers
Vince
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 11 August 2002 : 16:48:02
|
a query you are trying to execute still has FORUM_ instead of your newly edited GLOBAL_.
I bet the line 211 is the sql execute statement so please post the query which should be a few lines above. |
 |
 |
|
|
vpwsys
Starting Member
United Kingdom
10 Posts |
Posted - 11 August 2002 : 16:52:07
|
Hello,
Here tis:
'## Forum_SQL - Build SQL to get forums via category
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " &_
strTablePrefix & "FORUM.F_STATUS, " &_
strTablePrefix & "FORUM.CAT_ID, " &_
strTablePrefix & "FORUM.F_SUBJECT, " &_
strTablePrefix & "FORUM.F_URL, " &_
strTablePrefix & "FORUM.F_DESCRIPTION, " &_
strTablePrefix & "FORUM.F_TOPICS, " &_
strTablePrefix & "FORUM.F_COUNT, " &_
strTablePrefix & "FORUM.F_LAST_POST, " &_
strTablePrefix & "FORUM.F_TYPE, " &_
strTablePrefix & "FORUM.F_ORDER, " &_
strTablePrefix & "FORUM.F_PRIVATEFORUMS, " &_
strTablePrefix & "FORUM.F_A_COUNT, " &_
strMemberTablePrefix & "FORUM.F_SUBSCRIPTION, " &_
strMemberTablePrefix & "MEMBERS.MEMBER_ID, " &_
strMemberTablePrefix & "MEMBERS.M_NAME " &_
"FROM " & strTablePrefix & "FORUM " &_
"LEFT JOIN " & strMemberTablePrefix & "MEMBERS ON " &_
strTablePrefix & "FORUM.F_LAST_POST_AUTHOR = " &_
strMemberTablePrefix & "MEMBERS.MEMBER_ID " &_
" WHERE " & strTablePrefix & "FORUM.CAT_ID = " & rs("CAT_ID") & " " &_
" ORDER BY " & strTablePrefix & "FORUM.F_ORDER ASC" &_
", " & strTablePrefix & "FORUM.F_SUBJECT ASC;"
|
Edited by - vpwsys on 11 August 2002 16:58:33 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 11 August 2002 : 16:58:18
|
| you need to change the TABLE NAMES as well. |
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 11 August 2002 : 16:59:43
|
| wait, you want this only on ONE table? and you modified Table Prefix? I think your edits are looking for GLOBAL on all queries and tables then. |
|
|
|
|
vpwsys
Starting Member
United Kingdom
10 Posts |
Posted - 11 August 2002 : 17:01:37
|
Hi,
Yeah, I've modified config.asp as follows:
strTablePrefix = "SiteA_"
strMemberTablePrefix = "Global_"
my SQL Database has got a Global_MEMBERS and then the rest are all SiteA_ prefix...
so now i'm confused :-)
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 11 August 2002 : 17:23:30
|
add this line right before line 211
response.write strSql
and then copy what it shows on your screen.
you did modify the members table name too right? |
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 August 2002 : 17:32:01
|
There are several bugs related to use of different table prefixes. I'll have a look for the links to the fixes, cause you'll experience other similar problems.
I'll post them in a sec... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
vpwsys
Starting Member
United Kingdom
10 Posts |
Posted - 11 August 2002 : 17:52:32
|
Both - thanks - changed both default.asp and incFunctions.asp and all works now.
Cheers!
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
.