javascript - 类型错误 : Cannot read property 'exp' of undefined

Question

我在我的 javascript 代码中使用 sqlite 作为数据库，无论我尝试什么，它总是在那里保留这个错误:

sql.get(`SELECT * FROM users WHERE userId ="${member.user.id}"`).then(row => {
          if (!row) sql.run("INSERT INTO users (userId, level, exp) VALUES (?, ?, ?)", [member.user.id, 1, 0]);
          var profile = new Discord.RichEmbed()
          .setColor(0x0000FF)
          .setTitle(member.user.username + "'s profile")
          .setThumbnail(member.user.avatarURL)
          .setDescription("Status: " + member.user.presence.status)
          .addField("Stats","**Level** " + row.level+"\n"+row.exp+"/"+row.level*10)
          msg.reply("here is "+member.user.username+"'s profile:",{embed:profile});
        })

如果您没有理解其中的一些内容，例如“msg.reply”，那是因为这些是我的 discord 机器人的命令。

Answer 1

看起来您的对象行未定义。

将所有代码包裹在 else 花括号中:

sql.get(`SELECT * FROM users WHERE userId ="${member.user.id}"`).then(row => {
      if (!row) 
        sql.run("INSERT INTO users (userId, level, exp) VALUES (?, ?, ?)", [member.user.id, 1, 0]);
      else {
        var profile = new Discord.RichEmbed()
          .setColor(0x0000FF)
          .setTitle(member.user.username + "'s profile")
          .setThumbnail(member.user.avatarURL)
          .setDescription("Status: " + member.user.presence.status)
          .addField("Stats","**Level** " + row.level+"\n"+row.exp+"/"+row.level*10)
        msg.reply("here is "+member.user.username+"'s profile:",{embed:profile});
    }
})