Node.jsMongoError： E11000重复密钥错误集合：

Question

我在一个djs机器人工作，我遇到了一个错误，我不知道如何修复我已经看了https://docs.mongodb.com/manual/indexes/和NodeJs，摩卡和猫鼬，但似乎没有什么帮助这里是信息-

错误发生在这里-

const Data = await serverModel.findOne({ serverID: message.guild.id });
    try{
        console.log(`checking if a database exists for ${message.guild}`);
        console.log(Data);
        if(!Data) {
            console.log(`Data base doent exist for ${message.guild}`);
            console.log(`Creating a database for ${message.guild}`);
            const server = await serverModel.create({
                serverID: message.guild.id,
                calling: 'no',
                channel: null,
                talkingWith: null,
                stickyChannel: null,
                stickyMessage: null,
                stickyID: null,
            });
            console.log('shit');
            server.save();
            return;
        }

    }
    catch(err) {
        console.log(err);
    }

这是我的服务器模型/服务器架构-

const mongoose = require('mongoose');

// ServerSchema
const ServerSchema = new mongoose.Schema({
    serverID: { type: String, require: true, unique: true, sparse:true },
    calling: { type: String, require: true, unique: false, sparse:true },
    channel: { type: String, require: true, unique: false, sparse:true },
    talkingWith: { type: String, require: true, unique: false, sparse:true },
    stickyChannel: { type: String, require: true, unique: false, sparse:true },
    stickyMessage: { type: String, require: true, unique: false, sparse:true },
    stickyID: { type: String, require: true, unique: false, sparse:true },
});

const model = mongoose.model('ServerSchema', ServerSchema);

module.exports = model;

最后，这是我得到的错误-

checking if a database exists for Vixo
null
Data base doent exist for Vixo
Creating a database for Vixo  
MongoError: E11000 duplicate key error collection: database.serverschemas index: stickyChannel_1 dup key: { stickyChannel: null }

Answer 1

似乎已经有记录与'粘性通道'参数为空值。因此，您可以尝试通过简单地为每个参数赋值来创建新记录吗？

尝试以下代码创建新记录：

`const server = await serverModel.create(
 { serverID: message.guild.id, 
   calling: 'no', 
   channel: 'test', 
   talkingWith: 'test', 
   stickyChannel: 'test, 
   stickyMessage: 'test, 
   stickyID: 'test', 
});`