Better Auth•2w ago

Google Oauth error on 1.2.6

Hi. Today, after updating to 1.2.6, the CLI generates schema with uuid instead of id. I changed other schemas to use uuid, too, and used drizzle to modify the database. Now I get this error from the terminal:

# SERVER_ERROR:  [Error [PostgresError]: invalid input syntax for type uuid: "5W3ck3qLwc1PlpQnH7gS4Z5RMCtLZrHd"] {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '22P02',
  where: "unnamed portal parameter $1 = '...'",
  file: 'uuid.c',
  line: '133',
  routine: 'string_to_uuid'
}
 POST /api/auth/sign-in/social 500 in 3520ms

# SERVER_ERROR:  [Error [PostgresError]: invalid input syntax for type uuid: "5W3ck3qLwc1PlpQnH7gS4Z5RMCtLZrHd"] {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '22P02',
  where: "unnamed portal parameter $1 = '...'",
  file: 'uuid.c',
  line: '133',
  routine: 'string_to_uuid'
}
 POST /api/auth/sign-in/social 500 in 3520ms

I downgraded to 1.2.5 and reverted back everything to use id with text instead of uuid, and the error has gone. I get that during OAuth, it's trying to put an id to the verification table that the format is not uuid, and the error is coming from there. Nextjs 15.2.4 better-auth 1.2.6 Drizzle-orm 0.41 supabase

Solution:

There is a PR which fixes this, it will be merged as soon as @bekacru is available. Sorry for the inconvenience....

Jump to solution

3 Replies

Solution