Dfyjkt

While trying to query a local MySQL database, I encounter the following error:

..servernode_modulesmysqllibprotocolParser.js:80
 throw err; // Rethrow non-MySQL errors
 ^
Incorrect arguments

No further information is provided after that.
I've looked up the already available solutions such as adding:

con.on('error', function(err) 
 console.log("[mysql error]",err);
);

or even replacing (the only) throw err in the code with console.log(err); but none did the trick.

The server eventually crashes once the error is displayed, and it happens after the console.log('Query res: ', results); in the code below, meaning that the request has been successful and has fetched the wanted data.

As I see it, it could be caused by bcrypt, but the error comes from the MySQL node.js package as seen in the logs.

loginroutes.js:

exports.login = function(req, res) 
 console.log("email:", req.body.email, "password:", req.body.password);
 var email = req.body.email;
 var password = req.body.password;

 con.query("SELECT * FROM users WHERE email = ?", [email], (err, results) => 
 if (err) 
 console.log("Error ocurred");
 res.send("code":400, "failed":"error occurred");
 else 
 console.log('Query res: ', results);
 if (results.length > 0) 
 if (bcrypt.compareSync(results.password, password))
 res.send("code":200, "success":"login successful");
 else
 res.send("code":204, "success":"email & password combination does not match");
 else
 res.send("code":204, "success":"email does not exist");
 
 );
;

What is it I missed and what can I do to solve that issue ?

Thank you.

EDIT: also tried with SELECT * FROM users WHERE email = "" + email + """ just for the sake of it, it turns out similar to the previous request.

To log any exception in the code you need to put the code block inside try catch

try 
 // your code here
 catch (error) 
 console.log(error);
 res.send( code:400, failed: "error occurred");

please try this code and paste error here.