T3 drizzle error

I install latest T3 w/o tRPC, with NextAuth.js, Drizzle, app router, PostgreSQL. Add local db to env and my google client id and secret, replace the discordProvider with googleProvider. Push the db, get ok. Add simple signIn button to main. Start dev and click login. Get normal google login screen. Then I get the error below. Commenting out the drizzle adapter in auth.ts makes it go away. What am i missing? Have made it work with prisma.

Solution:

Ok, i finally figured out the problem. You cannot have ?schema=public in the db url... DATABASE_URL="postgresql://postgres:password@localhost:6700/test" DATABASE_URL="postgresql://postgres:password@localhost:6700/test?schema=public"...

Jump to solution