Express' Bcrypt, Passport, and Session using SQLite3's UPDATE Question

[PebblesFaith]

Dear fellow developers,

I am facing an issue with updating the password fields in my web application's SQLite3 database using express, bcrypt, passport, and session. Despite exhausting all my thought process and trying different approaches, I have not been able to successfully update the password fields for a user with a new password and confirm password. The authentication process works fine, but the update operation does not.

Here is the relevant code from my Express route:

app.post('/login2', async(req, res) => {
const email = req.body.email;
const temporary_Password = req.body.temporary_Password;
const newPassword = req.body.password;
const newConfirmPassword = req.body.confirmPassword;

console.log(req.body);
console.log('Updating password fields for user with email:', email);
console.log("password:", password);
console.log("confirmPassword:", confirmPassword);

const salt = await bcrypt.genSalt(13);
const passwordHashed = (await bcrypt.hash(req.body.password, salt)).toString();
const confirmPasswordHashed = (await bcrypt.hash(req.body.password, salt)).toString();

// Check if the email exists in the database
db1.get('SELECT * FROM users WHERE email = ?', email, (err, row) => {
    if (err) {
        console.error(err);
        console.log('SQLite3 language did not successfully execute user/s email address search properly; therefore this error means a JavaScript codes language error.');
        res.render('error500');
    }

    if (!row) {
        res.render('/login2', { error: 'Email not found' });
        console.log('User/s email was not successfully found onto the SQlite3 database.')
    }
    
    bcrypt.compare(temporary_Password, row.password, (err, result) => {
        if (err) {
            console.error(err);
            return res.status(500).send('Server Error');
        }
        if (!result) {
            return res.render('login2', { error: 'Temporary password is incorrect'})
        }
        // check if new password and confirm password match
        if (password !== confirmPassword) {
            return res.render('login2', { error: 'New password and confirm password do not match.'});
        }

        // update password-related fields in the database
        // update the password and confirm password fields
        db1.run('UPDATE users SET newPassword = ?, newConfirmPassword = ? WHERE email = ?', [passwordHashed, confirmPasswordHashed, email], (err) => {
            if (err) {
                console.log(err);
                return res.status(500).send('Server error');
            }
            // success
            res.redirect('/login');
        });
    });
});

});

I have used bcrypt to hash the passwords and compare them with the temporary password in the database. I have also checked if the email exists and if the new password and confirm password match. However, despite no errors or exceptions, the password fields in the database are not getting updated.

I have noticed that mongoose, a popular Node.js library for MongoDB, has a parameter that can assist in the update process, but SQLite3 does not seem to have a similar functionality.

I would greatly appreciate if any of you fellow developers have any insights or answers to why this update operation is not working as expected. I have been stuck on this issue for quite some time now, and any help or suggestions would be highly appreciated.

Thank you in advance for your assistance.

Best,
Sarai Hannah Ajai