코멘트 보기를 누르면
Executing (default): SELECT `Comment`.`id`, `Comment`.`comment`, `Comment`.`created_at`, `Comment`.`commenter`, `User`.`id` AS `User.id`, `User`.`name` AS `User.name`, `User`.`age` AS `User.age`, `User`.`married` AS `User.married`, `User`.`comment` AS `User.comment`, `User`.`created_at` AS `User.created_at` FROM `comments` AS `Comment` INNER JOIN `users` AS `User` ON `Comment`.`commenter` = `User`.`id` AND `User`.`id` = '3';
DatabaseError [SequelizeDatabaseError]: Unknown column 'Comment.commenter' in 'field list'
&nbsp; &nbsp; at Query.formatError

parent: Error: Unknown column 'Comment.commenter' in 'field list'
&nbsp; &nbsp; &nbsp; at Packet.asError

이런 에러가 계속 뜹니다.

<img src="https://cdn.inflearn.com/public/files/posts/1642cd58-ca04-4565-ab2d-e7a7c8c82c24/스크린샷 2021-02-15 오후 3.57.04.png" title="스크린샷 2021-02-15 오후 3.57.04.png" width="890" height="154" alt="" /><img src="https://cdn.inflearn.com/public/files/posts/93f80b4c-de87-4ca6-86d3-10b5c30fb3e3/스크린샷 2021-02-15 오후 3.56.46.png" title="스크린샷 2021-02-15 오후 3.56.46.png" width="890" height="714" alt="" />
<img src="https://cdn.inflearn.com/public/files/posts/0987124c-e5ab-4c96-8304-f58a2251db37/스크린샷 2021-02-15 오후 3.56.57.png" title="스크린샷 2021-02-15 오후 3.56.57.png" width="890" height="198" alt="" />

commenter이 아예생성이 안된거같더라구요.. 뭐가 잘못된걸까요 ㅠㅠ&nbsp;
user table과 comment테이블 둘다 관계데이터컬럼은 추가가 안된거로 보이더라구요

테이블을 지웠다가 다시 만들어보세요. 항상 시퀄라이즈 sync 후에 직접 워크벤치에 들어가서 제대로 생성되었는지 확인해보셔야 합니다.

인프런 커뮤니티 질문&답변

commenter오류