User not Found but system says it exists

Description of issue or problem I’m having:
I am having strange issue, when I try to register as a user to ojs ,it says users already exists, but when I try to search the user it does not come up, any pro tip? what is happening? how to find user from the database? from the users table? if yes, I have tried that too but it does not come up there too

Steps I took leading up to the issue:

What I tried to resolve the issue:

Application Version - e.g., OJS 3.1.2:

Additional information, such as screenshots and error log messages if applicable:

Check the “users without role” checkbox before clicking search button.


@BJBMS wonderful, thanks