dataSource
469
작성한 질문수 6
AND
`TABLE_NAME` = 'channels'
UNION
SELECT
*
FROM `INFORMATION_SCHEMA`.`REFERENTIAL_CONSTRAINTS`
WHERE
`CONSTRAINT_SCHEMA` = 'sleact'
AND
`TABLE_NAME` = 'channelchats'
UNION
SELECT
*
FROM `INFORMATION_SCHEMA`.`REFERENTIAL_CONSTRAINTS`
WHERE
`CONSTRAINT_SCHEMA` = 'sleact'
AND
`TABLE_NAME` = 'users'
) `rc`
ON
`rc`.`CONSTRAINT_SCHEMA` = `kcu`.`CONSTRAINT_SCHEMA`
AND
`rc`.`TABLE_NAME` = `kcu`.`TABLE_NAME`
AND
`rc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME`
query: SELECT VERSION() AS `version`
query: SELECT * FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = 'sleact' AND `TABLE_NAME` = 'typeorm_metadata'
query: DROP INDEX `UserId` ON `workspacemembers`
query failed: DROP INDEX `UserId` ON `workspacemembers`
error: Error: Cannot drop index 'UserId': needed in a foreign key constraint
query: ROLLBACK
[Nest] 81848 - 2023. 09. 20. 오전 12:47:04 ERROR [TypeOrmModule] Unable to connect to the database. Retrying (9)...
QueryFailedError: Cannot drop index 'UserId': needed in a foreign key constraint
at Query.onResult (/Users/yujinseung/Desktop/Slack/slack_s/src/driver/mysql/MysqlQueryRunner.ts:222:33)
at Query.execute (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/commands/command.js:36:14)
at PoolConnection.handlePacket (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/connection.js:478:34)
at PacketParser.onPacket (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Socket.Readable.push (node:internal/streams/readable:234:10)
[Nest] 81848 - 2023. 09. 20. 오전 12:47:04 ERROR [ExceptionHandler] Cannot drop index 'UserId': needed in a foreign key constraint
QueryFailedError: Cannot drop index 'UserId': needed in a foreign key constraint
at Query.onResult (/Users/yujinseung/Desktop/Slack/slack_s/src/driver/mysql/MysqlQueryRunner.ts:222:33)
at Query.execute (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/commands/command.js:36:14)
at PoolConnection.handlePacket (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/connection.js:478:34)
at PacketParser.onPacket (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Socket.Readable.push (node:internal/streams/readable:234:10)이런오류가 뜹니다..! 뭐가 문제인지 모르겠습니당..
https://github.com/jinseung0327/slack_clone
혹시나 해서 깃허브 주소까지 올립니닷..!
답변 2
0
TypeOrmModule 세팅 하셨나요?
0
회원가입창에서 다입력하고 회원가입버튼을 눌러도 아무일이 안일어나고
혹시나 회원가입이 된건가해서 로그인창에 그대로 다 입력해도 아무일이 안 일어납니다..!
0
일단 깃헙만 올리시는 건 저는 아예 안 봅니다(질문 공지사항 참조하세요). 아무 일이 안 일어나면 왜 안 일어나는지 콘솔로그도 찍어보시고, 네트워크 탭에서 요청/응답 제대로 주고받고 있는지 확인도 해보시고 그 결과를 저한테 보여주세요.
0
사진말고 복사 붙여넣기 해서 올리시면 안되나요? 확대도 안돼서 확인하기가 힘듭니다.
0
아 넵..!!
[Nest] 44738 - 2023. 09. 19. 오후 11:38:53 ERROR [ExceptionHandler] Nest can't resolve dependencies of the UsersRepository (?). Please make sure that the argument DataSource at index [0] is available in the TypeOrmModule context.
Potential solutions:
- Is TypeOrmModule a valid NestJS module?
- If DataSource is a provider, is it part of the current TypeOrmModule?
- If DataSource is exported from a separate @Module, is that module imported within TypeOrmModule?
@Module({
imports: [ /* the Module containing DataSource */ ]
})
Error: Nest can't resolve dependencies of the UsersRepository (?). Please make sure that the argument DataSource at index [0] is available in the TypeOrmModule context.
Potential solutions:
- Is TypeOrmModule a valid NestJS module?
- If DataSource is a provider, is it part of the current TypeOrmModule?
- If DataSource is exported from a separate @Module, is that module imported within TypeOrmModule?
@Module({
imports: [ /* the Module containing DataSource */ ]
})
at Injector.lookupComponentInParentModules (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/injector.js:254:19)
at Injector.resolveComponentInstance (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/injector.js:207:33)
at resolveParam (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/injector.js:128:38)
at async Promise.all (index 0)
at Injector.resolveConstructorParams (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/injector.js:143:27)
at Injector.loadInstance (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/injector.js:70:13)
at Injector.loadProvider (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/injector.js:97:9)
at /Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/instance-loader.js:56:13
at async Promise.all (index 3)
at InstanceLoader.createInstancesOfProviders (/Users/yujinseung/Desktop/Slack/slack_s/node_modules/@nestjs/core/injector/instance-loader.js:55:9)
강의자료는 어디서 다운받나요?
0
110
3
질문 있습니다.
0
294
3
(강의 5:42 질문) providers를 통한 여러 개의 인스턴스 생성 & exports 통한 싱글톤 생성
0
154
2
코드 편집기 확장 프로그램
0
209
2
(질문)비밀 저장소에 접근하기 위한 인증 정보는 로컬 .env에 저장하는지?
0
143
2
(질문)외부 저장소를 통한 환경변수 불러오기 비동기 질문
0
166
3
로그인을 해도 LoggedInGuard쪽에서 false값이 나옵니다.
0
152
2
로그인방법이 고민됩니다.
0
190
2
yarn seed 명령어 실행 시 데이터 삽입 안됨
0
296
4
yarn run db:create 시에 발생하는 데코레이터 오류
0
242
2
npm run db:create 시에 발생하는 decorating 오류
0
231
2
RxJS 디버깅 질문 있습니다.
0
187
3
CacheManager에 대해 질문 있습니다.
0
173
2
로깅은 어떻게 하는게 효율적일까요?
0
224
1
CORS 질문 있습니다.
0
417
2
쿠키 옵션에 대해서 질문 있습니다.
0
184
2
로그아웃 요청이 403 forbidden 에러가 나는데 왜그런걸까요??
0
447
1
401 unauthorized문제
0
286
1
가드의 장점에 대해서 질문이 있습니다.
0
225
1
로그 관리에 대해 질문 있습니다.
0
252
2
CORS 에러 질문 있습니다.
0
318
2
배포 환경 DB 연결 질문 있습니다.
0
411
2
socket io 미 연결 문제 (nest & flutter)
1
1154
3
no elements in sequence 에러 관해서 질문이 있습니다.
0
454
1





