Hi,
My company is taking over a forum community from another company. We have received the user list from the previous company but not the post content from the other forum.
I have successfully installed the forum software and have imported all the tables I "thought" we needed for the user data. I received the following tables:
user
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
I am able to login and manage users, and have removed the Administrator accounts (leaving my new Admin acct).
However I am having a database error now when new users try to register.
Database error in vBulletin 3.6.2:
Invalid SQL:
INSERT INTO wnforum_userfield
(userid)
VALUES
(2331);
MySQL Error : Duplicate entry '2331' for key 1 Error Number : 1062
Date : Tuesday, October 31st 2006 @ 10:42:30 AM
Script : http://forum.worldniche.com/register.php?do=addmember
Referrer : http://forum.worldniche.com/register.php?do=register
IP Address : 206.116.62.59
Username : russtesterman
Classname : vb_database
Are there additional data tables I need related to users in addition to the tables I have already imported?
Thanks,
Russ C
My company is taking over a forum community from another company. We have received the user list from the previous company but not the post content from the other forum.
I have successfully installed the forum software and have imported all the tables I "thought" we needed for the user data. I received the following tables:
user
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
I am able to login and manage users, and have removed the Administrator accounts (leaving my new Admin acct).
However I am having a database error now when new users try to register.
Database error in vBulletin 3.6.2:
Invalid SQL:
INSERT INTO wnforum_userfield
(userid)
VALUES
(2331);
MySQL Error : Duplicate entry '2331' for key 1 Error Number : 1062
Date : Tuesday, October 31st 2006 @ 10:42:30 AM
Script : http://forum.worldniche.com/register.php?do=addmember
Referrer : http://forum.worldniche.com/register.php?do=register
IP Address : 206.116.62.59
Username : russtesterman
Classname : vb_database
Are there additional data tables I need related to users in addition to the tables I have already imported?
Thanks,
Russ C
Comment