Inserting users gives guest title or status

[SmakDaddy]

I am trying to use phpMyAdmin to insert just a few fields from my old user database on my old non-forum system. The sample query I listed below works but in this example, I was inserting the data for my site moderators.

INSERT INTO `user` VALUES('', '7', '', 'SampleUserName', '6937360e755b1aa80e0b9a719a78daa2', '', 'fake@address.com', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');My issue is that when my moderators post anything to the forums, they're listed with guest under their usernames and their post count does not increase. I think they're also having other issues as well and I'm thinking that it's all related to the user info in the database.

Is there something I missed or that I need to add to my queries? I will be inserting about 1000 member accounts into this system but I don't want to go any further until I can get the information to insert correctly. No point in adding them to the system until they can jump in with both feet.

Thanks in advance!

[Jake Bunce]

That is because their profiles are incomplete. When manually inserting users you need to insert records in these three tables:

user
userfield
usertextfield

Otherwise their profiles will not be complete which will cause lots of problems.

Run this option to fix existing broken profiles:

Admin CP -> Maintenance -> Update Counters -> Fix broken user profiles

[SmakDaddy]

Jake, you have my undying gratitude. Thank you so much. I will go review those tables and see what needs to be added to them so I can import the rest of my users.

EDIT: I looked at userfield and usertextfield after I did the Admin CP update but I think something still isn't quite right. Most every field in those two tables just says NULL and I think my moderators still don't have all the access they need.

[Jake Bunce]

Most of the fields are NULL until the user enters information into them. There are fields for location, occupation, signature, friends list, etc. New users don't have these things set yet. The important thing is that the record exists for their userid.

What access are they missing? Perhaps you need to set their mod permissions:

Admin CP -> Forums & Moderators -> Show All Moderators

[SmakDaddy]

Thanks for the reply, Jake. Some of the moderators can upload their avatars while others can't. I also went and added about 20 more users via SQL and followed your instructions above, but the system is still only reporting 7 total members. At this point, I think I'd be better off just starting over and having them sign up again. Not too much of a pain.

:)