Updating the path would create a conflict mongoose

Question

I am trying to push to a document then set isDefault to false for all except for the one I want to set. I am having issues setting it as I am getting MongoError: Updating the path 'cards' would create a conflict at 'cards'

this is my query

    const update = { 
                
                $push: { cards: card },
                $set : { 'cards.$[].isDefault': false },
            };

const query = { id: customer.id }

this.model.findOneAndUpdate(
                query,
                update,
                { new: true },
                (err, result) => {
                    if (err) {
                        return reject(err);
                    }

                    if (!result) {
                        return reject(
                            new ModelNotFoundError(
                                `${this.name} not found update with operators`
                            )
                        );
                    }

                    resolve(result);
                }
            );

This is what my data structure looks like

[
  {
    id: 1,
    cards: [
      {
        name: "Shipit",
        fee: 4,
        isDefault: false
      },
      {
        name: "Shipit",
        fee: 3,
        isDefault: true
      }
    ],
    
  },
  {
    id: 2,
    cards: [
      {
        name: "Shipit",
        fee: 3,
        isDefault: true
      }
    ],
    
  }
]

Possible duplicate of: https://stackoverflow.com/questions/50947772/updating-the-path-x-would-create-a-conflict-at-x — Ramit Mittal, Aug 17 '22 at 02:18

score 0 · Answer 1 · answered Aug 17 '22 at 04:36

0

You can try this for the update (works without any errors and the result is as expected), using the Updates With Aggregation Pipeline feature (requires MongoDB v4.2+).

update = [
  { $set: { 
    cards: { 
      $map: { 
        input: "$cards", 
        in: { $mergeObjects: [ "$$this", { isDefault: false } ] }
      }
    }
  } },
  { $set: { 
    cards: { 
      $concatArrays: [ "$cards", [ card ] ] 
    }
  } }
]

The error you are getting is due to performing two update operations ($set and $push) on an array field.

answered Aug 17 '22 at 04:36

prasad_

12,755
2
24
36

This does not give an error again but isDefault values of previous cards does not change to false. They remain true. – King Aug 17 '22 at 13:30
I am using mongo 5.0.10 – King Aug 17 '22 at 13:36
Also I deleted my DB and recreated it but now cards aren't getting saved at all. – King Aug 17 '22 at 13:44
I will check what the issue is and get back to you shortly. – prasad_ Aug 17 '22 at 15:14
I am assuming the value of `card` in your code is something like this: `{ "name" : "new card 9", "fee": 9, "isDefault" : true }` – prasad_ Aug 17 '22 at 15:20
I tried the query in `mongo` shell connecting to MongoDB version 4.2. The update query works fine with `collection.findOneAndUpdate` method. – prasad_ Aug 17 '22 at 15:25
For some weird reason, this works in in Monogoplayground but doesn't work in my code. and does not throw any error. – King Aug 18 '22 at 04:04
But $push works. – King Aug 18 '22 at 04:04
Sorry for the late reply, timezone difference. – King Aug 18 '22 at 14:00

Updating the path would create a conflict mongoose

1 Answers1