2025-11-22T18:31:42.474Z ERROR [Better Auth]: null value in column "id" of relation "verification" violates not-null constraint
# SERVER_ERROR:  error: null value in column "id" of relation "verification" violates not-null constraint
    at C:\Users\Douglas\Development\Projects\nodejs\expirychecker\node_modules\pg\lib\client.js:545:17
    at processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async PostgresConnection.executeQuery (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:90:49)
    at async file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
    at async DefaultConnectionProvider.provideConnection (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20)
    at async DefaultQueryExecutor.executeQuery (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:34:16)
    at async InsertQueryBuilder.execute (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:1106:24)
    at async InsertQueryBuilder.executeTakeFirst (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:1122:26)
    at async withReturning (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/adapters/kysely-adapter/index.mjs:62:11)
    at async Object.create (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/adapters/kysely-adapter/index.mjs:166:13)
    at async Object.create (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/adapter-factory-znqU8768.mjs:510:16)
    at async createWithHooks (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/get-migration-C1tgKlQ6.mjs:98:69)
    at async Object.createVerificationValue (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/get-migration-C1tgKlQ6.mjs:745:11)
    at async file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/magic-link-DCBndC0L.mjs:60:5
    at async internalHandler (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-call/src/endpoint.ts:421:20)
    at async file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/api-C0IsrmGz.mjs:2867:21
    at PostgresConnection.executeQuery (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/dialect/postgres/postgres-driver.js:102:41)
    at processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
    at async DefaultConnectionProvider.provideConnection (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20)
    at async DefaultQueryExecutor.executeQuery (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-executor/query-executor-base.js:34:16)
    at async InsertQueryBuilder.execute (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:1106:24)
    at async InsertQueryBuilder.executeTakeFirst (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:1122:26)
    at async withReturning (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/adapters/kysely-adapter/index.mjs:62:11)
    at async Object.create (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/adapters/kysely-adapter/index.mjs:166:13)
    at async Object.create (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/adapter-factory-znqU8768.mjs:510:16)
    at async createWithHooks (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/get-migration-C1tgKlQ6.mjs:98:69)
    at async Object.createVerificationValue (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/get-migration-C1tgKlQ6.mjs:745:11)
    at async file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/magic-link-DCBndC0L.mjs:60:5
    at async internalHandler (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-call/src/endpoint.ts:421:20)
    at async file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-auth/dist/api-C0IsrmGz.mjs:2867:21
    at async processRequest (file:///C:/Users/Douglas/Development/Projects/nodejs/expirychecker/node_modules/better-call/src/router.ts:193:22) {
  length: 360,
  severity: 'ERROR',
  code: '23502',
  detail: 'Failing row contains (null, uyuLcsDrfQISoqTPOtTEnDpjfEkMbKWf, {"email":"noreplay@douglasndm.dev"}, 2025-11-22 19:31:42.464+00, 2025-11-22 18:31:42.464+00, 2025-11-22 18:31:42.464+00).',
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: 'better_auth',
  table: 'verification',
  column: 'id',
  dataType: undefined,
  constraint: undefined,
  file: 'execMain.c',
  line: '2005',
  routine: 'ExecConstraints'
}