23.07 오류 수집

김지혜·2023년 7월 8일
VSnode.js미완성

sequelize db

실행이 안 될 시

# config/config.json에 설정된 DB를 생성합니다. 
npx sequelize db:create
# 해당 프로젝트에 Migrations에 정의된 Posts 테이블을 MySQL에 생성합니다.
npx sequelize db:migrate

해당 명령어 실행

npm install -g sequelize-cli

(나중에 다듬기)

DB mysql 오류문

오류문

node:internal/process/promises:288
            triggerUncaughtException(err, true /* fromPromise */);
            ^

Error
    at Query.run (C:\Users\user\Desktop\Node.js_4-2\node_modules\sequelize\lib\dialects\mysql\query.js:52:25)
    at C:\Users\user\Desktop\Node.js_4-2\node_modules\sequelize\lib\sequelize.js:315:28
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async MySQLQueryInterface.createTable (C:\Users\user\Desktop\Node.js_4-2\node_modules\sequelize\lib\dialects\abstract\query-interface.js:98:12)
    at async Likes.sync (C:\Users\user\Desktop\Node.js_4-2\node_modules\sequelize\lib\model.js:942:7)
    at async Sequelize.sync (C:\Users\user\Desktop\Node.js_4-2\node_modules\sequelize\lib\sequelize.js:377:9)
    at async main (C:\Users\user\Desktop\Node.js_4-2\app.js:14:3) {
  name: 'SequelizeDatabaseError',
  parent: Error: Duplicate column name 'postId'
      at Packet.asError (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\packets\packet.js:728:17)
      at Query.execute (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\connection.js:497:34)
      at PacketParser.onPacket (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\connection.js:97:12)
      at PacketParser.executeStart (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (C:\Users\user\Desktop\Node.js_4-2\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 Readable.push (node:internal/streams/readable:234:10) {
    code: 'ER_DUP_FIELDNAME',
    errno: 1060,
    sqlState: '42S21',
    sqlMessage: "Duplicate column name 'postId'",
    sql: 'CREATE TABLE IF NOT EXISTS `Likes` (`id` INTEGER NOT NULL auto_increment , `UserId` INTEGER NOT NULL, `PostId` INTEGER NOT 
NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `postId` INTEGER, PRIMARY KEY (`id`), FOREIGN KEY (`UserId`) REFERENCES `Users` (`userId`) ON DELETE NO ACTION ON UPDATE CASCADE, FOREIGN KEY (`PostId`) REFERENCES `Posts` (`postId`) ON DELETE NO ACTION ON UPDATE CASCADE, FOREIGN KEY (`postId`) REFERENCES `Posts` (`postId`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;',  
    parameters: undefined
  },
  original: Error: Duplicate column name 'postId'
      at Packet.asError (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\packets\packet.js:728:17)
      at Query.execute (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\connection.js:497:34)
      at PacketParser.onPacket (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\connection.js:97:12)
      at PacketParser.executeStart (C:\Users\user\Desktop\Node.js_4-2\node_modules\mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (C:\Users\user\Desktop\Node.js_4-2\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 Readable.push (node:internal/streams/readable:234:10) {
    code: 'ER_DUP_FIELDNAME',
    errno: 1060,
    sqlState: '42S21',
TEGER, PRIMARY KEY (`id`), FOREIGN KEY (`UserId`) REFERENCES `Users` (`userId`) ON DELETE NO ACTION ON UPDATE CASCADE, FOREIGN KEY (`PostId`) REFERENCES `Posts` (`postId`) ON DELETE NO ACTION ON UPDATE CASCADE, FNULL, `PostId` INTEGER NOT OREIGN KEY (`postId`) REFERENCES `Posts` (`postId`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;',FOREIGN KEY (`UserId`) REFE
                                                                                                           (`postId`) ON DELETE NO AC
    parameters: undefined                                                                                 CASCADE) ENGINE=InnoDB;',  
  },
  sql: 'CREATE TABLE IF NOT EXISTS `Likes` (`id` INTEGER NOT NULL auto_increment , `UserId` INTEGER NOT NULL, `PostId` INTEGER NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `postId` INTELL, `PostId` INTEGER NOT NUGER, PRIMARY KEY (`id`), FOREIGN KEY (`UserId`) REFERENCES `Users` (`userId`) ON DELETE NO ACTION ON UPDATREIGN KEY (`UserId`) REFEREE CASCADE, FOREIGN KEY (`PostId`) REFERENCES `Posts` (`postId`) ON DELETE NO ACTION ON UPDATE CASCADE, FOR`postId`) ON DELETE NO ACTIEIGN KEY (`postId`) REFERENCES `Posts` (`postId`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;',  SCADE) ENGINE=InnoDB;',    
  parameters: {}
}

Node.js v18.16.0
[nodemon] app crashed - waiting for file changes before starting...

DB 오류 발생 시 quary에서 

CREATE TABLE IF NOT EXISTS `Likes` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `UserId` INTEGER NOT NULL,
  `PostId` INTEGER,
  `createdAt` DATETIME NOT NULL,
  `updatedAt` DATETIME NOT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`UserId`) REFERENCES `Users` (`userId`) ON DELETE NO ACTION ON UPDATE CASCADE,
  FOREIGN KEY (`PostId`) REFERENCES `Posts` (`postId`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `fk_Likes_Posts` FOREIGN KEY (`postId`) REFERENCES `Posts` (`postId`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `Likes` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `UserId` INTEGER NOT NULL,
  `PostId` INTEGER NOT NULL,
  `createdAt` DATETIME NOT NULL,
  `updatedAt` DATETIME NOT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`UserId`) REFERENCES `Users` (`userId`) ON DELETE NO ACTION ON UPDATE CASCADE,
  FOREIGN KEY (`PostId`) REFERENCES `Posts` (`postId`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `fk_Likes_Posts` FOREIGN KEY (`postId`) REFERENCES `Posts` (`postId`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

Sequelize model Sync 오류

user@DESKTOP-V43IOCL MINGW64 ~/Desktop/1 (master)
$ node app.js
3018 포트 번호로 서버가 실행되었습니다.
C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:92
          throw new SequelizeErrors.ConnectionRefusedError(err);  
                ^

ConnectionRefusedError [SequelizeConnectionRefusedError]: connect 
ECONNREFUSED 127.0.0.1:3306
    at ConnectionManager.connect (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:92:17)    
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ConnectionManager._connect (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
    at async C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
    at async ConnectionManager.getConnection (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
    at async C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:305:26
    at async MySQLQueryInterface.dropTable (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\query-interface.js:111:5)
    at async UserInfos.drop (C:\Users\user\Desktop\1\node_modules\sequelize\lib\model.js:1007:12)
    at async Sequelize.drop (C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:429:9)
    at async Sequelize.sync (C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:366:7) {
  parent: Error: connect ECONNREFUSED 127.0.0.1:3306
      at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
    errno: -4078,
    code: 'ECONNREFUSED',
    syscall: 'connect',
    address: '127.0.0.1',
    port: 3306,
    fatal: true
  },
  original: Error: connect ECONNREFUSED 127.0.0.1:3306
      at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
    errno: -4078,
    code: 'ECONNREFUSED',
    syscall: 'connect',
    address: '127.0.0.1',
    port: 3306,
    fatal: true
  }
}

Node.js v18.16.0
user@DESKTOP-V43IOCL MINGW64 ~/Desktop/1 (master)
$ node app.js
3018 포트 번호로 서버가 실행되었습니다.
C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:94
          throw new SequelizeErrors.AccessDeniedError(err);       
                ^

AccessDeniedError [SequelizeAccessDeniedError]: Access denied for 
user 'root'@'119.202.72.208' (using password: NO)
    at ConnectionManager.connect (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:94:17)    
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ConnectionManager._connect (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
    at async C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
    at async ConnectionManager.getConnection (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
    at async C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:305:26
    at async MySQLQueryInterface.dropTable (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\query-interface.js:111:5)
    at async UserInfos.drop (C:\Users\user\Desktop\1\node_modules\sequelize\lib\model.js:1007:12)
    at async Sequelize.drop (C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:429:9)
    at async Sequelize.sync (C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:366:7) {
  parent: Error: Access denied for user 'root'@'119.202.72.208' (using password: NO)
      at Packet.asError (C:\Users\user\Desktop\1\node_modules\mysql2\lib\packets\packet.js:728:17)
      at ClientHandshake.execute (C:\Users\user\Desktop\1\node_modules\mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:497:34)
      at PacketParser.onPacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:97:12)
      at PacketParser.executeStart (C:\Users\user\Desktop\1\node_modules\mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (C:\Users\user\Desktop\1\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 Readable.push (node:internal/streams/readable:234:10) {  
    code: 'ER_ACCESS_DENIED_ERROR',
    errno: 1045,
    sqlState: '28000',
    sqlMessage: "Access denied for user 'root'@'119.202.72.208' (using password: NO)",
    sql: undefined
  },
  original: Error: Access denied for user 'root'@'119.202.72.208' 
(using password: NO)
      at Packet.asError (C:\Users\user\Desktop\1\node_modules\mysql2\lib\packets\packet.js:728:17)
      at ClientHandshake.execute (C:\Users\user\Desktop\1\node_modules\mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:497:34)
      at PacketParser.onPacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:97:12)
      at PacketParser.executeStart (C:\Users\user\Desktop\1\node_modules\mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (C:\Users\user\Desktop\1\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 Readable.push (node:internal/streams/readable:234:10) {  
    code: 'ER_ACCESS_DENIED_ERROR',
    errno: 1045,
    sqlState: '28000',
    sqlMessage: "Access denied for user 'root'@'119.202.72.208' (using password: NO)",
    sql: undefined
  }
}

Node.js v18.16.0
user@DESKTOP-V43IOCL MINGW64 ~/Desktop/1 (master)
$ node app.js
3018 포트 번호로 서버가 실행되었습니다.
C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:102
          throw new SequelizeErrors.ConnectionError(err);
                ^

ConnectionError [SequelizeConnectionError]: Unknown database 'database_development'
    at ConnectionManager.connect (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:102:17)   
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ConnectionManager._connect (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
    at async C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
    at async ConnectionManager.getConnection (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
    at async C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:305:26
    at async MySQLQueryInterface.dropTable (C:\Users\user\Desktop\1\node_modules\sequelize\lib\dialects\abstract\query-interface.js:111:5)
    at async UserInfos.drop (C:\Users\user\Desktop\1\node_modules\sequelize\lib\model.js:1007:12)
    at async Sequelize.drop (C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:429:9)
    at async Sequelize.sync (C:\Users\user\Desktop\1\node_modules\sequelize\lib\sequelize.js:366:7) {
  parent: Error: Unknown database 'database_development'
      at Packet.asError (C:\Users\user\Desktop\1\node_modules\mysql2\lib\packets\packet.js:728:17)
      at ClientHandshake.execute (C:\Users\user\Desktop\1\node_modules\mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:497:34)
      at PacketParser.onPacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:97:12)
      at PacketParser.executeStart (C:\Users\user\Desktop\1\node_modules\mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (C:\Users\user\Desktop\1\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 Readable.push (node:internal/streams/readable:234:10) {  
    code: 'ER_BAD_DB_ERROR',
    errno: 1049,
    sqlState: '42000',
    sqlMessage: "Unknown database 'database_development'",        
    sql: undefined
  },
  original: Error: Unknown database 'database_development'        
      at Packet.asError (C:\Users\user\Desktop\1\node_modules\mys q
l2\lib\packets\packet.js:728:17)
      at ClientHandshake.execute (C:\Users\user\Desktop\1\node_modules\mysql2\lib\commands\command.js:29:26)
      at Connection.handlePacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:497:34)
      at PacketParser.onPacket (C:\Users\user\Desktop\1\node_modules\mysql2\lib\connection.js:97:12)
      at PacketParser.executeStart (C:\Users\user\Desktop\1\node_modules\mysql2\lib\packet_parser.js:75:16)
      at Socket.<anonymous> (C:\Users\user\Desktop\1\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 Readable.push (node:internal/streams/readable:234:10) {  
    code: 'ER_BAD_DB_ERROR',
    errno: 1049,
    sqlState: '42000',
    sqlMessage: "Unknown database 'database_development'",        
    sql: undefined
  }
}

Node.js v18.16.0

=> config.json 파일에 db 설정 확인

npx sequelize init 터미널 오류

$ npx sequelize init
*
Sequelize CLI [Node: 18.16.0, CLI: 6.6.1, ORM: 6.32.1]
*
ERROR: The file config\config.json already exists. Run command with --force to overwrite it.

= config\config.json 파일이 이미 있음 =>
--force로 명령을 실행하여 덮기

app.js 파일 경로 오류

해당 오류문 발생

$ node app.js
node:internal/modules/cjs/loader:1078
  throw err;
  ^
Error: Cannot find module 'C:\Program Files\app.js'
?[90m    at Module._resolveFilename (node:internal/modules/cjs/loader:1075:15)?[39m
?[90m    at Module._load (node:internal/modules/cjs/loader:920:27)?[39m
?[90m    at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12)?[39m
?[90m    at node:internal/main/run_main_module:23:47?[39m {     
  code: ?[32m'MODULE_NOT_FOUND'?[39m,
  requireStack: []
}
Node.js v18.16.0

=명령이 파일 경로를 올바르게 인식하지 못함

해당 명령어로 파일 경로 지정

cd "C:\Users\user\Desktop\1"
profile
김지혜
이전 포스트

git SSH 키 문제

다음 포스트

git push_repository 오류

0개의 댓글