Node.js中使用Mongoose定义全字段仍触发ValidationError问题

问题背景 #

在Node.js环境下使用Mongoose向MongoDB插入新产品数据时，触发ValidationError，报错提示多个必填字段缺失。

产品模型代码 #

const mongoose = require('mongoose');
const Schema = mongoose.Schema;

const productSchema = new Schema({
  productId: {
    type: Number,
    required: true
  },
  name: {
    type: String,
    required: true
  },
  category: {
    type: String,
    required: true
  },
  price: {
    type: Number,
    required: true
  },
  OriginalPrice: {
    type: Number,
    required: true
  },
  images: {
    type: [String],
    required: true
  },
  description: {
    type: String,
    required: true
  },
  specifications: {
    Mesurement: {
      type: String,
      required: true
    },
    Material: {
      type: String,
      required: true
    },
    Color: {
      type: String,
      required: true
    },
    ColorVariant: {
      type: [String],
    },
    Size: {
      type: [String],
    },
    Work: {
      type: String,
      required: true
    },
    StitchType: {
      type: String,
      required: true
    },
    Occasion: {
      type: String,
      required: true
    },
    PrintPattern: {
      type: String,
      required: true
    },
    SupplierSKU: {
      type: String,
      required: true
    },
    Supplier: {
      type: String,
      required: true
    },
    CountryOfOrigin: {
      type: String,
      required: true
    },
    CareGuide: {
      type: String,
      required: true
    }
  }
});

module.exports = mongoose.model('products', productSchema);

添加产品函数代码 #

exports.addProduct = async (req, res, next) => {
  try {
    const { newProduct } = req.body;
    const newProd = Product({
      productId: newProduct.productId,
      name: newProduct.name,
      category: newProduct.category,
      price: newProduct.price,
      OriginalPrice: newProduct.OriginalPrice,
      Images: newProduct.Images,
      description: newProduct.description,
      specifications: {
        Mesurements: newProduct.Mesurements,
        Material: newProduct.Material,
        Color: newProduct.Color,
        ColorVariant: newProduct.ColorVariant,
        Size: newProduct.Size,
        Work: newProduct.Work,
        StitchType: newProduct.StitchType,
        Occasion: newProduct.Occasion,
        printPattern: newProduct.printPattern,
        SupplierSKU: newProduct.SupplierSKU,
        supplier: newProduct.supplier,
        CountryOfOrigin: newProduct.CountryOfOrigin,
        CareGuide: newProduct.CareGuide,
      }
    });
    await newProd.save();
    res.json({
      data: true
    })
  } catch (error) {
    next(error);
  }
}

报错信息 #

ValidationError: products validation failed: specifications.Supplier: Path `specifications.Supplier` is required., specifications.PrintPattern: Path `specifications.PrintPattern` is required., specifications.Mesurement: Path `specifications.Mesurement` is required., name: Path `name` is required., category: Path `category` is required., price: Path `price` is required., OriginalPrice: Path `OriginalPrice` is required., description: Path `description` is required., specifications.Material: Path `specifications.Material` is required., specifications.Color: Path `specifications.Color` is required., specifications.Work: Path `specifications.Work` is required., specifications.StitchType: Path `specifications.StitchType` is required., specifications.Occasion: Path `specifications.Occasion` is required., specifications.SupplierSKU: Path `specifications.SupplierSKU` is required., specifications.CountryOfOrigin: Path `specifications.CountryOfOrigin` is required., specifications.CareGuide: Path `specifications.CareGuide` is required.
at Document.invalidate (C:\Users\Priya\OneDrive\Desktop\Client Site\server\node_modules\mongoose\lib\document.js:3087:32)
at C:\Users\Priya\OneDrive\Desktop\Client Site\server\node_modules\mongoose\lib\document.js:2880:17
at C:\Users\Priya\OneDrive\Desktop\Client Site\server\node_modules\mongoose\lib\schematype.js:1350:9
at process.processTicksAndRejections (node:internal/process/task_queues:77:11)

原因分析 #

报错核心是代码中字段名与Mongoose模型定义的字段名不匹配，Mongoose严格按模型字段名的大小写、拼写进行验证，不匹配会被识别为字段未赋值，触发必填校验失败：

1. 顶级字段：模型定义为images（小写i），代码中写成Images（大写I）
2. 嵌套字段specifications：
   • 模型定义Mesurement，代码写成Mesurements（多了末尾的s）
   • 模型定义PrintPattern，代码写成printPattern（首字母小写）
   • 模型定义Supplier，代码写成supplier（首字母小写）
3. 额外风险：如果前端传入的newProduct对象字段名和后端代码不一致，同样会导致字段值为undefined，触发校验失败。

解决方法 #

将添加产品代码中的字段名修正为与模型完全一致，同时确认前端传参字段名匹配：

exports.addProduct = async (req, res, next) => {
  try {
    const { newProduct } = req.body;
    // 开发阶段打印确认传入数据的结构和完整性
    console.log('传入产品数据:', newProduct);
    const newProd = Product({
      productId: newProduct.productId,
      name: newProduct.name,
      category: newProduct.category,
      price: newProduct.price,
      OriginalPrice: newProduct.OriginalPrice,
      // 修正字段名：Images -> images
      images: newProduct.images,
      description: newProduct.description,
      specifications: {
        // 修正拼写：Mesurements -> Mesurement
        Mesurement: newProduct.Mesurement,
        Material: newProduct.Material,
        Color: newProduct.Color,
        ColorVariant: newProduct.ColorVariant,
        Size: newProduct.Size,
        Work: newProduct.Work,
        StitchType: newProduct.StitchType,
        Occasion: newProduct.Occasion,
        // 修正大小写：printPattern -> PrintPattern
        PrintPattern: newProduct.PrintPattern,
        SupplierSKU: newProduct.SupplierSKU,
        // 修正大小写：supplier -> Supplier
        Supplier: newProduct.Supplier,
        CountryOfOrigin: newProduct.CountryOfOrigin,
        CareGuide: newProduct.CareGuide,
      }
    });
    await newProd.save();
    res.json({
      data: true
    })
  } catch (error) {
    next(error);
  }
}

额外建议：

• 确保前端传入的newProduct对象字段名与后端代码完全一致，比如传images而非Images，Mesurement而非Mesurements
• 开发阶段通过console.log(newProduct)快速排查传参是否完整，避免因前端漏传字段导致校验失败

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