Missing 'account' table breaks Better Auth sign-up flow #12

New Issue

TopherMayor · 2026-04-27T17:55:55Z

TopherMayor commented

2026-04-27 17:55:55 +00:00

Description

After fixing the email_verified schema (#9), sign-up now creates the user record successfully but returns 500 because Better Auth expects an account table to store credential records.

Error

BetterAuthError: [# Drizzle Adapter]: The model "account" was not found in the schema object.

Impact

User record IS created in users table (confirmed working)
But no session is created (empty sessions table)
User cannot complete sign-in (500 error)
The app creates the user but can't finish the auth flow

Fix

Add the account table to the Drizzle schema and create a migration. Better Auth requires these core tables:

users (exists)
sessions (exists)
accounts (MISSING — stores OAuth/credential providers)
verifications (optional — for email verification)

Schema should follow Better Auth conventions. See: https://www.better-auth.com/docs/concepts/database

Severity: High

Sign-up creates orphaned users with no session. Full auth flow is broken.

## Description After fixing the email_verified schema (#9), sign-up now creates the user record successfully but returns 500 because Better Auth expects an `account` table to store credential records. ## Error ``` BetterAuthError: [# Drizzle Adapter]: The model "account" was not found in the schema object. ``` ## Impact - User record IS created in `users` table (confirmed working) - But no session is created (empty `sessions` table) - User cannot complete sign-in (500 error) - The app creates the user but can't finish the auth flow ## Fix Add the `account` table to the Drizzle schema and create a migration. Better Auth requires these core tables: - `users` (exists) - `sessions` (exists) - `accounts` (MISSING — stores OAuth/credential providers) - `verifications` (optional — for email verification) Schema should follow Better Auth conventions. See: https://www.better-auth.com/docs/concepts/database ## Severity: High Sign-up creates orphaned users with no session. Full auth flow is broken.

TopherMayor added the bug label 2026-04-27 17:55:55 +00:00

TopherMayor referenced this issue from a commit

2026-04-27 17:57:39 +00:00

fix #12: add accounts table for Better Auth credential storage

TopherMayor closed this issue

2026-04-27 17:57:39 +00:00

TopherMayor referenced this issue from a commit

2026-04-27 18:01:46 +00:00

fix #12: add missing session fields ipAddress and userAgent to Drizzle schema

TopherMayor referenced this issue from a commit

2026-04-27 18:22:58 +00:00

fix #12: simplify auth adapter, add verifications table