Sequelize: Error: Include unexpected. Element has to be either a Model, an Association or an object.
Issue Description
I am trying to make a big query with many joins and it seems sequelize doesn't like the way I am doing this.
What are you doing?
const ids = [/*Some integer here*/];
models.Exercise.findAll({
// no need for that part here
attributes: [
"id",
"title",
"description",
"version",
"createdAt",
"updatedAt"
],
where: {
id: {
[Op.in]: ids
}
},
include: [
// load exercise evaluation
{
models: models.Exercise_Metrics,
as: "metrics",
attributes: [
["vote_count", "votes"],
["avg_vote_score", "avg_vote"]
]
},
// load tags linked to this exercise ( with their category included )
{
models: models.Exercise_Tag,
as: "tags",
attributes: [],
include: [
{
models: models.Tag,
attributes: ["id", "text"],
include: [
{
models: models.Tag_Category,
as: "category",
attributes: [
["kind", "category"],
["id", "category_id"]
]
}
]
}
]
}
]
});
What do you expect to happen?
I expect that to work when I use findAll
What is actually happening?
Error: Include unexpected. Element has to be either a Model, an Association or an object.
at Function._conformInclude (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:390:11)
at options.include.options.include.map.include (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:326:59)
at Array.map (<anonymous>)
at Function._conformIncludes (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:326:39)
at Function._baseMerge (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:791:10)
at Function._defaultsOptions (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:828:17)
at Function._injectScope (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:3288:10)
at Promise.try (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:1707:12)
at tryCatcher (D:\workspaceshit\exercises_library\node_modules\bluebird\js\release\util.js:16:23)
at Function.Promise.attempt.Promise.try (D:\workspaceshit\exercises_library\node_modules\bluebird\js\release\method.js:39:29)
at Function.findAll (D:\workspaceshit\exercises_library\node_modules\sequelize\lib\model.js:1706:23)
Additional context
Here are my models definitions if It could help you :
Exercise
Exercise_Metrics
Exercise_Tag
Tag
Tag_Category
Environment
- Sequelize version: 5.21.2
- Node.js version: v10.16.0
- Operating System: Windows 10
Issue Template Checklist
How does this problem relate to dialects?
- [x] I think this problem happens regardless of the dialect.
- [ ] I think this problem happens only for the following dialect(s):
- [ ] I don't know, I was using PUT-YOUR-DIALECT-HERE, with connector library version XXX and database version XXX
Would you be willing to resolve this issue by submitting a Pull Request?
- [ ] Yes, I have the time and I know how to start.
- [ ] Yes, I have the time but I don't know how to start, I would need guidance.
- [x] No, I don't have the time, although I believe I could do it if I had the time...
- [ ] No, I don't have the time and I wouldn't even know how to start.
jy95
All 70 comments
I made a typo : models instead of model
Sorry for the issue
jy95
on 16 Nov 2019
Hi so it's caused by your typo? I also have this issue, but don't know why :(
JasmineGe
on 11 Dec 2019
@JasmineGe did you figure it out?
papb
on 16 Jan 2020
same issue
aky6
on 25 Feb 2020
Same issue
abid1208
on 16 May 2020
same issue
Neulhan
on 24 May 2020
Same Issue
sajeell
on 16 Jun 2020
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
martinnaughton
on 18 Aug 2020
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I had the issue but it was because i did not use the proper name for the model name use that i defined it as
in my model i defined it as sequelize.define('houseLocation'
and in query i had lower "l"
include: [
{
model: db.houselocation,
required: true
}
],
Once i used the correct case as I had in the in model then it work. Check the name you gave it in the define bit in the model and check your case
include: [
{
model: db.houseLocation,
required: true
}
],
I just had the same issue and double checked the name of my models. They were wrong. This solved my issue.
snwfdhmp
on 10 Feb 2021
@jy95 thanks, you saved my time with simple 'as' property
include: [{model: Products, as: 'products', attributes: ['name_product']}],
bl4ckck
on 2 Mar 2021
Related issues
cjroth
路
65Comments
tornillo
路
68Comments
ludydoo
路
114Comments
felixfbecker
路
83Comments
mickhansen
路
93Comments
Most helpful comment
I made a typo :
modelsinstead ofmodelSorry for the issue