score:101

Accepted answer

the error is caused by using the sequelize import object. instead you should use node's built in commonjs require function. so change this line in your models/index.js:

const model = sequelize['import'](path.join(__dirname, file))

to:

const model = require(path.join(__dirname, file))(sequelize, sequelize.datatypes)

you can also just regenerate the models directory and readd your models without the old index.js if you find that easier:

mv models models.bak && sequelize init:models && mv models.bak/index.js models.bak/index.js.bak && mv models.bak/* models/ && rm models.bak

that one liner will fix your problem if you have sequelize-cli installed globally. if you don't you can use this one:

npm i --save-dev sequelize-cli && mv models models.bak && npx sequelize init:models && mv models.bak/index.js models.bak/index.js.bak && mv models.bak/* models/ && rm models.bak

you may also need to update your config folder. i use a javascript config to inject envs, so i had to add to change my const config = require(... line to reflect that. if you used one of my one liners your old models/index.js file is now at index.js.bak if you need to grab any custom stuff from it.

score:0

check if you have exported the model using old javascript syntax.

in my case, it was enough to change the code from:

export default (sequelize, datatypes) => {
    ...
}

to

module.exports = (sequelize, datatypes) => {
    ...
}

score:0

people who tell downgrading not worked: watch out for your index.js file!

for me downgrading to ^5.22.3 and changing

module.exports = (sequelize, datatypes) => {
    sequelize.define('user', {
        email: {
            type: datatypes.string,
            unique: true
        },
        password: {
            type: datatypes.string
        }
    })

}

to

module.exports = (sequelize, datatypes) =>
    sequelize.define('user', {
        email: {
            type: datatypes.string,
            unique: true
        },
        password: datatypes.string
    })

worked. that was the problem for me.

score:1

  1. check that you do not have files in models directory that are not exporting anything.
  2. check that your exports are functions with same parameters as the instance it is being called in the require statement.

in any case like mine, i had empty files in my models directory. require(...) is not a function simply because the index logic is iterating over and importing files that do not export anything from the models directory.

score:1

in my case i replaced this code

const model = require(path.join(__dirname, file))( sequelize, sequelize.datatypes );

with this :

const model = require(path.join(__dirname, file)).default(sequelize, sequelize.datatypes);

score:8

this might help someone else out there, in version 6.6.5 it's deprecated and you should replace it with sequelize.define.

score:10

as of now i was able to fix the issue by downgrading the sequelize module version in your package.json to "sequelize": "^5.22.3",. do let me know if it is also fixed on your side.

edit: any sequelize version under < 6.0.0 should work as normal


Related Query

More Query from same tag