far

Sequelize notNull Violation: ~ cannot be null 에러 본문

Node

Sequelize notNull Violation: ~ cannot be null 에러

Eater 2022. 11. 29. 16:54
ValidationError [SequelizeValidationError]: notNull Violation: Image.content cannot be null
    at InstanceValidator._validate (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\instance-validator.js:50:13)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async InstanceValidator._validateAndRunHooks (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\instance-validator.js:60:7)
    at async InstanceValidator.validate (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\instance-validator.js:54:12)
    at async model.save (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\model.js:2368:7)
    at async Function.create (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\model.js:1344:12)
    at async C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\routes\post.js:74:23 {
  errors: [
    ValidationErrorItem {
      message: 'Image.content cannot be null',
      type: 'notNull Violation',
      path: 'content',
      value: null,
      origin: 'CORE',
      instance: [Image],
      validatorKey: 'is_null',
      validatorName: null,
      validatorArgs: []
    }
  ]
}
SequelizeValidationError: notNull Violation: Image.content cannot be null
    at InstanceValidator._validate (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\instance-validator.js:50:13)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async InstanceValidator._validateAndRunHooks (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\instance-validator.js:60:7)
    at async InstanceValidator.validate (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\instance-validator.js:54:12)
    at async model.save (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\model.js:2368:7)
    at async Function.create (C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\node_modules\sequelize\lib\model.js:1344:12)
    at async C:\Users\TaeIl\Desktop\frontStudy\React-Nodebird\backend\routes\post.js:74:23
POST /post 500 24.031 ms - 1182

도대체 Image.content를 왜 계속 받는건지 몰랐는데 SQL테이블 만들 때 Image에 content칼럼을 추가 시켜서 계속 500에러가 나는거였다. Models안에 칼럼 어떻게 만들고 있는지 확인하고 테이블 삭제했다가 재시작 하니까 해결

 

앞으로는 출력되는 에러 뿐 아니라 db도 확인 해야겠다.

Comments