kge
kge
PostsComments
DTDrizzle Team
Created by kge on 11/7/2024 in #help
I'm trying using $count, and it giving me fieldAlias missing. What should I do?
Adding as fixed the issue i encountered. Thanks for the heads up
6 replies
DTDrizzle Team
Created by kge on 11/7/2024 in #help
I'm trying using $count, and it giving me fieldAlias missing. What should I do?
I make small typo while making this post 🤣, since i'm making brand new example based on my original code.. But I've double check and I'm sure 100% there is no typo on my original code
6 replies
DTDrizzle Team
Created by kge on 11/7/2024 in #help
I'm trying using $count, and it giving me fieldAlias missing. What should I do?
For additional info, I also wrap my query into trycatch and log the error. It throw something like this: 
error: syntax error at or near "select"
    at <ommitted-path>\node_modules\.pnpm\[email protected][email protected]\node_modules\pg-pool\index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async eval (webpack-internal:///(rsc)/./node_modules/.pnpm/[email protected]_@[email protected]_@[email protected][email protected][email protected]/node_modules/drizzle-orm/node-postgres/session.js:96:22)
    at async <ommitted-path> (webpack-internal:///(rsc)/./src/<ommitted-path>)
    at async Page (webpack-internal:///(rsc)/./src/<ommitted-path>) 
{
  length: 95,
  severity: 'ERROR',
  code: '42601',
  detail: undefined,
  hint: undefined,
  position: '22',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'scan.l',
  line: '1244',
  routine: 'scanner_yyerror'
}
error: syntax error at or near "select"
    at <ommitted-path>\node_modules\.pnpm\[email protected][email protected]\node_modules\pg-pool\index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async eval (webpack-internal:///(rsc)/./node_modules/.pnpm/[email protected]_@[email protected]_@[email protected][email protected][email protected]/node_modules/drizzle-orm/node-postgres/session.js:96:22)
    at async <ommitted-path> (webpack-internal:///(rsc)/./src/<ommitted-path>)
    at async Page (webpack-internal:///(rsc)/./src/<ommitted-path>) 
{
  length: 95,
  severity: 'ERROR',
  code: '42601',
  detail: undefined,
  hint: undefined,
  position: '22',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'scan.l',
  line: '1244',
  routine: 'scanner_yyerror'
}
6 replies