Sometimes, we want to fix “Unknown column ‘*.createdAt’ in ‘field list’” in Sequelize.

In this article, we’ll look at how to fix “Unknown column ‘*.createdAt’ in ‘field list’” in Sequelize.

How to fix “Unknown column ‘*.createdAt’ in ‘field list’” in Sequelize?

To fix “Unknown column ‘*.createdAt’ in ‘field list’” in Sequelize, we should make sure the created_at column is in the database table and the createAt property is in the model.

For instance, we write

const users = sequelize.define('users', {
  id: {
    type: Sequelize.INTEGER,
    primaryKey: true
  },
  createdAt: {
    field: 'created_at',
    type: Sequelize.DATE,
  },
  updatedAt: {
    field: 'updated_at',
    type: Sequelize.DATE,
  },
  //...
})

to call sequelize.define to define the 'users' model.

In it, we add the createdAt column and set the column type to Sequelize.DATE.

And we map the field to the created_at column in the users table.

Conclusion

To fix “Unknown column ‘*.createdAt’ in ‘field list’” in Sequelize, we should make sure the created_at column is in the database table and the createAt property is in the model.