Issues when running Drizzle studio on Vercel Postgres
DB Pushing went fine (using Vercel), I can confirm the test table exists, but getting this issue when trying to use studio. It's a sample project using create-t3-app scaffold.
Drizzle Studio is up and running on https://local.drizzle.studio
error: syntax error at or near "-"
at /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:43639:15
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async proxy (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:60358:24)
at async /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:60500:26
at async dispatch (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37750:21)
at async /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37418:9
at async dispatch (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37750:21)
at async cors2 (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:38926:9)
at async dispatch (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37750:21)
at async /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:38150:29 {
length: 90,
severity: 'ERROR',
code: '42601',
detail: undefined,
hint: undefined,
position: '78',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'scan.l',
line: '1241',
routine: 'scanner_yyerror'
}Drizzle Studio is up and running on https://local.drizzle.studio
error: syntax error at or near "-"
at /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:43639:15
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async proxy (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:60358:24)
at async /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:60500:26
at async dispatch (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37750:21)
at async /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37418:9
at async dispatch (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37750:21)
at async cors2 (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:38926:9)
at async dispatch (/projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:37750:21)
at async /projects/my-test-project/node_modules/.pnpm/drizzle-kit@0.20.16/node_modules/drizzle-kit/bin.cjs:38150:29 {
length: 90,
severity: 'ERROR',
code: '42601',
detail: undefined,
hint: undefined,
position: '78',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'scan.l',
line: '1241',
routine: 'scanner_yyerror'
}Solution
Yeah it seems to be because of the - in the table name. Are you going through Theo tutorial also?
