类型错误:无法读取登录路由中未定义的属性“密码" [英] TypeError: Cannot read property 'password' of undefined in login route

问题描述

当我使用 mysql 数据库中不存在的电子邮件请求 api 时，它会引发错误，但在相反的条件下它会运行.

When i'm requesting the api with the email which does not exist in the mysql DB it throws a error but in the opposite condition it runs.

错误:

S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^

TypeError: Cannot read property 'password' of undefined
    at Query.db.query (S:\#development\Pepperkart\pepperkart-backend\routes\users.js:19:43)
    at Query.<anonymous> (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\Connection.js:525:10)
    at Query._callback (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\Connection.js:491:16)
    at Query.Sequence.end (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
    at Query._handleFinalResultPacket (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\sequences\Query.js:139:8)
    at Query.EofPacket (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\sequences\Query.js:123:8)
    at Protocol._parsePacket (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (S:\#development\Pepperkart\pepperkart-backend\node_modules\mysql\lib\protocol\Protocol.js:38:16)
[nodemon] app crashed - waiting for file changes before starting...

我的api是这样的:

router.post('/login', (req, res) => {
    var email = req.body.email
    var password = req.body.password

    var GRAB_USER = `SELECT * FROM user_details WHERE email = ?`
    db.query(GRAB_USER, email, (err, result) => {
        if (err) {
            res.send('email not found')
        } else {
            var user = result[0]

            bcrypt.compare(password, user.password, (err, match) => {
                if (err) {
                    res.send('password not match')
                } else {
                    res.send(user)
                }
            });
        }
    })
})

推荐答案

您的查询没问题，没有报错，所以您还应该检查 result.length>0 然后 res.send('email not found')

your query is fine and not giving error so you should also check result.length> 0 and then res.send('email not found')

router.post('/login', (req, res) => {
  var email = req.body.email
  var password = req.body.password

  var GRAB_USER = `SELECT * FROM user_details WHERE email = ?`
  db.query(GRAB_USER, email, (err, result) => {
    if (err) {
        res.send('email not found')
    } 
    else if (result.length==0) {
      res.send('email not found') //this is what you are missing
    }
    else {
      var user = result[0]

      bcrypt.compare(password, user.password, (err, match) => {
        if (err) {
          res.send('password not match')
        } else {
          res.send(user)
        }
      });
    }
  })
})

这篇关于类型错误:无法读取登录路由中未定义的属性“密码"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！