Author |
Topic  |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 24 January 2005 : 05:20:12
|
I got the "brijant" idea to set up another forum at my page. So I downloaded the latest version of Snitz. Then I did the changes in the config.asp The setup went fine, the new froum works and the old forum seems to work: http://www.finsklapphundklubb.org/Hovedforum But when you visit one of the "Diskusjonstemaer", like "Finsk Lapphund", it is nothing there....... And if one tries to logon/loginn one gets the message "Unknown user"....
In the config.asp I changed the strTablePrefix as yopu see, but left the rest unchanged. strTablePrefix = "FORUM_2" strMemberTablePrefix = "FORUM_" strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables
Does this mean all my users are deleted? And vice versa for my different discussiontopics?
:o( |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 24 January 2005 : 06:42:40
|
In the readme.htm it said: Each forum that is using the database needs to have a unique string prefix for its tables. The default prefix is "FORUM_" for both the members table and the forum tables. You will need to change this from the default value for each additional forum you have setup, if you want each forum to share the same database.
Rug |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 24 January 2005 : 09:28:07
|
I hadn't understood that you were creating a second forum. Did you create a second set of tables? Can you describe exactly what you did? What database are you using? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 24 January 2005 : 10:27:22
|
Hello I used mysql I made a "newforum" folder. Uploaded the "Snitzforum"-files including a moderated config.asp Then I did run the setup.asp Folowed the steps described. I had to do some logins to the database during this. I can not remember anything about creating a secon set of tables. Everything went fine, or seemed so, until I visited my old forum.
Rug
Im afraid I have |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 24 January 2005 : 10:37:06
|
The process of creating a second forum involves creating a new set of all the database tables, initially. Did you run setup.asp normally?
I can no longer access your forum. Did you remove it? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 24 January 2005 : 10:42:41
|
I ran setup.asp normally. But I can not remebering creating a new set of tables. I do think there was a message which said Databasetables do not need to be upgrader or something like that. The forum should be there now: http://www.finsklapphundklubb.org/Hovedforum/
|
Edited by - finsklapphundkl on 24 January 2005 10:46:56 |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 24 January 2005 : 13:02:20
|
I would suggest the following:
1. Change all your table prefixes to FORUM_2 in config.asp; 2. Run setup.asp?RC=5 after doing this; 3. Restore the prefixes to the Members and Filters tables to the current one.
Check whether both your forums work as expected then. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 24 January 2005 : 14:49:34
|
Didnt work...:o( Ive just checked the Mysql-database. There is tables for both forum and forum2, and the strange thing is that the table called forum contains data. I can not find any members except from the admin" in the table forum_members, but f.ex the table forum-topics contains the all the postings which was in the forum. I can even read what the members had written....But how th get it visible?
:o( |
Edited by - finsklapphundkl on 24 January 2005 15:00:48 |
 |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 24 January 2005 : 15:06:29
|
And now I did an interesting experiment. I registrated one of my own old useraccounts/ usernames in the forum, and then all the topics and replys I had written with that username showed up...
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 24 January 2005 : 15:55:42
|
I see. Looks like the member's data was deleted and that causes the posts not to show. Do you, or your host, have a backup from which you could restore the forum member's table? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 24 January 2005 : 16:00:39
|
Ill check If my host will be "kind".......They say their backup is for "internal" use only.....
Rug |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 02 February 2005 : 07:17:49
|
No backup-help from my host....:o(
I just backuped my database and opened the sql-file locally. Strangely enough it seems like several of the postings which have disappeared from my from, still is in the databasefile.
Is there a way to "restore" these postings?
Thanks in advance, Rug
|
 |
|
Doug G
Support Moderator
    
USA
6493 Posts |
Posted - 02 February 2005 : 23:29:53
|
Also for a 2nd forum on the same IIS webserver make sure you set up a new virtual directory/web application for the new forum, otherwise the application variables will get messed up.
|
====== Doug G ====== Computer history and help at www.dougscode.com |
 |
|
|
Topic  |
|