How To Fix Mongoose User Findone Returning Null On Login [Solved]

What is Mongoose User findOne returning null on login?

The Mongoose User.findOne() returning null error occurs when a login query fails to locate a document matching provided credentials. This usually stems from schema mismatches, case-sensitive email queries, or querying the database before the connection is fully established.

Step-by-Step Solutions

1. Verify Field Name Consistency

Check that the key used in your findOne object exactly matches the field defined in your Mongoose Schema. A common mistake is querying for { email: req.body.userEmail } when the schema uses user_email.

// Ensure the key 'email' exists in your UserSchema
const user = await User.findOne({ email: req.body.email });

2. Handle Case Sensitivity

MongoDB queries are case-sensitive by default. If a user registered with “[email protected]” and tries to log in with “[email protected]”, the result will be null.

Always normalize your inputs by converting emails to lowercase before saving and before querying. This ensures consistency across your entire user database.

// Normalize the input to lowercase
const email = req.body.email.toLowerCase();
const user = await User.findOne({ email: email });

3. Check Async/Await Implementation

Mongoose queries are asynchronous and return a promise. If you forget the await keyword or a .then() block, the code will proceed before the database responds.

Ensure your login controller is marked as async and that you are properly awaiting the result of the database call. This prevents null results due to timing issues.

// Correct Async/Await usage
const loginUser = async (req, res) => {
    const user = await User.findOne({ email: req.body.email });
    if (!user) return res.status(404).json("User not found");
};

4. Verify Database Connection State

If your login logic triggers before mongoose.connect is successful, the query might return null or hang. Always ensure your server starts listening only after the connection is established.

mongoose.connect(process.env.MONGO_URI)
  .then(() => app.listen(5000))
  .catch(err => console.log(err));