BifocalCanvas Posts - Answer Overflow

BifocalCanvas

Explore posts from servers

DIAdiscord.js - Imagine an app SIASapphire - Imagine a framework PPrisma DTDrizzle Team

•Created by BifocalCanvas on 5/1/2024 in #help-and-questions

Prisma throws an error with code 2F005

When running an upsert, prisma throws the following error:

Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "2F005", message: "control reached end of trigger procedure without RETURN", severity: "ERROR", detail: None, column: None, hint: None }), transient: false })

1 replies

DTDrizzle Team

•Created by BifocalCanvas on 3/8/2024 in #help

Random `PostgresError: invalid input syntax for type bigint`

When attempting to query my database with db.select().from(roster) I get that error even though I made sure each column type is correct in my schema.ts file. Here is the full query line:

let newest = await db.select().from(roster).limit(3);

let newest = await db.select().from(roster).limit(3);

and here is the entire error:

PostgresError: invalid input syntax for type bigint: "newest"
    at ErrorResponse (/Users/svalencia/projects/svalencia014/zjx-express/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/Users/svalencia/projects/svalencia014/zjx-express/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/Users/svalencia/projects/svalencia014/zjx-express/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:514: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 TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '22P02',
  where: "unnamed portal parameter $1 = '...'",
  file: 'numutils.c',
  line: '879',
  routine: 'pg_strtoint64_safe'

PostgresError: invalid input syntax for type bigint: "newest"
    at ErrorResponse (/Users/svalencia/projects/svalencia014/zjx-express/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/Users/svalencia/projects/svalencia014/zjx-express/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/Users/svalencia/projects/svalencia014/zjx-express/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:514: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 TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '22P02',
  where: "unnamed portal parameter $1 = '...'",
  file: 'numutils.c',
  line: '879',
  routine: 'pg_strtoint64_safe'

3 replies

SIASapphire - Imagine a framework

•Created by BifocalCanvas on 7/14/2023 in #sapphire-support

Setting Nicknames

Is there a good way to set a user's nickname (by userID) when using sapphire?

11 replies

Gaming

Programming