Not able to import users don't have the email id

[PolicyWala]

After import some posting showing as GUEST and posts count as 0
The problem for the above is that some users don't have the email id associated with them. Can somebody tell me SQL query. To update the same(email) in my old database. Pls help.

[Steve Machol]

As you said the problem is that those users do not have a valid email address, hence they cannot be imported into vB as users. You would need to assign each of then a valid email address in the source database, then redo the import.

[Jerry]

Best to get the users to add emails in the old system before doing the import.

If you just set them all to import@example.com then they can't update their passwords.

[PolicyWala]

Hi,

I have changed the email Id of all the users who dont have the email id in the old database. Now I am redo the impex module but still I am not able to Import the users.

Anything wrong I am doing. Please help

[Steve Machol]

What is happening?

[PolicyWala]

I am able to import only users whom have email id associated previously. The users whom I have given new email id, I am not able to import those.

[Steve Machol]

How did you add those email addresses? I'm afraid whichever method you used is not valid enough for vB to recognize this data.

[PolicyWala]

I have manualy added the email address and then uploaded the data in the database.

[Steve Machol]

Then the method you are using is not adding this info correctly. You have to find a different way - preferably from the original software and admin panel.

[PolicyWala]

Thanks a lot for quick reply.

[Jerry]

Also, if you are importing again make sure you clear out the old import or even better use a clean import.

[PolicyWala]

Thanks Jerry!

I have one query - Can I use following query thru myphpadmin to inseart email ids to the users who dont have email id -



UPDATE useremailid='x@xyz.com' WHERE useremailid=0

[Jerry]

Thanks Jerry!

I have one query - Can I use following query thru myphpadmin to inseart email ids to the users who dont have email id -



UPDATE useremailid='x@xyz.com' WHERE useremailid=0

I'm not sure of the schema of the source table, though that will put in the email where it's 0, if it is 0 opposed to NULL or something else.

[PolicyWala]

I'm not sure of the schema of the source table, though that will put in the email where it's 0, if it is 0 opposed to NULL or something else.

Hi Jerry,
Thanks Again.

I have imported all the users but still some users are showing as Guest and post count 0. How to fix this.

Pls help

[PolicyWala]

I have used following query.



UPDATE user SET email='youremail@youremail.com'WHERE email=''

[PolicyWala]

I have got another post with the same issue -

If the username is bold and all the other information in the user section of the post is correct:

AdminCP > User Ranks > User Rank Manager > Guest > Delete

If the post appears as a guest post, i.e. the username is not big and bold and there is no postcount or other information in the post, then

AdminCP > Maintenance > Fix Broken User Profiles

If neither of them resolve the issue then it is a problem with the import in which case you should clear the imported data and start over with the import.

Will try again with this and update you.