카테고리

질문 & 답변
세부 분야

프론트엔드
해결 여부

미해결

500 status

21.08.11 14:23 작성 조회수 195

안녕하세요 강사님
회원가입 후에 user stauts 500으로 떠서 무엇이 문제인지 모르겠어서 질문드려요
회원가입을하면 터미널에서 이상한 오류?가 뜹니다

ValidationError [SequelizeValidationError]: notNull Violation: User.email cannot be null,

notNull Violation: User.nickname cannot be null,

notNull Violation: User.password cannot be null

at InstanceValidator._validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:78:13)

at processTicksAndRejections (internal/process/task_queues.js:93:5)

at async InstanceValidator._validateAndRunHooks (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:111:7)

at async InstanceValidator.validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:93:12)

at async model.save (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:3890:7)

at async Function.create (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:2207:12)

at async C:\Users\com\vue강좌\복습\back\app.js:18:25 {

errors: [

ValidationErrorItem {

message: 'User.email cannot be null',

type: 'notNull Violation',

path: 'email',

value: null,

origin: 'CORE',

instance: [User],

validatorKey: 'is_null',

validatorName: null,

validatorArgs: []

ValidationErrorItem {

message: 'User.nickname cannot be null',

type: 'notNull Violation',

path: 'nickname',

value: null,

origin: 'CORE',

instance: [User],

validatorKey: 'is_null',

validatorName: null,

validatorArgs: []

ValidationErrorItem {

message: 'User.password cannot be null',

type: 'notNull Violation',

path: 'password',

value: null,

origin: 'CORE',

instance: [User],

validatorKey: 'is_null',

validatorName: null,

validatorArgs: []

}

]

}

SequelizeValidationError: notNull Violation: User.email cannot be null,

notNull Violation: User.nickname cannot be null,

notNull Violation: User.password cannot be null

at InstanceValidator._validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:78:13)

at processTicksAndRejections (internal/process/task_queues.js:93:5)

at async InstanceValidator._validateAndRunHooks (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:111:7)

at async InstanceValidator.validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:93:12)

at async model.save (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:3890:7)

at async Function.create (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:2207:12)

at async C:\Users\com\vue강좌\복습\back\app.js:18:25

ValidationError [SequelizeValidationError]: notNull Violation: User.email cannot be null,

notNull Violation: User.nickname cannot be null,

notNull Violation: User.password cannot be null

at InstanceValidator._validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:78:13)

at processTicksAndRejections (internal/process/task_queues.js:93:5)

at async InstanceValidator._validateAndRunHooks (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:111:7)

at async InstanceValidator.validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:93:12)

at async model.save (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:3890:7)

at async Function.create (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:2207:12)

