Can't login with Prisma Adapter on sqlite

[eden6]

Describe the bug
I get a [get_user_by_provider_account_id_error] TypeError: prisma[Account].findOne is not a function on login with GitHub provider. I get the correct profile data in the console but the user is never created in the db.
I use the same schema file than the one on Next-Auth Website.

I get that the error is related to database but migrations work.

Same GitHub secret and id work with the TypeORM adapter.

Steps to reproduce
Create a new NextJs project, install next-auth and follow the Prisma Adapter tutorial

Have a look at this repo

Expected behavior
Create a new user and session and not return a error

Screenshots or error logs

Thank you!

[simonedelmann]

I have the same error. This is because findOne was deprecated in Prisma 2.14 and removed in 2.15, which was released today. The 3.2.0@canary should already have a fix for this. (It will try that in a second...)

Edit: Canary build works. Try npm i next-auth@canary.

[balazsorban44]

@simonedelmann is right. #881 fixed this, and is available at the canary release.

[dalalRohit]

Yes, next-auth is not working with @prisma/cli-2.15.0 and @prisma/client-2.15.0

Working well with @2.14.0