Node.js, sequelize and Unknown column

Question

I read this similar question: Sequelize Unknown column '*.createdAt' in 'field list'

but the solution doesn't work for me! Why? This is my code:

 var User = sequelize.define("User", {
    id: {
      type: DataTypes.UUID,
      primaryKey: true
    },
    cognome: DataTypes.STRING,
    nome: DataTypes.STRING,
    email: DataTypes.STRING,
    password: DataTypes.TEXT,
    stato: DataTypes.INTEGER,
    ruolo: DataTypes.INTEGER
  }, { 
    freezeTableName: true 
  }, {
    timestamps: false
  });

the error is:

Executing (default): SELECT `id`, `cognome`, `nome`, `email`, `data_nascita`, `password`, `cellulare`, `stato`, `blacklist`, `createdAt`, `updatedAt` FROM `Candidato` AS `Candidato`;
Unhandled rejection SequelizeDatabaseError: ER_BAD_FIELD_ERROR: Unknown column 'createdAt' in 'field list'

raina77ow · Accepted Answer · 2016-09-07 16:02:42Z

4

Instead of passing { timestamps: false } as an additional param of Sequelize.define call, you should extend the existing (third) one with the corresponding property:

var User = sequelize.define("User", {
  // model definition skipped
}, { 
    freezeTableName: true,
    timestamps: false
});

... as it described in the docs.

answered Sep 7, 2016 at 16:02

raina77ow

107k16 gold badges205 silver badges240 bronze badges

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

Collectives™ on Stack Overflow

Node.js, sequelize and Unknown column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related