ByteBender
DTDrizzle Team
•Created by ByteBender on 1/14/2024 in #help
PostgresError: syntax error at or near "$1"
const stock = await this.db.query.StockM.findMany({
where: (m, { inArray, eq, and }) =>
and(inArray(m.checkCode, checkCode), eq(m.game, game as Game)),
});
const stock = await this.db.query.StockM.findMany({
where: (m, { inArray, eq, and }) =>
and(inArray(m.checkCode, checkCode), eq(m.game, game as Game)),
});
------------- [DATABASE LOG QUERY] ------------
[TIME: 2024-01-14 20:55:05]
Query: select "id", "owner", "game", "code_type", "code", "check_code", "on_use", "on_backup", "is_used", "used_for", "is_bought", "lastUpdate", "price", "created_at" from "stock" "StockM" where ("StockM"."check_code" in $1 and "StockM"."game" = $2) -- params: ["20:T-S-00069405 8977-3373-6717-7449+UNIPIN_VOUCHER", "FREE_FIRE"]
---------------------------------------------------
------------- [DATABASE LOG QUERY] ------------
[TIME: 2024-01-14 20:55:05]
Query: select "id", "owner", "game", "code_type", "code", "check_code", "on_use", "on_backup", "is_used", "used_for", "is_bought", "lastUpdate", "price", "created_at" from "stock" "StockM" where ("StockM"."check_code" in $1 and "StockM"."game" = $2) -- params: ["20:T-S-00069405 8977-3373-6717-7449+UNIPIN_VOUCHER", "FREE_FIRE"]
---------------------------------------------------
[Nest] 1347376 - 01/14/2024, 8:55:05 PM ERROR [ExceptionsHandler] syntax error at or near "$1"
PostgresError: syntax error at or near "$1"
at ErrorResponse (/root/api/topupapi/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/cjs/src/connection.js:790:26)
at handle (/root/api/topupapi/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/cjs/src/connection.js:476:6)
at Socket.data (/root/api/topupapi/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:517:28)
at addChunk (node:internal/streams/readable:368:12)
at readableAddChunk (node:internal/streams/readable:341:9)
at Socket.Readable.push (node:internal/streams/readable:278:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
[Nest] 1347376 - 01/14/2024, 8:55:05 PM ERROR [ExceptionsHandler] syntax error at or near "$1"
PostgresError: syntax error at or near "$1"
at ErrorResponse (/root/api/topupapi/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/cjs/src/connection.js:790:26)
at handle (/root/api/topupapi/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/cjs/src/connection.js:476:6)
at Socket.data (/root/api/topupapi/node_modules/.pnpm/postgres@3.4.3/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:517:28)
at addChunk (node:internal/streams/readable:368:12)
at readableAddChunk (node:internal/streams/readable:341:9)
at Socket.Readable.push (node:internal/streams/readable:278:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
game is text (string) and checkCode is text (string) on this case provided as string[]
when checkCode len is 1 we are getting this error but when its grater then 1 there aren't any error found5 replies