使用Mongoose的.populate()函数时遇TypeError：execPopulate不是函数求助

问题场景 #

使用Mongoose的.populate()关联admins、user、courses三个集合，User文档包含存储Course引用ID的purchasedCourses数组，尝试通过.populate()获取关联课程信息时，调用req.admin.populate('purchasedCourses').execPopulate()触发如下错误：

TypeError: req.admin.populate(...).execPopulate is not a function

相关代码 #

const express = require('express');
const app = express();
const mongoose= require('mongoose');
app.use(express.json());
const jwt=require('jsonwebtoken');

const userscheme = new mongoose.Schema({
  username:String,
  password:String,
  purchasedCourses:[{type:mongoose.Schema.Types.ObjectId,ref:'Course'}]
});
const adminSchema=new mongoose.Schema({
  username:String,
  password:String
});
const courseschema = new mongoose.Schema({
  title:String,
  description:String,
  price:Number,
  published:Boolean,
});
const User = mongoose.model('User',userscheme);
const Admins=mongoose.model('Admins',adminSchema);
const Course=mongoose.model('Course',courseschema);
// Admin routes
const usersecretkey = "secr3tkeyuser";
const adminsecretkey ="secr3tkeyadmin";
mongoose.connect('mongodb+srv://Courses-site:bbqzz1VJRZXANR6z@cluster0.dbonjha.mongodb.net/', { useNewUrlParser: true, useUnifiedTopology: true, dbName: "courses-harkirat" });
const generateadmin =(admin)=>{
  const token = jwt.sign({admin,
  },adminsecretkey);
  return token;
}
const authenticateuser=async(req,res,next)=>{
  const tokenHeader = req.headers.authorization;
 console.log("hiee");
  console.log(tokenHeader);
  if (tokenHeader) {
      const token = tokenHeader.split(' ')[1];
      console.log(token);
      try {
          const val = jwt.verify(token, usersecretkey);
          console.log(val);

          const admin = await User.findOne({username:val.username});
         // console.log(admin);
          console.log(admin);
          if (admin) {
            req.admin=admin;
              next();
          } else {
              res.status(401).json( "Unauthorized - User not found" );
          }
      } catch (error) {
       // console.error("catch block error",error);
          console.error("Token verification error:", error);
          res.status(401).json( "Unauthorized - Invalid token" );
      }
  } else {
      res.status(401).json("Unauthorized - Token not provided" );
  }
}
app.get('/users/purchasedCourses', authenticateuser,async(req, res) => {
  try {
    // Populate the 'purchasedCourses' field of the 'admin' document
    await req.admin.populate('purchasedCourses').execPopulate();

    // Retrieve the populated purchased courses from the admin document
    const purchasedCourses = req.admin.purchasedCourses;

    // Send back the populated purchased courses
    res.json(purchasedCourses);
} catch (error) {
    console.error("Error:", error);
    res.status(500).json({ error: "Internal server error" });
}
});

用户文档示例 #

{
  _id: new ObjectId("65f5d91cd9e616593d591c7b"),
  username: 'holi aa rhi h',
  password: 'vrindavan chle jldi',
  purchasedCourses: [
    new ObjectId("65f4299e6277b849cb84c680"),
    new ObjectId("65f41eaaa734861045b85aa8")
  ],
  __v: 2
}

完整错误栈 #

Error: TypeError: req.admin.populate(...).execPopulate is not a function
at C:\Users\Dell\OneDrive\Desktop\all-assignments\week-3\04-course-app-hard\index.js:227:50
at Layer.handle [as handle_request] (C:\Users\Dell\OneDrive\Desktop\all-assignments\week-3\node_modules\express\lib\router\layer.js:95:5)
at next (C:\Users\Dell\OneDrive\Desktop\all-assignments\week-3\node_modules\express\lib\router\route.js:144:13)
at authenticateuser (C:\Users\Dell\OneDrive\Desktop\all-assignments\week-3\04-course-app-hard\index.js:70:15)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

错误原因 #

1. Mongoose版本兼容问题：Mongoose 6.x及以上版本已移除execPopulate()方法，当前populate()方法直接返回Promise，无需再链式调用execPopulate()。
2. 命名混淆：认证中间件中从User集合查询到的是用户文档，却赋值给req.admin变量，虽不影响功能，但易造成逻辑混淆，建议改为req.user。

解决方案 #

方案1：移除execPopulate()直接await populate() #

修改路由代码，去掉.execPopulate()：

app.get('/users/purchasedCourses', authenticateuser,async(req, res) => {
  try {
    // 直接await populate调用，无需execPopulate
    await req.admin.populate('purchasedCourses');

    const purchasedCourses = req.admin.purchasedCourses;
    res.json(purchasedCourses);
} catch (error) {
    console.error("Error:", error);
    res.status(500).json({ error: "Internal server error" });
}
});

方案2：查询时直接执行populate（推荐） #

在认证中间件查询用户时直接关联populate，减少后续操作步骤：

const authenticateuser=async(req,res,next)=>{
  const tokenHeader = req.headers.authorization;
 console.log("hiee");
  console.log(tokenHeader);
  if (tokenHeader) {
      const token = tokenHeader.split(' ')[1];
      console.log(token);
      try {
          const val = jwt.verify(token, usersecretkey);
          console.log(val);

          // 查询时直接populate关联字段
          const user = await User.findOne({username:val.username}).populate('purchasedCourses');
          console.log(user);
          if (user) {
            req.user = user; // 修正命名为user，避免混淆
              next();
          } else {
              res.status(401).json( "Unauthorized - User not found" );
          }
      } catch (error) {
          console.error("Token verification error:", error);
          res.status(401).json( "Unauthorized - Invalid token" );
      }
  } else {
      res.status(401).json("Unauthorized - Token not provided" );
  }
}

对应的路由代码可简化为：

app.get('/users/purchasedCourses', authenticateuser,async(req, res) => {
  try {
    // 直接使用已关联好的字段
    res.json(req.user.purchasedCourses);
} catch (error) {
    console.error("Error:", error);
    res.status(500).json({ error: "Internal server error" });
}
});

内容的提问来源于stack exchange，提问作者Ishika Jain