Ah, sorry my bad, i had put the wrong value for password hash into user_custom_fields.okay that fixes it thankyou…
… however
Even though I created the user with activate true, and it says the user is activated when I look at the user from the admin console when try to login it says:
You can’t log in yet. We previously sent an activation email to you at user@email.com . Please follow the instructions in that email to activate your account.
Why do I get that, I was trying to avoid that.