Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Setup more than one forum in one site
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

churnetview
Starting Member

2 Posts

Posted - 30 June 2006 :  07:42:04  Show Profile
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  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page

churnetview
Starting Member

2 Posts

Posted - 30 June 2006 :  09:18:10  Show Profile
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?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 June 2006 :  12:53:08  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.48 seconds. Powered By: Snitz Forums 2000 Version 3.4.07