Author |
Topic  |
|
churnetview
Starting Member
2 Posts |
Posted - 30 June 2006 : 07:42:04
|
Hello there, I setup a forum in our Intranet website, it was working fine. Then I try to setup another forum in the same site sharing the same database, so each forum could have its own topics, but the topics in forum one won't be shown in forum two. At the first time, I setup two forums using the same "congif.asp" file,(two "config.asp"files, one in each forum folder, but everything in it are the same) so both two forums works fine, but they are showing the same topics in the database. I think this is the problem in the:
strTablePrefix = "CVMS_FORUM_" strMemberTablePrefix = "CVMS_FORUM_" strFilterTablePrefix = "CVMS_FORUM_" 'used for BADWORDS and NAMEFILTER tables
setting, so I change the second "config.asp" file to:
strTablePrefix = "MATH_FORUM_" strMemberTablePrefix = "CVMS_FORUM_" strFilterTablePrefix = "CVMS_FORUM_" 'used for BADWORDS and NAMEFILTER tables
and hope that will do, but then the database corrupted.
I am using Microsoft Access as our database, and the connection was working fine when I setup the first forum. Here are more details about how I setup our forums:
The first fourm's files are in: "D:\Inetpub\WWWroot\Intranet\churnetviewforum\" and the database file "CVMS.mdb" is in folder "D:\Inetpub\WWWroot\Intranet\". In the "D:\Inetpub\WWWroot\Intranet\churnetviewforum\config.asp", the setting of "Table Prefixes" is "strTablePrefix = "CVMS_FORUM_"". It was working fine before I setup the second forum.
The second forum's files are in: "D:\Inetpub\WWWroot\Intranet\mathforum\" and the database file "CVMS.mdb"(using the same database file) is in folder "D:\Inetpub\WWWroot\Intranet\". In the "D:\Inetpub\WWWroot\Intranet\mathforum\config.asp", The setting of "Table Prefixes" is "strTablePrefix = "MATH_FORUM_"". After I submit the setup, the database corrupted.
So is it possible to have two or more forums in one site, they share member information but not the topics information? So the topics in "churnetviewforum" won't be shown in "mathforum"? How can I do it?
Please help, thanks a lot.
Eric
|
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 30 June 2006 : 08:00:26
|
First, compact and repair your database, using Access (you will need to download it first and upload it once done).
Then, before setting up the 2nd forum, set the strMemberTablePrefix to "MATH_FORUM_". Run setup.asp for the 2nd forum and then set the strMemberTablePrefix back to "CVMS_FORUM_".
If you plan to have forums with some traffic, probably Access won't be a good choice. Also, you should be aware that there will be only one last visit date per user, which will be valid for both forums.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
churnetview
Starting Member
2 Posts |
Posted - 30 June 2006 : 09:18:10
|
Thanks for the help, but it is not working. I change the "config.asp" file in "D:\Inetpub\WWWroot\Intranet\mathforum\config.asp" as : strTablePrefix = "MATH_FORUM_" strMemberTablePrefix = "MATH_FORUM_" then I run the intranet/mathforum/setup.asp, it says "Installation of forum-tables in the database" and ask for username and password, so I put in the same username and password in the first forum, then it says ddatabase installed. Then i change the strMemberTablePrefix back to "CVMS_FORUM_" and run the intranet/mathforum/default.asp but it gives me the following error:
The Microsoft Jet database engine cannot find the input table or query 'MATH_FORUM_MODERATOR'. Make sure it exists and that its name is spelled correctly
In the database file, I can see a new table called MATH_FORUM_CONFIG_NEW created, but it is still not working properly.
I assume that I don't need to do any change to the "config.asp" in the "D:\Inetpub\WWWroot\Intranet\churnetviewforum\" folder. Is that right? |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 30 June 2006 : 12:53:08
|
Yes, the existing forum does not need to be changed.
Seems like some of the tables are not being created. You could try changing all the prefixes and run setup.asp again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Topic  |
|
|
|