Mongoose always returning an empty array NodeJS

Question

I have tried using find and findOne and both are not returning a document. find is returning an empty array while findOne is returning null. err in both cases in null as well.

Here is my connection:

function connectToDB(){
    mongoose.connect("mongodb://localhost/test"); //i have also tried 127.0.0.1
    db = mongoose.connection;
    db.on("error", console.error.bind(console, "connection error:"));
    db.once("open", function callback(){
        console.log("CONNECTED");
    });
};

Here is my schema:

var fileSchema = mongoose.Schema({
    hash: String,
    type: String,
    extension: String,
    size: String,
    uploaded: {type:Date, default:(Date.now)},
    expires: {type:Date, default:(Date.now()+oneDay)}
});
var Model = mongoose.model("Model", fileSchema);

And my query is here:

Model.find({},function(err, file) {
    console.log(err)
    console.log(file);  
});

I can upload things to the database and see them via RockMongo but I cannot fetch them after. This my first time using MongoDB so I think I'm just missing some of the fundamentals. Any push in the right direction would be great!

What the name of the collection you're seeing documents in via RockMongo? — JohnnyHK
– JohnnyHK, Commented Jan 6, 2013 at 15:33

JohnnyHK · Accepted Answer · 2015-06-30 20:08:09Z

83

The call to mongoose.model establishes the name of the collection the model is tied to, with the default being the pluralized, lower-cased model name. So with your code, that would be 'models'. To use the model with the files collection, change that line to:

var Model = mongoose.model("Model", fileSchema, "files");

or

var Model = mongoose.model("file", fileSchema);

edited Jun 30, 2015 at 20:08

answered Jan 6, 2013 at 15:55

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

4 Comments

thameera Over a year ago

Saved the day. Thanks a lot! It's a pity this is not highlighted in the official guide.

scniro Over a year ago

@thameera same here. I'm moving into uncharted waters from .net land and I wasted so much time on this one. Lifesaver. Yea, convention does not seemed to be mentioned anywhere, at least in my search attempts. Thank you!!!

Case Larsen Over a year ago

I found this out the hard way too -- that model("object",...) actually creates a collection called "objects". ORMs that are a bit too magical, but fortunately there's Stack Overflow!

Case Larsen Over a year ago

See also stackoverflow.com/questions/7486528/…

Prageeth godage · Accepted Answer · 2020-05-26 18:13:34Z

3

Simply inorder to avoid pluralization complexity use this:

var Model = mongoose.model("Model", fileSchema, "pure name your db collection");

It's very confusing.[at least for me.]

answered May 26, 2020 at 18:13

Prageeth godage

4,6744 gold badges34 silver badges45 bronze badges

Comments

Ahmet Korkmaz · Accepted Answer · 2020-09-28 22:52:44Z

1

Had kinda same problem. The solutions above didnt work for me. My app never returns error even if the query is not found. It returns empty array. So i put this in my code:

if(queryResult.length==0) return res.status(404).send("not found");

answered Sep 28, 2020 at 22:52

Ahmet Korkmaz

8811 bronze badges

Comments

Eugène Beliaev · Accepted Answer · 2020-11-06 11:46:34Z

1

This issue is probably coming from the fact that you are creating a mongoose model without specifying the name of the collection.

Try changing : const Model = mongoose.model("Model", fileSchema);

To this : const Model = mongoose.model("Model", fileSchema, "NameOfCollection");

answered Nov 6, 2020 at 11:46

Eugène Beliaev

1,12111 silver badges4 bronze badges

Comments

pokumars · Accepted Answer · 2020-10-30 10:38:45Z

0

const growingUnit= mongoose.model('Growing Unit', growingUnitSchema);

I had a space in 'Growing Unit' on purpose and it always returned empty array. Removing that space to become 'GrowingUnit' was the fix needed in my scenario.

const growingUnit= mongoose.model('Growing Unit', growingUnitSchema);

answered Oct 30, 2020 at 10:38

pokumars

16112 bronze badges

Comments

Ezra Siton · Accepted Answer · 2021-01-23 15:36:51Z

0

General "hello world" issues (Sometimes this issue not related to mongoose).

Check if the collection is not really empty (mongoDB atlas screenshot).

Check for small spelling differences (Like listing instead of listings) in your collection queries commands.
Check if you use the correct URI for your connection (For example you are trying to retrieve data from a collection that exists in localhost but use mongoDB cluster (Cloud) -or- any other issue related to Connection String URI). https://docs.mongodb.com/manual/reference/connection-string/

edited Jan 23, 2021 at 15:36

answered Jan 23, 2021 at 15:31

Ezra Siton

7,9672 gold badges30 silver badges44 bronze badges

Comments

Zaid Pathan · Accepted Answer · 2021-07-18 09:25:26Z

0

For me the issue was .skip(value), I was passing page=1 instead of page=0. As I was having few records, I was getting empty array always.

answered Jul 18, 2021 at 9:25

Zaid Pathan

16.9k7 gold badges105 silver badges135 bronze badges

Collectives™ on Stack Overflow

Mongoose always returning an empty array NodeJS

7 Answers 7

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related