inflearn logo
Khóa học

Khóa học

Chia sẻ kiến thức

Bài viết của kimsh59931433

kimsh59931433 kimsh59931433

@kimsh59931433

Số lượng đánh giá đã viết
41
Xếp hạng trung bình
5.0

Bài viết 4

Hỏi & Đáp

소켓 이벤트 연결하기를 시청하다가 504 (Gateway Timeout) 오류가 떴습니다.

Executing (default): SELECT id , email , nickname , password , createdAt , updatedAt , deletedAt FROM users AS User WHERE (`User`.`deletedAt` IS NULL AND User .`email` = ' lee123@naver.com '); Executing (default): SELECT id , nickname , email FROM users AS User WHERE (`User`.`deletedAt` IS NULL AND User .`id` = 8); POST /api/users/login 200 255.278 ms - 55 Executing (default): SELECT User .`id`, User .`nickname`, User .`email`, Workspaces .`id` AS Workspaces.id , Workspaces .`name` AS Workspaces.name , Workspaces .`url` AS Workspaces.url , Workspaces .`createdAt` AS Workspaces.createdAt , Workspaces .`updatedAt` AS Workspaces.updatedAt , Workspaces .`deletedAt` AS Workspaces.deletedAt , Workspaces .`OwnerId` AS Workspaces.OwnerId , Workspaces->WorkspaceMember .`loggedInAt` AS Workspaces.WorkspaceMember.loggedInAt , Workspaces->WorkspaceMember .`createdAt` AS Workspaces.WorkspaceMember.createdAt , Workspaces->WorkspaceMember .`updatedAt` AS Workspaces.WorkspaceMember.updatedAt , Workspaces->WorkspaceMember .`WorkspaceId` AS Workspaces.WorkspaceMember.WorkspaceId , Workspaces->WorkspaceMember .`UserId` AS Workspaces.WorkspaceMember.UserId FROM users AS User LEFT OUTER JOIN ( workspacemembers AS Workspaces->WorkspaceMember INNER JOIN workspaces AS Workspaces ON Workspaces .`id` = Workspaces->WorkspaceMember .`WorkspaceId`) ON User .`id` = Workspaces->WorkspaceMember .`UserId` AND (`Workspaces`.`deletedAt` IS NULL) WHERE (`User`.`deletedAt` IS NULL AND User .`id` = 8); Executing (default): SELECT User .`id`, User .`nickname`, User .`email`, Workspaces .`id` AS Workspaces.id , Workspaces .`name` AS Workspaces.name , Workspaces .`url` AS Workspaces.url , Workspaces .`createdAt` AS Workspaces.createdAt , Workspaces .`updatedAt` AS Workspaces.updatedAt , Workspaces .`deletedAt` AS Workspaces.deletedAt , Workspaces .`OwnerId` AS Workspaces.OwnerId , Workspaces->WorkspaceMember .`loggedInAt` AS Workspaces.WorkspaceMember.loggedInAt , Workspaces->WorkspaceMember .`createdAt` AS Workspaces.WorkspaceMember.createdAt , Workspaces->WorkspaceMember .`updatedAt` AS Workspaces.WorkspaceMember.updatedAt , Workspaces->WorkspaceMember .`WorkspaceId` AS Workspaces.WorkspaceMember.WorkspaceId , Workspaces->WorkspaceMember .`UserId` AS Workspaces.WorkspaceMember.UserId FROM users AS User LEFT OUTER JOIN ( workspacemembers AS Workspaces->WorkspaceMember INNER JOIN workspaces AS Workspaces ON Workspaces .`id` = Workspaces->WorkspaceMember .`WorkspaceId`) ON User .`id` = Workspaces->WorkspaceMember .`UserId` AND (`Workspaces`.`deletedAt` IS NULL) WHERE (`User`.`deletedAt` IS NULL AND User .`id` = 8); Executing (default): SELECT id , name , url , createdAt , updatedAt , deletedAt , OwnerId FROM workspaces AS Workspace WHERE (`Workspace`.`deletedAt` IS NULL AND Workspace .`url` = 'sleact'); Executing (default): SELECT id , name , url , createdAt , updatedAt , deletedAt , OwnerId FROM workspaces AS Workspace WHERE (`Workspace`.`deletedAt` IS NULL AND Workspace .`url` = 'sleact'); Executing (default): SELECT Channel .`id`, Channel .`name`, Channel .`private`, Channel .`createdAt`, Channel .`updatedAt`, Channel .`WorkspaceId`, Members .`id` AS Members.id , Members->ChannelMembers .`ChannelId` AS Members.ChannelMembers.ChannelId , Members->ChannelMembers .`UserId` AS Members.ChannelMembers.UserId FROM channels AS Channel INNER JOIN ( ChannelMembers AS Members->ChannelMembers INNER JOIN users AS Members ON Members .`id` = Members->ChannelMembers .`UserId` AND Members->ChannelMembers .`UserId` = 8) ON Channel .`id` = Members->ChannelMembers .`ChannelId` AND (`Members`.`deletedAt` IS NULL) WHERE Channel .`WorkspaceId` = 1; Executing (default): SELECT User .`id`, User .`nickname`, User .`email`, WorkspaceMember .`loggedInAt` AS WorkspaceMember.loggedInAt , WorkspaceMember .`createdAt` AS WorkspaceMember.createdAt , WorkspaceMember .`updatedAt` AS WorkspaceMember.updatedAt , WorkspaceMember .`WorkspaceId` AS WorkspaceMember.WorkspaceId , WorkspaceMember .`UserId` AS WorkspaceMember.UserId FROM users AS User INNER JOIN workspacemembers AS WorkspaceMember ON User .`id` = WorkspaceMember .`UserId` AND WorkspaceMember .`WorkspaceId` = 1 WHERE (`User`.`deletedAt` IS NULL); GET /api/workspaces/sleact/channels 200 46.302 ms - 2114 GET /api/workspaces/sleact/members 200 49.981 ms - 666 Executing (default): SELECT User .`id`, User .`nickname`, User .`email`, Workspaces .`id` AS Workspaces.id , Workspaces .`name` AS Workspaces.name , Workspaces .`url` AS Workspaces.url , Workspaces .`createdAt` AS Workspaces.createdAt , Workspaces .`updatedAt` AS Workspaces.updatedAt , Workspaces .`deletedAt` AS Workspaces.deletedAt , Workspaces .`OwnerId` AS Workspaces.OwnerId , Workspaces->WorkspaceMember .`loggedInAt` AS Workspaces.WorkspaceMember.loggedInAt , Workspaces->WorkspaceMember .`createdAt` AS Workspaces.WorkspaceMember.createdAt , Workspaces->WorkspaceMember .`updatedAt` AS Workspaces.WorkspaceMember.updatedAt , Workspaces->WorkspaceMember .`WorkspaceId` AS Workspaces.WorkspaceMember.WorkspaceId , Workspaces->WorkspaceMember .`UserId` AS Workspaces.WorkspaceMember.UserId FROM users AS User LEFT OUTER JOIN ( workspacemembers AS Workspaces->WorkspaceMember INNER JOIN workspaces AS Workspaces ON Workspaces .`id` = Workspaces->WorkspaceMember .`WorkspaceId`) ON User .`id` = Workspaces->WorkspaceMember .`UserId` AND (`Workspaces`.`deletedAt` IS NULL) WHERE (`User`.`deletedAt` IS NULL AND User .`id` = 8); GET /api/users 200 21.758 ms - 1317 C:\Users\kimsh\Desktop\github-scm\sleact\back\socket.js:23 channels.forEach((channel) => { ^ TypeError: Cannot read properties of undefined (reading 'forEach') at Socket. (C:\Users\kimsh\Desktop\github-scm\sleact\back\socket.js:23:16) at Socket.emit (node:events:513:28) at C:\Users\kimsh\Desktop\github-scm\sleact\back\node_modules\socket.io\lib\socket.js:531:14 at process.processTicksAndRejections (node:internal/process/task_queues:77:11) Node.js v18.12.0 [nodemon] app crashed - waiting for file changes before starting... 이렇게 나옵니다..

Lượt thích
0
Số bình luận
2
Lượt xem
568

Hỏi & Đáp

db 생성과 seed data 에러 없이 넣었습니다.

mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sakila | | sleact | | sys | | world | +--------------------+ 7 rows in set (0.00 sec) config.js 에서 host를 모두 localhost로 바꿨떠니 이제야 만들어지네요 127.0.0.1 이랑 localhost랑 같은것인줄 알았는데 이게 문제였나보네요.. seed 데이터도 채널과 워크스페이스에 들어와 있습니다. 번거롭게 해드려서 죄송합니다.

Lượt thích
0
Số bình luận
4
Lượt xem
691

Hỏi & Đáp

db 생성과 seed data 에러 없이 넣었습니다.

혹시 제가 clone을 하지 않고 전체 파일만 다운받아서 저장소를 새로 판 후에 거기에 옳겨넣어서 작업하고 있는데 이게 문제 일까요?

Lượt thích
0
Số bình luận
4
Lượt xem
691

Hỏi & Đáp

db 생성과 seed data 에러 없이 넣었습니다.

이렇게 뜹니다. 그리고 npm run dev -> db 연결 성공 뜹니다. 그 다음에 seed 를 넣어봤는데 여러번 한 작업이라서 validation error 가 뜹니다. 이미지를 첨부하려했는데 이미지 업로드에 실패했다고 계속 떠서 이렇게 첨부합니다.. 참고로 config.js는 건들지 않았습니다. 감사합니다.

Lượt thích
0
Số bình luận
4
Lượt xem
691