$push to an array in MongoDB with mongoose doesn't work

Question

errmsg: 'The field \'weight\' must be an array but is of type int in document

My Schema:

weight: [{
  type: Number
}]

and my post request:

app.post('/edit', function(req, res){
    var update = {  $push: {"weight": req.body.weight}};
    User.findOneAndUpdate(conditions, update, options, function (err)
    {
      if (err)
      {
          console.log(err);
      }
      else
      {
          console.log('yep');
      }
    })
});

Looks like your field is something like {"weight": 3} in db and you're using $push to push array value into int type field. — s7vr
– s7vr, Commented Apr 7, 2017 at 16:13
So, I should change the schema to smth like: weight: [{ type: Array }], ? it doesn't work — Elena
– Elena, Commented Apr 7, 2017 at 16:23
No, the schema definition is correct. I meant to suggest that you've to fix the data in the weight field first. It should look like {"weight": [3]} in db and you can use the update with $push to add more values into array. So you possibly need like a update script to change the data first. See if this answer help. stackoverflow.com/questions/7401394/… — s7vr
– s7vr, Commented Apr 7, 2017 at 16:27

Alex Blex · Accepted Answer · 2017-04-07 15:54:47Z

0

If there are multiple documents in the collection that match your conditions, you can update only suitable one by adding { weight: { $type: 4 } } to your conditions.

Otherwise your application's schema doesn't match data in the database.

answered Apr 7, 2017 at 15:54

Alex Blex

37.3k7 gold badges53 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Elena Over a year ago

I use a user_id as a condition, so I have only one record

Alex Blex Over a year ago

Then it falls into 'otherwise' part of the answer.

henhen · Accepted Answer · 2019-08-11 01:33:18Z

-1

This might work.

//Schema

weight: [Number]

http://mongoosejs.com/docs/schematypes.html

//Or this way too if pushing objects into array

//Schema

weight: [{
  weight: {
    type: Number
  }
}]

//Then in API

var update = {  $push: {"weight": { "weight": req.body.weight }}};

edited Aug 11, 2019 at 1:33

answered Apr 8, 2017 at 7:14

henhen

1,2535 gold badges20 silver badges43 bronze badges

Collectives™ on Stack Overflow

$push to an array in MongoDB with mongoose doesn't work

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related