Email Provider not working on Vercel with the Prisma Adapter

[simonfarah]

Hello! So I am using a custom login form with the Email Provider and Google Provider. On localhost everything works fine and as expected. However, when the project is deployed to production on Vercel, an error occurs when trying to sign in with email. I am using the Prisma adapter and a PostgreSQL database.

• Here is my NextAuth configuration:

• Here is my Prisma schema (taken as it is from the docs, just removing the Session table since I am using JWT tokens):

• Here is the function called to sign in. I am just taking the email from the input and calling the signIn function:

• Environment variables NEXTAUTH_URL and NEXTAUTH_SECRET are correctly configured.

• Here is the error I get when I try to log in on the deployed website on Vercel:

The error I get basically states that the password column does not exist in the User table, however, this is a passwordless method + the Prisma schema is taken from the docs + NextAuth encourage us to not use the Credential Provider because of passwords. And the login process works great on localhost.

The database used on localhost and the deployed website is the same.

A little help and explanation would be really appreciated to fix this. Thanks!

[simonfarah]

So what happened is that I was using the credentials provider along with the email provider in a previous deployment and it looks like it caused some sort of conflict somewhere when I removed the credentials provider. Redeployed the code and got it to work after a database reset. Still don't know why it was working on localhost though.