kimsh59931433

Executing (default): SELECT <code>id</code>, <code>email</code>, <code>nickname</code>, <code>password</code>, <code>createdAt</code>, <code>updatedAt</code>, <code>deletedAt</code> FROM <code>users</code> AS <code>User</code> WHERE (`User`.`deletedAt` IS NULL AND <code>User</code>.`email` = '<a target="_blank" rel="noopener noreferrer nofollow" href="mailto:lee123@naver.com">lee123@naver.com</a>');Executing (default): SELECT <code>id</code>, <code>nickname</code>, <code>email</code> FROM <code>users</code> AS <code>User</code> WHERE (`User`.`deletedAt` IS NULL AND <code>User</code>.`id` = 8);POST /api/users/login 200 255.278 ms - 55Executing (default): SELECT <code>User</code>.`id`, <code>User</code>.`nickname`, <code>User</code>.`email`, <code>Workspaces</code>.`id` AS <code>Workspaces.id</code>, <code>Workspaces</code>.`name` AS <code>Workspaces.name</code>, <code>Workspaces</code>.`url` AS <code>Workspaces.url</code>, <code>Workspaces</code>.`createdAt` AS <code>Workspaces.createdAt</code>, <code>Workspaces</code>.`updatedAt` AS <code>Workspaces.updatedAt</code>, <code>Workspaces</code>.`deletedAt` AS <code>Workspaces.deletedAt</code>, <code>Workspaces</code>.`OwnerId` AS <code>Workspaces.OwnerId</code>, <code>Workspaces->WorkspaceMember</code>.`loggedInAt` AS <code>Workspaces.WorkspaceMember.loggedInAt</code>, <code>Workspaces->WorkspaceMember</code>.`createdAt` AS <code>Workspaces.WorkspaceMember.createdAt</code>, <code>Workspaces->WorkspaceMember</code>.`updatedAt` AS <code>Workspaces.WorkspaceMember.updatedAt</code>, <code>Workspaces->WorkspaceMember</code>.`WorkspaceId` AS <code>Workspaces.WorkspaceMember.WorkspaceId</code>, <code>Workspaces->WorkspaceMember</code>.`UserId` AS <code>Workspaces.WorkspaceMember.UserId</code> FROM <code>users</code> AS <code>User</code> LEFT OUTER JOIN ( <code>workspacemembers</code> AS <code>Workspaces->WorkspaceMember</code> INNER JOIN <code>workspaces</code> AS <code>Workspaces</code> ON <code>Workspaces</code>.`id` = <code>Workspaces->WorkspaceMember</code>.`WorkspaceId`) ON <code>User</code>.`id` = <code>Workspaces->WorkspaceMember</code>.`UserId` AND (`Workspaces`.`deletedAt` IS NULL) WHERE (`User`.`deletedAt` IS NULL AND <code>User</code>.`id` = 8);Executing (default): SELECT <code>User</code>.`id`, <code>User</code>.`nickname`, <code>User</code>.`email`, <code>Workspaces</code>.`id` AS <code>Workspaces.id</code>, <code>Workspaces</code>.`name` AS <code>Workspaces.name</code>, <code>Workspaces</code>.`url` AS <code>Workspaces.url</code>, <code>Workspaces</code>.`createdAt` AS <code>Workspaces.createdAt</code>, <code>Workspaces</code>.`updatedAt` AS <code>Workspaces.updatedAt</code>, <code>Workspaces</code>.`deletedAt` AS <code>Workspaces.deletedAt</code>, <code>Workspaces</code>.`OwnerId` AS <code>Workspaces.OwnerId</code>, <code>Workspaces->WorkspaceMember</code>.`loggedInAt` AS <code>Workspaces.WorkspaceMember.loggedInAt</code>, <code>Workspaces->WorkspaceMember</code>.`createdAt` AS <code>Workspaces.WorkspaceMember.createdAt</code>, <code>Workspaces->WorkspaceMember</code>.`updatedAt` AS <code>Workspaces.WorkspaceMember.updatedAt</code>, <code>Workspaces->WorkspaceMember</code>.`WorkspaceId` AS <code>Workspaces.WorkspaceMember.WorkspaceId</code>, <code>Workspaces->WorkspaceMember</code>.`UserId` AS <code>Workspaces.WorkspaceMember.UserId</code> FROM <code>users</code> AS <code>User</code> LEFT OUTER JOIN ( <code>workspacemembers</code> AS <code>Workspaces->WorkspaceMember</code> INNER JOIN <code>workspaces</code> AS <code>Workspaces</code> ON <code>Workspaces</code>.`id` = <code>Workspaces->WorkspaceMember</code>.`WorkspaceId`) ON <code>User</code>.`id` = <code>Workspaces->WorkspaceMember</code>.`UserId` AND (`Workspaces`.`deletedAt` IS NULL) WHERE (`User`.`deletedAt` IS NULL AND <code>User</code>.`id` = 8);Executing (default): SELECT <code>id</code>, <code>name</code>, <code>url</code>, <code>createdAt</code>, <code>updatedAt</code>, <code>deletedAt</code>, <code>OwnerId</code> FROM <code>workspaces</code> AS <code>Workspace</code> WHERE (`Workspace`.`deletedAt` IS NULL AND <code>Workspace</code>.`url` = 'sleact');Executing (default): SELECT <code>id</code>, <code>name</code>, <code>url</code>, <code>createdAt</code>, <code>updatedAt</code>, <code>deletedAt</code>, <code>OwnerId</code> FROM <code>workspaces</code> AS <code>Workspace</code> WHERE (`Workspace`.`deletedAt` IS NULL AND <code>Workspace</code>.`url` = 'sleact'); Executing (default): SELECT <code>Channel</code>.`id`, <code>Channel</code>.`name`, <code>Channel</code>.`private`, <code>Channel</code>.`createdAt`, <code>Channel</code>.`updatedAt`, <code>Channel</code>.`WorkspaceId`, <code>Members</code>.`id` AS <code>Members.id</code>, <code>Members->ChannelMembers</code>.`ChannelId` AS <code>Members.ChannelMembers.ChannelId</code>, <code>Members->ChannelMembers</code>.`UserId` AS <code>Members.ChannelMembers.UserId</code> FROM <code>channels</code> AS <code>Channel</code> INNER JOIN ( <code>ChannelMembers</code> AS <code>Members->ChannelMembers</code> INNER JOIN <code>users</code> AS <code>Members</code> ON <code>Members</code>.`id` = <code>Members->ChannelMembers</code>.`UserId` AND <code>Members->ChannelMembers</code>.`UserId` = 8) ON <code>Channel</code>.`id` = <code>Members->ChannelMembers</code>.`ChannelId` AND (`Members`.`deletedAt` IS NULL) WHERE <code>Channel</code>.`WorkspaceId` = 1;Executing (default): SELECT <code>User</code>.`id`, <code>User</code>.`nickname`, <code>User</code>.`email`, <code>WorkspaceMember</code>.`loggedInAt` AS <code>WorkspaceMember.loggedInAt</code>, <code>WorkspaceMember</code>.`createdAt` AS <code>WorkspaceMember.createdAt</code>, <code>WorkspaceMember</code>.`updatedAt` AS <code>WorkspaceMember.updatedAt</code>, <code>WorkspaceMember</code>.`WorkspaceId` AS <code>WorkspaceMember.WorkspaceId</code>, <code>WorkspaceMember</code>.`UserId` AS <code>WorkspaceMember.UserId</code> FROM <code>users</code> AS <code>User</code> INNER JOIN <code>workspacemembers</code> AS <code>WorkspaceMember</code> ON <code>User</code>.`id` = <code>WorkspaceMember</code>.`UserId` AND <code>WorkspaceMember</code>.`WorkspaceId` = 1 WHERE (`User`.`deletedAt` IS NULL);GET /api/workspaces/sleact/channels 200 46.302 ms - 2114GET /api/workspaces/sleact/members 200 49.981 ms - 666Executing (default): SELECT <code>User</code>.`id`, <code>User</code>.`nickname`, <code>User</code>.`email`, <code>Workspaces</code>.`id` AS <code>Workspaces.id</code>, <code>Workspaces</code>.`name` AS <code>Workspaces.name</code>, <code>Workspaces</code>.`url` AS <code>Workspaces.url</code>, <code>Workspaces</code>.`createdAt` AS <code>Workspaces.createdAt</code>, <code>Workspaces</code>.`updatedAt` AS <code>Workspaces.updatedAt</code>, <code>Workspaces</code>.`deletedAt` AS <code>Workspaces.deletedAt</code>, <code>Workspaces</code>.`OwnerId` AS <code>Workspaces.OwnerId</code>, <code>Workspaces->WorkspaceMember</code>.`loggedInAt` AS <code>Workspaces.WorkspaceMember.loggedInAt</code>, <code>Workspaces->WorkspaceMember</code>.`createdAt` AS <code>Workspaces.WorkspaceMember.createdAt</code>, <code>Workspaces->WorkspaceMember</code>.`updatedAt` AS <code>Workspaces.WorkspaceMember.updatedAt</code>, <code>Workspaces->WorkspaceMember</code>.`WorkspaceId` AS <code>Workspaces.WorkspaceMember.WorkspaceId</code>, <code>Workspaces->WorkspaceMember</code>.`UserId` AS <code>Workspaces.WorkspaceMember.UserId</code> FROM <code>users</code> AS <code>User</code> LEFT OUTER JOIN ( <code>workspacemembers</code> AS <code>Workspaces->WorkspaceMember</code> INNER JOIN <code>workspaces</code> AS <code>Workspaces</code> ON <code>Workspaces</code>.`id` = <code>Workspaces->WorkspaceMember</code>.`WorkspaceId`) ON <code>User</code>.`id` = <code>Workspaces->WorkspaceMember</code>.`UserId` AND (`Workspaces`.`deletedAt` IS NULL) WHERE (`User`.`deletedAt` IS NULL AND <code>User</code>.`id` = 8);GET /api/users 200 21.758 ms - 1317C:\Users\kimsh\Desktop\github-scm\sleact\back\socket.js:23 channels.forEach((channel) => { ^TypeError: Cannot read properties of undefined (reading 'forEach') at Socket.<anonymous> (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...이렇게 나옵니다..

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

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

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

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

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

kimsh59931433

Posts