[spcover]

OK. Very good. I have successfully used an INSERT command to create a test user record. See below:

INSERT INTO user values (32, 2, 'fred2', 'f5d1278e8109edd94e1e4197e04873b9', 'fred2@scarsdalenet.com', 1, '', 0, 'http://', '', '', '', '', 1, 1, 0, 'Junior Member', 0, 1048479583, 1, -1, 1048479583, 1048479583, 0, 0, '0', 1, '', '', '', 1, 0, 0, 0, 15, '0000-00-00', -1, 1, '68.70.238.236', 0, 1, 0, 0, '');

I based it off of a real user record in the "user" table. It uploads fine.

However, I have a real problem. The user "fred2" does not show up in the Members List and this seems to be a problem. For some reason, the user record is not recognized in places like the Members List and the Set New Password screen.

When I go to the Lost Password screen and input the email address "'fred2@scarsdalenet.com", the system recognizes the record and sends an email. I receive the email and click on the activation link. The system then sends an email with the username and a temporary password.

This is where I run into the next problem. I go back to the system and type in the username "fred2" and the temporary password. It takes it, displays a "Logging you in, fred2" screen, but then instead of taking me to the screen where I can reset the password, it dumps me back at the Login screen saying "You are not logged in or you do not have permission to access this page."

I've tested the Lost Password process by 1) manually registering a test user, 2) logging out, 3) going through the Lost Password/Reset Password process and that worked just fine, as it is supposed to. So I don't think there is a coding error anywhere.

And since I based my INSERT statement on an INSERT statement from a myPHPAdmin dump statement and I've double-checked the uploaded record against the other regular user records, I think the "users" record data is OK.

So I'm kind of left wondering whether there is some kind of authentication process I am missing. Do I have to set a flag for the user in some other table like "userfield"? I'm beginning to think so.

Any ideas?

Thanks in advance.

Sean