| Author |
 Topic  |
|
|
shiffman
Starting Member
USA
2 Posts |
 Posted - 09 August 2002 : 17:56:40
|
When a new member is added their member status shows "error"
If I view the member list, edit their membership as admin, and select "save" without making any changes the status changes from "Error" to "Member."
When I changed my web host I reinstalled the forum, and then uploaded the members table to my SQL server so I didn't loose their info.
Any suggestions?
Michael Shiffman
ladharma.org
shiffman@ladharma.org |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
shiffman
Starting Member
USA
2 Posts |
Posted - 10 August 2002 : 01:12:38
|
For the installation:
1. I did a full install, including the creation of empty SQL tables.
2. I entered the color configuration.
3. I imported the forums_members table.
4. I renamed the empty members table
5. I renamed the imported members table to Forums_Members
6. I set the Members_ID as the primary key.
7. I deleted the empty table.
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 August 2002 : 05:52:34
|
As I suspected the reason for your problems lies in the way you handled the members table. You shouldn't have imported the members table from Access, because DTS does not properly create the table structure in the SQL DB.
To solve the problem you need to delete the imported table, rename the empty table back to its original name, and then DTS the members table from the Access DB to to the SQL Server table. In the transformation column in DTS you need to make sure you change the settings so that the existing SQL Server table data is deleted (there will be a record, at least, there) and that enable identity insert is also checked. This will preserver the users IDs when moving the data from Access to SQL Server.
If you do it this way your problem will be solved. I am assuming your original DB was Access, but this will work no matter what DB it was.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
