Mongoose中无法用ObjectId填充字段问题求助

问题背景 #

我学习React已有数月，目前在使用Mongoose填充字段时遇到困难。我有Project和User两个集合，每个Project包含：

• createdBy：单个ObjectId
• participants：包含user.ObjectId及项目相关其他字段的对象数组

项目数据结构 #

{
  _id: new ObjectId('65b518c381cfb1bec92fe0b9'),
  title: 'Project 0',
  createdBy: new ObjectId('65aabac39125371ade73ddf0'),
  brief: 'Du blabla, plein de blabla',
  deadline: 2024-03-20T18:00:00.245Z,
  participants: [
    {
      _id: new ObjectId('65c241ed2d462330785bb2e4'),
      accessLVL: 'lead',
      joinDate: 2024-01-27T17:09:07.245Z,
      userID: new ObjectId('65aabac39125371ade73ddf0')
    },
    {
      _id: new ObjectId('65c241ed2d462330785bb2e5'),
      accessLVL: 'member',
      joinDate: 2024-01-27T17:09:07.245Z,
      userID: new ObjectId('65aabac39125371ade73ddf4')
    },
    {
      _id: new ObjectId('65c241ed2d462330785bb2e6'),
      accessLVL: 'member',
      joinDate: 2024-01-27T17:09:07.245Z,
      userID: new ObjectId('65aabac39125371ade73ddf2')
    }
  ],
  submits: [
    {
      _id: new ObjectId('65c241ed2d462330785bb2e2'),
      submitImage: [Array],
      userId: new ObjectId('65aabac39125371ade73ddf4'),
      update: 1999-12-31T23:00:00.000Z,
      callback: [Array]
    }
  ],
}

Schema配置 #

const ProjectSchema = new Schema(
  { title: String,
    createdBy: {
      type: mongoose.Schema.Types.ObjectId, ref: "User", require:true, 
      min: 2,
      max: 100,
    },
    createdAt: {
      type: Date,
      required: true,
      max: 50,
      unique: true,
    },
    participants: [{
        userID: {type: mongoose.Schema.Types.ObjectId, ref: "User", require:true}, 
        accessLVL: {
            type: String,
            enum: ["member", "lead", "guest"],
            default: "member",
          },
        joinDate: Date,
    }],
    deadline: Date,
    brief: String,
    submits: [{
      userID: {type: mongoose.Schema.Types.ObjectId, ref: "User", require:true},
      submitImage: [String],
      update: Date,
      callback: [{
            userID: {type: mongoose.Schema.Types.ObjectId, ref: "User", require:true},
            callback: String,
            majDate: Date,
      }],
    }],
    close: Boolean,
    closeDate: Date, 
},
{ timestamps: true }
);

const UserSchema = new Schema(
  {id: {
    type: String
  },
  avatar: {
    type: String,
    required: true,
    max: 100,
  },
  name: {
    type: String,
    required: true,
    min: 2,
    max: 100,
  },
  email: {
    type: String,
    required: true,
    max: 50,
    unique: true,
    lowercase: true,
    index: true,
  },
  password: {
    type: String,
    required: true,
    min: 5,
  },
  affiliate: {
    type: String,
    required: true,
    min: 5,
  },
  contact: {
    type:String,
    max: 20,
  },
  ongoing: [{
      type: mongoose.Schema.Types.ObjectId, 
      ref: "Project",
  }],
  occupation: {
    type: String,
    max: 30,
  },
  status: {
    type: String,
    enum: ["team", "client"],
    default: "team",
  },
  privilege: {
    type: String,
    enum: ["user", "manager", "admin"],
    default: "user",
  },
  registerDate: Date,
  lastSeen: Date,
  
},
{ timestamps: true }
);

问题现象 #

使用以下查询代码时，createdBy字段返回null：

const fetchProjects = async (req, res) => {
    try {
    const projects = await Project.find().populate("createdBy");
    console.log(projects[0]);
    res.json({projects});
    } catch(err) {
        return res.sendStatus(404);
    }
}

打印结果片段：

_id: new ObjectId('65b518c381cfb1bec92fe0b9'),
  title: 'Project 0',
  createdBy: null,
  brief: 'Du blabla, plein de blabla',
...

尝试过Project.find().populate("createdBy")、Project.find().populate({path:"createdBy", model:"User"})等写法，结果一致。

排查建议 #

1. 验证关联用户文档是否存在
   直接通过User.findById("65aabac39125371ade73ddf0")查询对应ID的用户，如果该用户不存在，populate必然返回null。

2. 检查Model注册顺序与名称

   • 确保User Model在Project Model之前注册，Mongoose需要先识别User模型才能处理ref关联。
   • 确认Model注册名称与Schema中ref一致：比如注册时是mongoose.model("User", UserSchema)，ref字段必须写"User"（大小写敏感）。

3. 移除Schema中无效的字段约束
   ObjectId类型的字段不需要min/max约束，Date类型也不需要max约束，这些无效约束可能导致Schema解析异常，建议修改：

   // 修正后的createdBy字段
   createdBy: {
     type: mongoose.Schema.Types.ObjectId, 
     ref: "User", 
     required:true
   },
   // 修正后的createdAt字段
   createdAt: {
     type: Date,
     required: true,
     unique: true
   }
   

4. 确认数据库中ObjectId的正确性
   在MongoDB Compass或命令行中查看Project文档的createdBy值，确保它是有效的ObjectId，且与User集合中的某个_id完全匹配（注意不要有额外空格或字符）。

5. 嵌套数组字段的正确填充写法
   如果需要填充participants中的userID，需使用嵌套populate：

   const projects = await Project.find()
     .populate("createdBy")
     .populate({
       path: "participants",
       populate: { path: "userID", model: "User" }
     });
   

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