error updating data in mongodb using nodejs

Question

I have the data in mongodb as:

{
  "_id":ObjectId("5415dsc5fdvfv15vff65"),
  "username":"myusername",
  "friends": [
     {
     "name":"friend1",
     "isFriend":false
     },
     {
     "name":"friend2",
     "isFriend":false
     }
  ]       
}

Now I am trying to update my 'isFriend' status to 'true'.

my nodejs code for updation is:

User.update({username:'myUsername',friends.name:'friend1'},{$set:{friends:{name:'friend1',isFriend:true}}}, function(err,val){
 console.log(val.nModified);
});

But this code shows an error Unexpected token . in friends.name

How do we do this??

abdulbari · Accepted Answer · 2016-09-04 11:38:11Z

2

Try this..

User.update({username:'myUsername','friends.name':'friend1'},{$set:{ "friends.$.name" : "updated name","friends.$.isFriend":true }}, function(err,val){
 console.log(val.nModified);
});

edited Sep 4, 2016 at 11:38

answered Sep 4, 2016 at 11:00

abdulbari

6,2625 gold badges41 silver badges65 bronze badges

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

3 Comments

Krisalay Over a year ago

it gives the ouput {ok: 1, nModified: 0, n: 0 }, so the modification is not successful

abdulbari Over a year ago

it must be work if your username and friends.name values matches in query parameter. Check proper your both values.

Krisalay Over a year ago

yeah, i was making a mistake, Thanks. I have another query: how to add 'friend3' if 'friend3' does not exist in the array.

Ebrahim Pasbani · Accepted Answer · 2016-09-04 11:16:48Z

1

Nested criteria should be string

User.update({username:'myUsername','friends.name':'friend1'},{$set:{'friends.$.isFriend': true}}, function(err,val){
 console.log(val.nModified);
});

edited Sep 4, 2016 at 11:16

answered Sep 4, 2016 at 10:54

Ebrahim Pasbani

9,4162 gold badges26 silver badges32 bronze badges

2 Comments

Krisalay Over a year ago

now the error is not showing, but the the data is also not getting updated. The value of val.nModified is 0.

Ebrahim Pasbani Over a year ago

@Krisalay The update part should be fixed. Another answer gives the right one. So I don't update mine.

alfredopacino · Accepted Answer · 2016-09-04 10:54:29Z

0

It should be enough add double quotes "friends.name"

answered Sep 4, 2016 at 10:54

alfredopacino

3,3419 gold badges48 silver badges80 bronze badges

1 Comment

Krisalay Over a year ago

now the error is not showing, but the the data is also not getting updated. The value of val.nModified is 0.

Collectives™ on Stack Overflow

error updating data in mongodb using nodejs

3 Answers 3

3 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related