I'm having some trouble with a piece of code. Here's my signup function :
exports.signup = (req, res) => {
// Adding User to Database
console.log("Processing func -> SignUp");
User.create({
name: req.body.name,
username: req.body.username,
lname: req.body.lastname,
email: req.body.email,
password: bcrypt.hashSync(req.body.password, 8)
}).then(user => {
Role.findAll({
where: {
name: {
[Op.or]: req.body.roles
}
}
}).then(roles => {
user.setRoles(roles).then(() => {
res.send("User registered successfully!");
});
}).catch(err => {
res.status(500).send("Error -> " + err);
});
}).catch(err => {
res.status(500).send("Fail! Error -> " + err);
})
}
Now, let's check for duplicate users
checkDuplicateUserNameOrEmail = (req, res, next) => {
// Checking if Username is already in use
User.findOne({
where: {
username: req.body.username
}
}).then(user => {
if (user) {
res.status(400).send("Fail -> Username is already taken!");
return;
}
// Checking if Email is already in use
User.findOne({
where: {
email: req.body.email
}
}).then(user => {
if (user) {
res.status(400).send("Fail -> Email is already in use!");
return;
}
next();
});
});
}
User export details
module.exports = (sequelize, Sequelize) => {
const User = sequelize.define('users', {
name: {
type: Sequelize.STRING
},
username: {
type: Sequelize.STRING
},
password: {
type: Sequelize.STRING
}
});
return User;
}
Finally, addressing the issue encountered
An error occurred: Unknown column 'users.email' in 'where clause' at Query.formatError (C:\Users\Itzik\Desktop\לימודים\projact3\server\node_modules\sequelize\lib\dialects\mysql\query.js:244:16) at Query.handler [as onResult] (C:\Users\Itzik\Desktop\לימודים\projact3\server\node_modules\sequelize\lib\dialects\mysql\query.js:51:23) at Query.execute (C:\Users\Itzik\Desktop\לימודים\projact3\server\node_modules\mysql2\lib\commands\command.js:30:14)
at Connection.handlePacket (C:\Users\Itzik\Desktop\לימודים\projact3\server\node_modules\mysql2\lib\connection.js:449:32) at PacketParser.Connection.packetParser.p [as onPacket] (C:\Users\Itzik\Desktop\לימודים\projact3\server\node_modules\mysql2\lib\connection.js:72:12) at PacketParser.executeStart (C:\Users\Itzik\Desktop\לימודים\projact3\server\node_modules\mysql2\lib\packet_parser.js:75:16) at Socket.Connection.stream.on.data (C:\Users\Itzik\Desktop\לימודים\projact3\server\node_modules\mysql2\lib\connection.js:79:25) at Socket.emit (events.js:198:13) at addChunk (_stream_readable.js:288:12) at readableAddChunk (_stream_readable.js:269:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)