rhys Posts - Answer Overflow

rhys

Explore posts from servers

LOELeague of Extraordinary FoundryVTT Developers BABetter Auth

•Created by rhys on 4/12/2025 in #help

Output debug mode?

Is there any way to output more debugging stuff? I'm getting an error which is quite difficult to debug;

error PostgresError: column "undefined" does not exist

error PostgresError: column "undefined" does not exist

35 replies

BABetter Auth

•Created by rhys on 4/9/2025 in #help

The field "id" does not exist in the "verification" schema

Hey guys, I'm trying to get Better Auth working with Directus, a headless CMS system. I'm having to hack around a little by manually creating the tables that there isn't an analog in Directus, and am having an issue with the verification table, which outputs

# SERVER_ERROR:  [BetterAuthError: The field "id" does not exist in the "verification" schema. Please update your drizzle schema or re-generate using "npx @better-auth/cli generate".] {
  cause: undefined
}

# SERVER_ERROR:  [BetterAuthError: The field "id" does not exist in the "verification" schema. Please update your drizzle schema or re-generate using "npx @better-auth/cli generate".] {
  cause: undefined
}

Introspecting my postgres db, this is the table that I've created;

export const verification = pgTable("verification", {
    id: text().primaryKey().notNull(),
    date_created: timestamp({ mode: 'string' }),
    expires_at: timestamp({ mode: 'string' }).notNull(),
    value: text().notNull(),
    identifier: text(),
    date_updated: timestamp({ mode: 'string' }),
});

export const verification = pgTable("verification", {
    id: text().primaryKey().notNull(),
    date_created: timestamp({ mode: 'string' }),
    expires_at: timestamp({ mode: 'string' }).notNull(),
    value: text().notNull(),
    identifier: text(),
    date_updated: timestamp({ mode: 'string' }),
});

Not sure what's wrong- it's complaining about the ID. How is the id created? Is it expecting it to be a uuid?

21 replies

Gaming

Programming