sequelize 报错
SequelizeDatabaseError: Unknown column ‘created_at’ in ‘field list’
或者
Sequelize Unknown column ‘createdAt’ in ‘field list’?
SequelizeDatabaseError: Unknown column 'created_at' in 'field list'
at Query.formatError (D:\***\express\node_modules\_sequelize@6.3.5@sequelize\lib\dialects\mysql\query.js:239:16)
at Query.run (D:\***\express\node_modules\_sequelize@6.3.5@sequelize\lib\dialects\mysql\query.js:54:18)
at process._tickCallback (internal/process/next_tick.js:68:7)
SequelizeDatabaseError: Unknown column 'created_at' in 'field list'
at Query.formatError (D:\***\express\node_modules\_sequelize@6.3.5@sequelize\lib\dialects\mysql\query.js:239:16)
at Query.run (D:\***\express\node_modules\_sequelize@6.3.5@sequelize\lib\dialects\mysql\query.js:54:18)
at process._tickCallback (internal/process/next_tick.js:68:7)
报错原因:
在sequelize中启用了时间戳(即sequelize中创建的model开启了时间戳),但是在数据库中的实际表定义不包含时间戳列。
当你做model.findAll时,会将model中的每一进行别名查询(也包括model中开启的时间戳),从而创建下面例子查询,这面就包含了数据库中实际没有的时间戳列(createdAt,updatedAt)
解决办法
在model创建的时候禁用时间戳,例如禁用mysql 表模型的时间戳
在最后加上 timestamps: false,
/* jshint indent: 2 */
module.exports = function(sequelize, DataTypes) {
return sequelize.define('sunny_sorturl', {
id: {
type: DataTypes.BIGINT,
allowNull: false,
primaryKey: true,
comment: '主键'
},
describe: {
type: DataTypes.STRING(255),
allowNull: true,
comment: '描述'
}
}, {
sequelize,
timestamps: false,
tableName: 'sunny_sorturl'
});
};