| Author |
 Topic  |
|
|
OBmoderator
New Member
98 Posts |
 Posted - 06 November 2006 : 21:22:53
|
basically what I'm trying to do is have a seperate forum but the same users.
I saw a post about changing the str string but it kept erroring our.
I want 2 seperate forums but one common membership, including avatars, ranking etc
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 November 2006 : 04:29:46
|
In config.asp, make sure your connection string points to the same database and that all the table prefixes are different except for strMemberTablePrefix. You will still need to run setup.asp on the second forum to create its tables.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 November 2006 : 05:31:14
|
| It's better to setup the 2nd forum with all the prefixes different, and once setup is completed, change the strMemberTablePrefix, as Shaggy as recommended. I think it's the best strategy to ensure everything will work as expected. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
OBmoderator
New Member
98 Posts |
Posted - 07 November 2006 : 07:53:42
|
quote:
Originally posted by Shaggy
In config.asp, make sure your connection string points to the same database and that all the table prefixes are different except for strMemberTablePrefix. You will still need to run setup.asp on the second forum to create its tables.
And I change that to what? |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 November 2006 : 07:59:45
|
You can change it to whatever you want, just make sure it's easily distinguishable from the prefix you've used for your existing forums (which, by default, would be "FORUM_"). 
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
OBmoderator
New Member
98 Posts |
Posted - 07 November 2006 : 08:47:51
|
Here is what I did.
I pointed the strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath to the first forum.
Then I renamed the str's of the second forum like this:
strTablePrefix = "FORUM1_"
strMemberTablePrefix = "FORUM1_"
strFilterTablePrefix = "FORUM1_"
Then I ran the setup.asp of the second forum
it said congratulations
when I tried to access it I got Page Not Found.
What am I missing |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 November 2006 : 08:54:17
|
Well, if it's a 404 then more than likely you're missing default.asp. Got a link?
Also, don't forget to change strMemberTablePrefix back to FORUM_ in the config.asp of your second forum so you can share the member tables. Once you've done that, you can safely delete the FORUM1_MEMBERS table in your DB.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
OBmoderator
New Member
98 Posts |
Posted - 07 November 2006 : 09:28:51
|
here is the link to the first test forum:
http://www.orientbeach.com/mod/
Here is the link to the second test forum:
http://www.orientbeach.com/mod/test/
This is the second forum config file:
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/mod/test/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables
Right now they are two seperate forums.
How do I share the member database ONLY
|
Edited by - OBmoderator on 07 November 2006 09:42:22 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 November 2006 : 09:53:34
|
I can see both forums with no problems - was there any particular page returning a 404? Also, I'd recommend placing the second forum in it's own directory rather than in a subdirectory of the first forum's directory. Finally, please read the previous replies in this topic - the final step you need to take in order to share the MEMBERS table between both forums has been posted 3 times already.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
OBmoderator
New Member
98 Posts |
Posted - 07 November 2006 : 10:12:40
|
I have read the replies Shaggy.
I just made a new web called mod2 and installed Snitz into it.
here is the way I listed the config file:
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/mod/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM1_"
strMemberTablePrefix = "FORUM1_"
strFilterTablePrefix = "FORUM1_" 'used for BADWORDS and NAMEFILTER tables
As you can see I pointed the DB to the first forum. I ran the setup and it said Congratulations etc.
Now, when I go to the second forum this is the error showing:
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM1_MODERATOR'. Make sure it exists and that its name is spelled correctly.
/mod2/default.asp, line 108
I have even tried this:
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/mod/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM1_"
strMemberTablePrefix = "FORUM_"
strFilterTablePrefix = "FORUM1_" 'used for BADWORDS and NAMEFILTER tables
and get the same error
|
Edited by - OBmoderator on 07 November 2006 10:22:35 |
|
|
|
OBmoderator
New Member
98 Posts |
Posted - 07 November 2006 : 12:10:44
|
OK I got now
First I had to edit the database and make everything that said forum_ forum1_
then I created a forum like normal
Then I had to megre the 2 databases and redirect
|
|
|
| |
Topic |
|
Topic Locked
