[Bug] Article post api route sql syntax error

sleeep23 commented 1 year ago

문제 설명

api/articles 의 주소로 POST 요청을 보내게끔 시도를 해보았습니다. 하지만 제대로 포스트되지 않는 에러를 만났습니다.

제가 만난 에러들은 다음과 같습니다.

[x] zod의 type validation error : 해당 파일 주석에 변경사항 적어놓았습니다.
[x] categories array 부분에서 '{' syntax error을 만났습니다 (categories array는 제 추측일 뿐입니다. 아닐수도 있습니다😅)

zod의 경우 해결되어 이를 제외한, 아래 경우의 에러 전문을 다음과 같이 첨부해두겠습니다.

혹시 제 코드에 문제가 있다면 알려주시면 감사하겠습니다!

array syntax error

error: syntax error at or near "{"
at an.parseErrorMessage (webpack-internal:///(sc_server)/./node_modules/@neondatabase/serverless/index.js:4533:75)
at an.handlePacket (webpack-internal:///(sc_server)/./node_modules/@neondatabase/serverless/index.js:4410:33)
at an.parse (webpack-internal:///(sc_server)/./node_modules/@neondatabase/serverless/index.js:4355:34)
at V.eval (webpack-internal:///(sc_server)/./node_modules/@neondatabase/serverless/index.js:4563:36)
at k.emit (webpack-internal:///(sc_server)/./node_modules/@neondatabase/serverless/index.js:1024:37)
at WebSocket.eval (webpack-internal:///(sc_server)/./node_modules/@neondatabase/serverless/index.js:3961:26)
at callListener (webpack-internal:///(sc_server)/./node_modules/ws/lib/event-target.js:249:18)
at WebSocket.onMessage (webpack-internal:///(sc_server)/./node_modules/ws/lib/event-target.js:178:17)
at WebSocket.emit (node:events:513:28)
at Receiver.receiverOnMessage (webpack-internal:///(sc_server)/./node_modules/ws/lib/websocket.js:924:22)
at Receiver.emit (node:events:513:28)
at Receiver.dataMessage (webpack-internal:///(sc_server)/./node_modules/ws/lib/receiver.js:341:22)
at Receiver.getData (webpack-internal:///(sc_server)/./node_modules/ws/lib/receiver.js:295:21)
at Receiver.startLoop (webpack-internal:///(sc_server)/./node_modules/ws/lib/receiver.js:118:32)
at Receiver._write (webpack-internal:///(sc_server)/./node_modules/ws/lib/receiver.js:65:14)
at writeOrBuffer (node:internal/streams/writable:392:12)
at _write (node:internal/streams/writable:333:10)
at Writable.write (node:internal/streams/writable:337:10)
at TLSSocket.socketOnData (webpack-internal:///(sc_server)/./node_modules/ws/lib/websocket.js:991:37)
at TLSSocket.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)
at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23)
at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
length: 91,
severity: 'ERROR',
code: '42601',
detail: undefined,
hint: undefined,
position: '176',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'scan.l',
line: '1188',
routine: 'scanner_yyerror'
}

그리고 아래는 제가 작성한 post 요청의 부분입니다.

<form
        onSubmit={form.onSubmit(async (values) => {
          try {
            const content = await generateHtmlFromInput(values);
            const res = await axios.post(`/api/articles`, {
              title: values.title,
              thumbnail_url:
                "https://images.unsplash.com/... 생략하겠습니다.",
              categories: ["test1", "test2", "test3"],
              content: content,
            });

            if (res.status === 200) {
              await notifications.show({
                title: "아티클 작성완료!",
                message: "아티클을 작성 완료했습니다!",
              });
            }
          } catch (e) {
            notifications.show({
              title: "아티클 업로드 오류!",
              message:
                "아티클이 제대로 업로드 되지 않았습니다. 다시 한번 시도해주시기 바랍니다",
              color: "red",
            });
          }
        })}
>

2paperstar commented 1 year ago

@sleeep23 https://github.com/Mefeto/Mefeto-v2-fe/tree/feature/issue-20/write-article-ui 브랜치에서 수정했습니다 :)

sleeep23 commented 1 year ago

확인했습니다! 감사합니다!

Mefeto / Mefeto-v2-fe

[Bug] Article post api route sql syntax error #43