I'm unable to push my array to mongodb document using node.js

Question

In my previous html code when I submit it sends a post to /comment/:id then the website crashes and outputs MongoError: Unsupported projection option: $push: { comment: { content: "gfdghd" } } in my console. I don't know how to solve it and I hope I can get some help on the issue as I'm a starter with web development.

I want this to work by pushing the array which includes the req.body into a certain mongodb array default collection where it finds the parent post _id. If you need me to elaborate please ask, thanks.

This is my code:

app.js

const Post = require("./models/Post");

mongoose
  .connect("secret", {
    useNewUrlParser: true,
    useUnifiedTopology: true,
    useCreateIndex: true,
    useFindAndModify: true,
  })
  .then(() => {
    console.log("connected to mongodb cloud! :)");
  })
  .catch((err) => {
    console.log(err);
  });

app
.post("/comment/:id", authenticateUser, async (req, res) => {

  const content = req.body;

  // checks for missing fields
  if (!content){
    return res.send("Please enter all the required credentials!");
  }

  //This is where I tried to match and then push it to mongodb
  Post.update({"_id": ObjectId(req.params.id) }, {
    $push: {
      comment: content,
    }
  }, function (error, success) {
    if (error) {
        console.log(error);
    } else {
        console.log(success);
    }
});

 })

Post Mongoose Schema

Post.js

const mongoose = require("mongoose");

const PostSchema = new mongoose.Schema({

  title: {
    type: String,
    required: true,
  },
  content: {
    type: String,
    required: true,
  },
  postedAt: {
    type: String,
    default: new Date().toString()
  },
  postedBy: {
    type: String,
  },
  warned: {
    type: String,
  },
  comment: [String]
});

module.exports = new mongoose.model("Post", PostSchema);

Everything else works but the array functionality.

Jarrett GXZ · Accepted Answer · 2020-12-16 00:51:50Z

1

I think there are a few mistakes, you didn't await the request and you put "_id" when querying instead of _id. Another way you could do it too would be using findByIdAndUpdate method.

await Post.findByIdAndUpdate(req.params.id, {
  $push: {
    comment: content,
  },
  function(error, success) {
    if (error) {
      console.log(error);
    } else {
      console.log(success);
    }
  },
});

answered Dec 16, 2020 at 0:51

Jarrett GXZ

6181 gold badge8 silver badges20 bronze badges

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

3 Comments

swagz64 Over a year ago

Thank you for your feedback, but I now receive this error in console Cast to string failed for value "{ content: 'test' }" at path "comment", your method did work with a string. But I don't know why at comment: content the content const comes back with an error maybe that's on my end I'm not sure.

Jarrett GXZ Over a year ago

Am i right to say that you want to store the object {content: 'test} in the collection? Try to change the type for 'comment' under the mongoose.Schema to Object instead.

Jarrett GXZ Over a year ago

No problem! Glad i could help :)

Collectives™ on Stack Overflow

I'm unable to push my array to mongodb document using node.js

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related