Skip to content

book_info_search_keywords 관련 오류 #800

@nyj001012

Description

@nyj001012

재현 방법

  • 서비스 DB 로그에 에러가 출력됨
  • 추후 문제를 일으킬 수 있어 처리 필요

발생 위치

searchBookInfo (/app/backend/src/v1/books/books.controller.ts:112:34)

추가 정보

2023-11-08 00:00:10:010 error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jiphyeonjeon.book_info_search_keywords.disassembled_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
 Error Stack: Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'jiphyeonjeon.book_info_search_keywords.disassembled_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
    at PromisePoolConnection.query (/app/node_modules/.pnpm/mysql2@2.3.3/node_modules/mysql2/promise.js:93:22)
    at Module.executeQuery (/app/backend/src/mysql.ts:24:26)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Promise.all (index 1)
    at Module.searchInfo (/app/backend/src/v1/books/books.service.ts:302:48)
    at searchBookInfo (/app/backend/src/v1/books/books.controller.ts:112:34)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type
    No fields configured for issues without a type.

    Projects

    Status

    할 일

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions