insert into user table problem
 

I am importing the moderators data from an old forum to vb3.

this is my insert statement
"INSERT INTO
user (userid, usergroupid, membergroupids, displaygroupid, username, email, usertitle, reputation, reputationlevelid, timezoneoffset, options, startofweek, passworddate, joindate )
VALUES ('".$row2['id_comm']."', '$userGroupid', '$memberGroupid', '$displayGroupid', '".$row1['username']."', '$email', '$userTitle', '$reputation', '$reputationid', '$timeZone', '$options', '$startWeek', '$passwordDate', '$joinDate' )";

[do you need to see what i values i put in for all the constants?]

i did this for a couple of results just to check if it worked.
it did the insert correctly, and the usernames and their respective emails showup when I look at all the users present in the admincp.
but (you knew this was coming) when i click on the username (to modify the profile or something) it does nothing. when i look at the bottom of the screen it says

/admincp/user.php?do=edit&userid=

there is no userid (whereas for test subjects the userid shows up)
what do i do? is the userid number a problem. (i inserted thru admincp about 6 users, so have userids 2-7 filled when i insert thru the script to the database the userid are 5697988 & 3479651 this shouldnt be a problem tho in the database it says int(10)

Entries also need to be inserted into the userfield and usertextfield for each user added. Try the Fix Broken Profile option under Update Counters which should repair them.

yes that did work, thanx a bunch! you think it will work when i import all 500 users??? it'll do it for all of them?

-update-
actually i just checked out the tables and i can do it myself! thanx again!