| Author |
 Topic  |
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
 Posted - 23 August 2002 : 19:48:15
|
The topic http://forum.snitz.com/forum/topic.asp?TOPIC_ID=28880 has given me a start, but I am still getting some great errors..
I have a single MS SQL 7 databse and have a number of forums. So they all share the same connection string, and I think I only have to alter the two strings
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
so they are unique from each other.
So, the first thing is to check, is this the case? so I can get the easy bit out of the way.. |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 23 August 2002 : 19:58:26
|
That'll do the trick of seperating the tables per forum.
I'm using 4 forums for testing on my computer and also always change the line strUniqueID = "Snitz00" in each config.asp so I can be logged in in each forum at the same time. That comes in handy when you need to administer all those forums  |
 |
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 23 August 2002 : 20:30:46
|
cheers for coming back so quickly, what you confirmed is that it should work  , so I have somthing a bit more painfull going on.
so, more background.
I installed forum 1 and didn't alter the two strings and the subsiquent forums went somthing like this
forum 1 - strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_"
forum 2 - strTablePrefix = "101GAMES_" strMemberTablePrefix = "FAN_"
forum 3 - strTablePrefix = "BRANDED_" strMemberTablePrefix = "BRAND_"
forum 4 - strTablePrefix = "BUFFY_" strMemberTablePrefix = "FAN_"
forum 5 - strTablePrefix = "CONTRACT_" strMemberTablePrefix = "CONTRACT_"
forum 6 - strTablePrefix = "DOMAIN_" strMemberTablePrefix = "BRAND_"
forum 7 - strTablePrefix = "MUSIC_" strMemberTablePrefix = "FAN_"
forum 8 - strTablePrefix = "EARITH_" strMemberTablePrefix = "EARITH_"
forum 9 - strTablePrefix = "HOST_" strMemberTablePrefix = "HOST_"
forum 10- strTablePrefix = "PALM_" strMemberTablePrefix = "PALM_"
forum 11- strTablePrefix = "POPULAR_" strMemberTablePrefix = "FAN_"
forum 12- strTablePrefix = "WINDOW_" strMemberTablePrefix = "WINDOW_"
forum 1 was installed days ago, and before, i decided to see how many forums I could come up with
next, I ran the setup.asp for forum 9 ( I know, very liniar ) that went fine.
then, forum 4, again went fine,
next was forum 2, and got my first odd things going on,
there was somthing about upgrading the database, so I clossed and ran it all again, followed all the screens, and got an error along the lines of
an object called (something) FAN_ already exsists.
I can cope with the logic here, i.e. I already have a forum (forum 4) with a
strMemberTablePrefix = "FAN_"
but the way I read the install, was that if I wanted to share members, then, I would need unique strTablePrefix = but keep the same strMemberTablePrefix =
I assume if i run all the compleate unique ones they will work, (5,8,9,10,12) so not an issue, but have i missed the way to share members accross multiple forums? |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
|
aberbotimue
Starting Member
United Kingdom
41 Posts |
Posted - 23 August 2002 : 20:52:29
|
I have just run setup.asp for forum 3, went fine
Then 6.
now it is saying I need to
To Re-install the tables you need to be logged on as a forum administrator.
do I want to re-install the tables? will it overwrite the tables for forum 3?
but this is different to the other errors I am getting.
I suppose this teaches me to try and set up 12 forums in one databse |
Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together
|
|
|
| |
Topic |
|
|
|
Topic Locked