at async C:\Users\com\vue강좌\복습\back\app.js:18:25 {

errors: [

ValidationErrorItem {

message: 'User.email cannot be null',

type: 'notNull Violation',

path: 'email',

value: null,

origin: 'CORE',

instance: [User],

validatorKey: 'is_null',

validatorName: null,

validatorArgs: []

ValidationErrorItem {

message: 'User.nickname cannot be null',

type: 'notNull Violation',

path: 'nickname',

value: null,

origin: 'CORE',

instance: [User],

validatorKey: 'is_null',

validatorName: null,

validatorArgs: []

ValidationErrorItem {

message: 'User.password cannot be null',

type: 'notNull Violation',

path: 'password',

value: null,

origin: 'CORE',

instance: [User],

validatorKey: 'is_null',

validatorName: null,

validatorArgs: []

}

]

}

SequelizeValidationError: notNull Violation: User.email cannot be null,

notNull Violation: User.nickname cannot be null,

notNull Violation: User.password cannot be null

at InstanceValidator._validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:78:13)

at processTicksAndRejections (internal/process/task_queues.js:93:5)

at async InstanceValidator._validateAndRunHooks (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:111:7)

at async InstanceValidator.validate (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\instance-validator.js:93:12)

at async model.save (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:3890:7)

at async Function.create (C:\Users\com\vue강좌\복습\back\node_modules\sequelize\lib\model.js:2207:12)

at async C:\Users\com\vue강좌\복습\back\app.js:18:25

이러한 글이 뜹니다.

Vue로 Nodebird SNS 만들기

4-6. cors와 bcrypt

강의실 바로가기

답변 2

좋아요순

최신순

답변을 작성해보세요.

문종현

질문자

2021.08.11

조현영

지식공유자

2021.08.11

에러 메시지를 번역기 돌려보세요. user의 email이 null이 되면 안 된다고 뜹니다. 지금 프론트에서 서버로 데이터를 보내는 과정 중 어딘가에서 email이 null이 되었을 겁니다.

문종현

질문자

2021.08.11

답변 감사합니다!!
4.4 강의 영상 10분가량 에 요청 보내는거 까지 확인 됩니다. 그 이후 부터 다시 들어보며 하고 있는데 똑같이 email이 null 이라 뜨는데 뭐가 잘못된건지 모르겠습니다 ㅜ 혹시 제 코드중에 잘못된 곳이 있을까요??

문종현

질문자

2021.08.11

app.post('/user', async (req, res, next) => {
    try {
        const newUser = await db.User.create({
            where: {
                email: req.body.email,
                password: req.body.password,
                nickname: req.body.nickname,
            }
        })
        res.status(201).json(newUser);
    } catch (err) {
        console.log(err)
        next(err)
    }
    
})

이 부분에서 where를 삭제하니까 되는거 같습니다. network 확인해보니 post는 201이라고는 뜨는데

맞는걸까요?? 강의 보면 노란색 글씨로 where 넣으라고 했는데

조현영

지식공유자

2021.08.11

create는 where 넣으면 안 됩니다.

문종현

질문자

2021.08.12

예 감사합니다!!^^

문종현

질문자

2021.08.11

app.js

const express = require('express');
const cors = require('cors')
const db = require('./models')
const app = express();

db.sequelize.sync();

app.use(cors('http://localhost:3000'))
app.use(express.json())
app.use(express.urlencoded({ extended: false }))

app.get('/', (req, res) => {
    res.status(200).send('Hello backend')
})

app.post('/user', async (req, res, next) => {
    try {
        const newUser = await db.User.create({
            where: {
                nickname: req.body.nickname,
                email: req.body.email,
                password: req.body.password,
            }
        })
        res.status(201).json(newUser);
    } catch (err) {
        console.log(err)
        next(err)
    }
    
})

app.listen(3085, () => {
    console.log(`백엔드 서버 ${3085}번 포트에서 작동중`)
})

user.js

module.exports = (sequelize, DataTypes) => {
    const User = sequelize.define('User', {
        email: {
            type: DataTypes.STRING(40),
            allowNull: false,
        },
        nickname: {
            type: DataTypes.STRING(20),
            allowNull: false,
        },
        password: {
            type: DataTypes.STRING(100),
            allowNull: false,
        },
    }, {
        charset: 'utf8',
        collate: 'utf8_general_ci'
    })
    User.associate = (db) => {

    }
    return User
}

front의 signup.vue

methods: {
        onSubmitForm() {
            if(this.$refs.form.validate()) {
                this.$store.dispatch('users/signUp', {
                    nickname: this.nickname,
                    email: this.email,
                    password: this.password
                })
                .then(() => {
                    this.$router.push({
                    path: '/'
                });
                })
                .catch(() => {
                    alert('회원가입 실패')
                })
            } 
        }
   },

front의 user.js

signUp({commit, state}, payload) {
        this.$axios.post('http://localhost:3085/user', {
            nickname: payload.nickname,
            email: payload.email,
            password: payload.password,
        });
        commit('setMe', payload)
   },

문종현

500 status

이 글과 비슷한 Q&A

깃허브 vue-todo 접근불가에 따른 확인요청

Not authorized to perform sts:AssumeRoleWithWebIdentity

스스로하기에서 귓속말 구현할때

강의 연장 요청드립니다.