ERROR: ARRAY is missing type definition for its values Sequelize

Question

I'm trying to run the command to create the migration on sequelize, on my SQL Server database, and I get the following error:

ERROR: ARRAY is missing type definition for its values

In the js file that was created is the definition:

images: {
   type: Sequelize.ARRAY
}

As the error message suggests it needs to be an array of something. e.g.: Sequelize.ARRAY(Sequelize.TEXT) Also array types are only supported on PostgreSQL. — AlwaysLearning
– AlwaysLearning, Commented May 25, 2020 at 21:55

Idan · Accepted Answer · 2020-09-28 23:44:51Z

17

After having the same problem myself, I've solved it by changing both model and migration files. They should be like this:

migration file:

images: {
     type: Sequelize.ARRAY(Sequelize.INTEGER)
}

model file:

images: DataTypes.ARRAY(DataTypes.INTEGER)

answered Sep 28, 2020 at 23:44

Idan

2273 silver badges11 bronze badges

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

1 Answer 1