[Vuejs]-Axios.put only updates some fields, not all

0👍

I didn’t check my model files in the Backend. I didn’t fully set them up to update all the fields.

My code looked like:

// Update User to Database
export const updateUserById = (data, id, result) => {
    db.query("UPDATE users SET role = ?, tier = ? WHERE userid = ?", [data.role, data.tier, id], (err, results) => {             
        if(err) {
            console.log(err);
            result(err, null);
        } else {
            result(null, results);
        }
    });   
}

So to fix it, obviously I need to add email and emailconfirmed to the SET expression.

Rookie mistake.

Thanks @hamid-davodi

Leave a comment