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 SQL Server
 Multiple forums on one SQL database
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tblacker
Starting Member

1 Posts

Posted - 25 June 2007 :  19:20:03  Show Profile

I'm trying to host multiple forums in a single MS SQL database.

I followed the directions in section 5 of the readme which describes changing the forum prefix on my first forums setup, in anticipation of adding more later. So it reads like:

strTablePrefix = "FORUM_name1"
strMemberTablePrefix = "FORUM_name1"
strFilterTablePrefix = "FORUM_name1" 'used for BADWORDS and NAMEFILTER tables

Then when I went to setup my next set of forums, I changed FORUM_name1 to FORUM_name2.

The configuration seemed to go well. I created a new database, and saw a new list of tables listed in SQL with the correct (new) names.

However, when I went to check on my old forums, I noticed that the title of the forums and the forum image had come up as the name and image from my NEW forums! Fortunately nothing else seems to have change; users, posts, categories etc... were all preserved. Only the title, image, etc.. were picked up from the new forums.

I'm not sure where I went wrong in the configuration. I even went back and re-did my config.asp on the new forums and reversed the name to be name2_FORUM but still no joy.

Any advice would be much appreciated!

Thanks!
Tom

AnonJr
Moderator

United States
5768 Posts

Posted - 25 June 2007 :  19:26:53  Show Profile  Visit AnonJr's Homepage
This has come up a few times before and is related to your application variables, strCookieURL (config.asp), and strUniqueID (config.asp). A little time with the search should turn up the appropriate topics.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 June 2007 :  19:28:15  Show Profile  Send ruirib a Yahoo! Message
Read this reply: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=62567#345911
The previous posts on the same thread have useful info as well.


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.11 seconds. Powered By: Snitz Forums 2000 Version 3.4.07