Better AuthBA
Better Auth•9mo ago
rhys

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
}

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' }),
});


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