Mongoose query return null

Question

I can't seem to get a response from mongodb. I am using node.js and mongodb with the help of mongoose.

In my node.js app I have

mongoose.connect('mongodb://localhost:27017/myDB');

var Schema = mongoose.Schema,
    ObjectId = Schema.ObjectId;

var BlogPost = new Schema({
    author  : ObjectId,
    title   : String,
    slug    : { type: String, lowercase: true, trim: true },
    content : String,
    summary : String,
    date    : Date
})

var BlogModel = mongoose.model('BlogPost', BlogPost);

BlogModel.find({}, function(docs){
   console.log(docs);
});

If I type show dbs in the mongo shell I get

admin   (empty)
myDB       0.203125GB
local   (empty)
test    (empty)

db.blogmodel.find() returns :

{ "_id" : ObjectId("50108d3df57b0e3375a20479"), "title" : "FirstPost" }

and yes I do have mongod running.

Fixed Solution

var BlogModel = mongoose.model('blogmodel', BlogPost, 'blogmodel');

It works because its (model name, schema name, collection name)

This issue has driven me crazy! I added credit for your fixed solution part! — efkan
– efkan, Commented Jan 9, 2015 at 7:44

aaronheckmann · Accepted Answer · 2012-07-26 03:56:15Z

43

Mongoose pluralizes model names so it's running find on the "blogposts" collection instead of "blogpost". That said, your query in the mongo shell is on the "blogmodel" collection. In that case:

var BlogModel = mongoose.Model("BlogModel", ..)

or pass the collection name as the third param:

var BlogModel = mongoose.model("BlogPost", schema, "blogmodel")

answered Jul 26, 2012 at 3:56

aaronheckmann

10.8k2 gold badges42 silver badges30 bronze badges

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

2 Comments

lostAstronaut Over a year ago

Thanks man, I had to change it to the above fix but your post helped me solve it so i'll give you the answer.

Christopher Chalfant Over a year ago

Thank you! Why isn't this in the mongoose docs? mongoosejs.com/docs/models.html

JohnnyHK · Accepted Answer · 2012-07-26 03:10:53Z

6

The first parameter to your BlogModel.find callback is err, the second parameter is docs. So your code should be:

BlogModel.find({}, function(err, docs){
   console.log(docs);
});

answered Jul 26, 2012 at 3:10

JohnnyHK

313k70 gold badges631 silver badges477 bronze badges

2 Comments

JohnnyHK Over a year ago

Does the BlogPosts collection contain documents if you query it from the mongo shell?

lostAstronaut Over a year ago

I added it to the original post and yes I have one document for testing, Which I can't find for some reason.

chichilatte · Accepted Answer · 2022-01-19 13:08:07Z

1

For anyone still experiencing this issue even after checking the accepted answer – make sure your database connection url contains the database name, e.g. for database name myDB...

mongoose.connect(`mongodb://localhost:27017/myDB`)

I'd forgotten it and my mongoose searches were all returning null or empty arrays.

answered Jan 19, 2022 at 13:08

chichilatte

1,90123 silver badges27 bronze badges

Comments

marc_s · Accepted Answer · 2016-12-23 21:01:11Z

0

I experienced similar error yesterday, in my case error was caused by data imported to mongo. After I used mongoimport key _id was stored as string instead of ObjectId. When I was querying data in mongo everything works well, but in Mongoose when I was trying find something by _id it always returned null or empty Array. I hope that info might by useful for someone.

edited Dec 23, 2016 at 21:01

marc_s

760k185 gold badges1.4k silver badges1.5k bronze badges

answered Dec 10, 2015 at 16:36

Lukasz Piwowar

462 bronze badges

Collectives™ on Stack Overflow

Mongoose query return null

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Linked

Related