Mongo DB not updating, without error

Question

Trying to update the below M Lab hosted mongo DB, not much luck, any ideas? Form input via handlebars template, routed to express server. No errors, and DB does not update.

{ "_id": { "$oid": "58fdec20a8aac60a190152ae" }, "name": "Item1", "status": 0 }

app.put("/:id", function(req, res) {

    db.collection.update({_id: req.body.id}, 
        {
            $set:{status: 1}, function(){
            res.redirect("/");
            console.log('updated')
            }
    });

});

<ul> Let's Eat
  {{#each ndev}}
    <li> 
      <p>
        <form action="/:{{this._id}}?_method=PUT" method="POST">
          <input type="hidden" name="id" value="{{_id}}">{{name}}
          <button type="submit">Update</button>
        </form>
      </p>
    </li>
  {{/each}}
</ul>

Use findOneAndUpdate method, also pass {new: true} to get back updated document — georoot
– georoot, Commented Apr 25, 2017 at 2:46
Don't use findAndModify you have the _id and there would be only one document in database. Use findOneAndUpdate method — georoot
– georoot, Commented Apr 25, 2017 at 3:50

Atul Agrawal · Accepted Answer · 2017-04-25 04:50:55Z

1

Please make callback function out of $set braces just like this:

app.put("/:id", function(req, res) {
    db.collection.update({_id: req.body.id},{$set:{status: 1}}, function(err,doc)
    {
      if(err){
         console.log(err);
      }
      res.redirect("/");
      console.log('updated')        
    });
});

answered Apr 25, 2017 at 4:50

Atul Agrawal

1,5387 gold badges24 silver badges48 bronze badges

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

Comments

mjr_river · Accepted Answer · 2017-04-25 03:30:53Z

0

Using mongojs below was my solution.

app.put("/:id", function(req, res) {
    var id = req.body.id; 
    db.collection.findAndModify({
        query: { _id: mongojs.ObjectId(id)}, 
        update: { $set: {status: 1}},
        new: true},
        function(err, doc, collection){
        if(err){
            res.send(err);
            }else{
        res.redirect("/");
            }
            });
        });

answered Apr 25, 2017 at 3:30

mjr_river

1471 gold badge2 silver badges12 bronze badges

Collectives™ on Stack Overflow

Mongo DB not updating, without error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related