SkylerX Posts - Answer Overflow

SkylerX

Explore posts from servers

RReactiflux CCConvex Community DTDrizzle Team

•Created by SkylerX on 6/9/2024 in #help

Error while attempting new push

I am using AuthJS Beta (following their instructions) and basic level drizzle-orm schema setup but when I push my newly made changes into the users table I get the following error:

I've made a project in drizzle and I have changed my table and added new columns, when attempting to push I get the following error. Keep in mind that I already have users in my app.

error:
 Warning  You are about to execute current statements:

ALTER TABLE "authenticator" DROP CONSTRAINT authenticator_userId_credentialID_pk;
--> statement-breakpoint
ALTER TABLE "authenticator" ADD CONSTRAINT authenticator_userId_credentialID_pk PRIMARY KEY(userId,credentialID);

error: constraint "authenticator_userid_credentialid_pk" of relation "authenticator" does not exist
    at /Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:77692:15
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Object.query (/Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:119631:26)
    at async pgPush (/Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:122581:13)
    at async _Command.<anonymous> (/Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:129702:7) {
  length: 162,
  severity: 'ERROR',
  code: '42704',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'tablecmds.c',
  line: '11976',
  routine: 'ATExecDropConstraint'
}

I've made a project in drizzle and I have changed my table and added new columns, when attempting to push I get the following error. Keep in mind that I already have users in my app.

error:
 Warning  You are about to execute current statements:

ALTER TABLE "authenticator" DROP CONSTRAINT authenticator_userId_credentialID_pk;
--> statement-breakpoint
ALTER TABLE "authenticator" ADD CONSTRAINT authenticator_userId_credentialID_pk PRIMARY KEY(userId,credentialID);

error: constraint "authenticator_userid_credentialid_pk" of relation "authenticator" does not exist
    at /Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:77692:15
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Object.query (/Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:119631:26)
    at async pgPush (/Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:122581:13)
    at async _Command.<anonymous> (/Users/skylerx/Desktop/school-final-project/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:129702:7) {
  length: 162,
  severity: 'ERROR',
  code: '42704',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'tablecmds.c',
  line: '11976',
  routine: 'ATExecDropConstraint'
}

3 replies

CCConvex Community

•Created by SkylerX on 11/6/2023 in #support-community

Convex + NextAUTH

What is the best way to use next-auth and convex? I want convex's realtime features in my nextjs app but I also need next-auth. I cannot use clerk.

19 replies

Gaming

Programming