error 핸들, 좋아요

신동윤·2023년 2월 22일
0

console.debug('디버그 메세지');
console.info('정보 메세지');
console.warn('경고 메세지');
console.error('에러 입니다.');

이게 프론트에 보여지는건가?

Executing (default): INSERT INTO `Likes` (`likeId`,`PostId`,`UserId`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?);
node:internal/process/promises:288
            triggerUncaughtException(err, true /* fromPromise */);
            ^

Error
    at Query.run (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\sequelize\lib\dialects\mysql\query.js:52:25)
    at C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\sequelize\lib\sequelize.js:314:28
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async MySQLQueryInterface.insert (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\sequelize\lib\dialects\abstract\query-interface.js:308:21)
    at async Likes.save (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\sequelize\lib\model.js:2432:35)
    at async Likes.create (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\sequelize\lib\model.js:1344:12)
    at async LikesRepository.updatelike (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\repositories\likes.repository.js:7:26)
    at async LikesService.updatelike (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\services\likes.service.js:7:26)
    at async updatelike (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\controllers\likes.controller.js:17:24) {
  name: 'SequelizeDatabaseError',
  parent: Error: Unknown column 'createdAt' in 'field list'
      at Packet.asError (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\mysql2\lib\packets\packet.js:728:17)
      at Prepare.execute (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\mysql2\lib\connection.js:488:32)
      at PacketParser.onPacket (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\mysql2\lib\connection.js:94:12)
      at PacketParser.executeStart (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (C:\Users\DY\Desktop\codePrac\hanghae99-node\level5\node_modules\mysql2\lib\connection.js:101:25)
      at Socket.emit (node:events:513:28)
      at addChunk (node:internal/streams/readable:324:12)
      at readableAddChunk (node:internal/streams/readable:297:9)
      at Readable.push (node:internal/streams/readable:234:10) {

timestamps를 저 안쪽에 안넣고 바깥쪽에 {  } 따로 넣었더니 계속 오류가 났다.

Likes.init(
    {
      likeId: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: DataTypes.INTEGER,
      },
      PostId: {
        type: DataTypes.INTEGER,
        allowNull: false,
      },
      UserId: {
        type: DataTypes.INTEGER,
        allowNull: false,
      },
    },
    
    {
      sequelize,
      modelName: 'Likes',
      timestamps: false ,
    },
    
    
  );
  return Likes;
};

0개의 댓글