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

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)

1 Answer 1