소개
게시글
질문&답변
오류가 나서 질문을 드립니다.
음 일단 auth.js 에서 생기는 오류는 해결하였습니다. 하지만 error.pug에서 생기는 오류와 DB오류가 생기는거 같은대.. 이것들은 어떻게 해야될까요? DatabaseError [SequelizeDatabaseError]: Incorrect string value: '\xEC\x9D\xB4\xEC\x9B\x90...' for column 'nick' at row 1 at Query.formatError (C:\Users\DELL\Desktop\nodebird\node_modules\sequelize\lib\dialects\mysql\query.js:244:16) at Execute.handler [as onResult] (C:\Users\DELL\Desktop\nodebird\node_modules\sequelize\lib\dialects\mysql\query.js:51:23) at Execute.execute (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\commands\command.js:30:14) at Connection.handlePacket (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:417:32) at PacketParser.onPacket (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:75:12) at PacketParser.executeStart (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\packet_parser.js:75:16) at Socket. (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:82:25) at Socket.emit (events.js:223:5) at addChunk (_stream_readable.js:309:12) at readableAddChunk (_stream_readable.js:290:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead (internal/stream_base_commons.js:181:23) { name: 'SequelizeDatabaseError', parent: Error: Incorrect string value: '\xEC\x9D\xB4\xEC\x9B\x90...' for column 'nick' at row 1 at Packet.asError (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\packets\packet.js:712:17) at Execute.execute (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\commands\command.js:28:26) at Connection.handlePacket (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:417:32) at PacketParser.onPacket (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:75:12) at PacketParser.executeStart (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\packet_parser.js:75:16) at Socket. (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:82:25) at Socket.emit (events.js:223:5) at addChunk (_stream_readable.js:309:12) at readableAddChunk (_stream_readable.js:290:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead (internal/stream_base_commons.js:181:23) { code: 'ER_TRUNCATED_WRONG_VALUE_FOR_FIELD', errno: 1366, sqlState: 'HY000', sqlMessage: "Incorrect string value: '\\xEC\\x9D\\xB4\\xEC\\x9B\\x90...' for column 'nick' at row 1", sql: 'INSERT INTO `users` (`id`,`email`,`nick`,`password`,`provider`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?);', parameters: [ 'kitti0418@naver.com', '이원제', '$2b$12$fas7/Kr7tMyQkL95o2CBPuuJklvekQOqGuRuXPdo9jRgsk60TLwLu', 'local', '2020-06-08 22:16:38', '2020-06-08 22:16:38' ] }, original: Error: Incorrect string value: '\xEC\x9D\xB4\xEC\x9B\x90...' for column 'nick' at row 1 at Packet.asError (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\packets\packet.js:712:17) at Execute.execute (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\commands\command.js:28:26) at Connection.handlePacket (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:417:32) at PacketParser.onPacket (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:75:12) at PacketParser.executeStart (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\packet_parser.js:75:16) at Socket. (C:\Users\DELL\Desktop\nodebird\node_modules\mysql2\lib\connection.js:82:25) at Socket.emit (events.js:223:5) at addChunk (_stream_readable.js:309:12) at readableAddChunk (_stream_readable.js:290:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead (internal/stream_base_commons.js:181:23) { code: 'ER_TRUNCATED_WRONG_VALUE_FOR_FIELD', errno: 1366, sqlState: 'HY000', sqlMessage: "Incorrect string value: '\\xEC\\x9D\\xB4\\xEC\\x9B\\x90...' for column 'nick' at row 1", sql: 'INSERT INTO `users` (`id`,`email`,`nick`,`password`,`provider`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?);', parameters: [ 'kitti0418@naver.com', '이원제', '$2b$12$fas7/Kr7tMyQkL95o2CBPuuJklvekQOqGuRuXPdo9jRgsk60TLwLu', 'local', '2020-06-08 22:16:38', '2020-06-08 22:16:38' ] }, sql: 'INSERT INTO `users` (`id`,`email`,`nick`,`password`,`provider`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?,?,?,?);', parameters: [ 'kitti0418@naver.com', '이원제', '$2b$12$fas7/Kr7tMyQkL95o2CBPuuJklvekQOqGuRuXPdo9jRgsk60TLwLu', 'local', '2020-06-08 22:16:38', '2020-06-08 22:16:38' ] } Error: C:\Users\DELL\Desktop\nodebird\views\error.pug:2:1 Declaration of template inheritance ("extends") should be the first thing in the file. There can only be one extends statement per file. at makeError (C:\Users\DELL\Desktop\nodebird\node_modules\pug-error\index.js:34:13) at error (C:\Users\DELL\Desktop\nodebird\node_modules\pug-linker\index.js:7:30) at C:\Users\DELL\Desktop\nodebird\node_modules\pug-linker\index.js:198:9 at walkAST (C:\Users\DELL\Desktop\nodebird\node_modules\pug-walk\index.js:26:18) at C:\Users\DELL\Desktop\nodebird\node_modules\pug-walk\index.js:112:20 at Array.reduce () at walkAndMergeNodes (C:\Users\DELL\Desktop\nodebird\node_modules\pug-walk\index.js:111:18) at walkAST (C:\Users\DELL\Desktop\nodebird\node_modules\pug-walk\index.js:40:19) at checkExtendPosition (C:\Users\DELL\Desktop\nodebird\node_modules\pug-linker\index.js:193:3) at link (C:\Users\DELL\Desktop\nodebird\node_modules\pug-linker\index.js:19:5) at compileBody (C:\Users\DELL\Desktop\nodebird\node_modules\pug\lib\index.js:192:9) at Object.exports.compile (C:\Users\DELL\Desktop\nodebird\node_modules\pug\lib\index.js:267:16) at handleTemplateCache (C:\Users\DELL\Desktop\nodebird\node_modules\pug\lib\index.js:240:25) at Object.exports.renderFile (C:\Users\DELL\Desktop\nodebird\node_modules\pug\lib\index.js:452:10) at Object.exports.renderFile (C:\Users\DELL\Desktop\nodebird\node_modules\pug\lib\index.js:442:21) at View.exports.__express [as engine] (C:\Users\DELL\Desktop\nodebird\node_modules\pug\lib\index.js:491:11) at View.render (C:\Users\DELL\Desktop\nodebird\node_modules\express\lib\view.js:135:8) at tryRender (C:\Users\DELL\Desktop\nodebird\node_modules\express\lib\application.js:640:10) at Function.render (C:\Users\DELL\Desktop\nodebird\node_modules\express\lib\application.js:592:3) at ServerResponse.render (C:\Users\DELL\Desktop\nodebird\node_modules\express\lib\response.js:1012:7) at C:\Users\DELL\Desktop\nodebird\app.js:55:7 at Layer.handle_error (C:\Users\DELL\Desktop\nodebird\node_modules\express\lib\router\layer.js:71:5) POST /auth/join 500 329.197 ms - 2591
- 0
- 4
- 364
질문&답변
오류가 나서 질문을 드립니다.
오류코드 잘 안보이신거 같으니 파일 다시 올려드릴게요(사진)
- 0
- 4
- 364
질문&답변
오류가 나서 질문 드립니다.
감사합니다.
- 0
- 2
- 1.2K