Error: invalid column data type undefined - when running generate migration
Error running the cli generate. In addition to diagnosing, I think the error logging should be clearer here. What column?
better-auth 1.2.4
% npx @better-auth/cli@latest generate
⠋ preparing schema...file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/kysely/dist/esm/parser/data-type-parser.js:11
throw new Error(`invalid column data type ${JSON.stringify(dataType)}`);
^
Error: invalid column data type undefined
at parseDataTypeExpression (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/kysely/dist/esm/parser/data-type-parser.js:11:11)
at CreateTableBuilder.addColumn (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/kysely/dist/esm/schema/create-table-builder.js:121:105)
at getMigrations (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/better-auth/dist/shared/better-auth.67eSHmUo.mjs:1094:19)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async generateMigrations (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/@better-auth/cli/dist/index.mjs:608:33)
at async Command.generateAction (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/@better-auth/cli/dist/index.mjs:658:18)
% npx @better-auth/cli@latest generate
⠋ preparing schema...file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/kysely/dist/esm/parser/data-type-parser.js:11
throw new Error(`invalid column data type ${JSON.stringify(dataType)}`);
^
Error: invalid column data type undefined
at parseDataTypeExpression (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/kysely/dist/esm/parser/data-type-parser.js:11:11)
at CreateTableBuilder.addColumn (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/kysely/dist/esm/schema/create-table-builder.js:121:105)
at getMigrations (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/better-auth/dist/shared/better-auth.67eSHmUo.mjs:1094:19)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async generateMigrations (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/@better-auth/cli/dist/index.mjs:608:33)
at async Command.generateAction (file:///dir/.npm/_npx/05eee8cc65087e98/node_modules/@better-auth/cli/dist/index.mjs:658:18)
1 Reply
File Contents
src/lib/auth.ts
worked around this by doing it without kysely , but still would like to know what the issue was
import { betterAuth } from 'better-auth';
import pkg from 'pg';
import { PostgresDialect } from 'kysely';
const { Pool } = pkg;
// parse db components from DATABASE_URL env variable
const dbComponents = new URL(process.env.DATABASE_URL);
const dbHost = dbComponents.hostname;
const dbPort = dbComponents.port;
const dbUser = dbComponents.username;
const dbPassword = dbComponents.password;
const dbName = dbComponents.pathname.slice(1);
// Create a PostgreSQL connection pool
const pool = new Pool({
host: dbHost,
port: parseInt(dbPort),
user: dbUser,
password: dbPassword,
database: dbName,
});
// Create a PostgreSQL dialect for Kysely
const dialect = new PostgresDialect({
pool,
});
// Initialize Better Auth
export const auth = betterAuth({
// Database configuration
database: {
dialect,
type: 'postgresql',
},
// Base URL for auth routes
baseUrl: process.env.BETTER_AUTH_URL,
// Secret key for encryption and token generation
secret: process.env.BETTER_AUTH_SECRET,
// Enable email and password authentication
emailAndPassword: {
enabled: true,
},
// Configure Google OAuth
socialProviders: {
google: {
clientId: process.env.GOOGLE_CLIENT_ID || '',
clientSecret: process.env.GOOGLE_CLIENT_SECRET || '',
},
},
// Session configuration
session: {
// Session expiration time (30 days in seconds)
expiresIn: 30 * 24 * 60 * 60,
},
});
import { betterAuth } from 'better-auth';
import pkg from 'pg';
import { PostgresDialect } from 'kysely';
const { Pool } = pkg;
// parse db components from DATABASE_URL env variable
const dbComponents = new URL(process.env.DATABASE_URL);
const dbHost = dbComponents.hostname;
const dbPort = dbComponents.port;
const dbUser = dbComponents.username;
const dbPassword = dbComponents.password;
const dbName = dbComponents.pathname.slice(1);
// Create a PostgreSQL connection pool
const pool = new Pool({
host: dbHost,
port: parseInt(dbPort),
user: dbUser,
password: dbPassword,
database: dbName,
});
// Create a PostgreSQL dialect for Kysely
const dialect = new PostgresDialect({
pool,
});
// Initialize Better Auth
export const auth = betterAuth({
// Database configuration
database: {
dialect,
type: 'postgresql',
},
// Base URL for auth routes
baseUrl: process.env.BETTER_AUTH_URL,
// Secret key for encryption and token generation
secret: process.env.BETTER_AUTH_SECRET,
// Enable email and password authentication
emailAndPassword: {
enabled: true,
},
// Configure Google OAuth
socialProviders: {
google: {
clientId: process.env.GOOGLE_CLIENT_ID || '',
clientSecret: process.env.GOOGLE_CLIENT_SECRET || '',
},
},
// Session configuration
session: {
// Session expiration time (30 days in seconds)
expiresIn: 30 * 24 * 60 * 60,
},
});