Auth.JS + Drizzle ORM ([auth][error] AdapterError)

[4N1Z]

What am I doing ?

• I have been trying to complete the authentication setup, but the error below keeps on popping up.
  

• I have followed all the installation part from the docs and configured google OAuth, and drizzleAdapter successfully. When a user signin, it creates the correct entry on the DB (both in users and account table), but it doesn't compelete the call. (my initial impression)

Things i have done .

• I did some debugging in session under callbacks, and it is not called.
• And the auth session (const session = await auth() ) when logged in from other files (although the DB is updated) returns a null.
• Checked my schema and made sure, the created_at, expires_at across the schema, where Date are mentioned to be string.
  createdAt: timestamp("created_at", { withTimezone: true, mode: "string" }) .defaultNow() .notNull(),
• And obviously asked claude, still got nothing.

It will be a huge help if you guys can give me something !