Q&A
소켓 이벤트 연결하기를 시청하다가 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... 이렇게 나옵니다..
- Likes
- 0
- Comments
- 2
- Viewcount
- 550