[Bug]: Vercel postgres - Error: Connection terminated about lucia HOT 9 CLOSED

Can you first verify that it’s an issue with Lucia and not how you setup your database connection?

from lucia.

@pilcrowOnPaper I have the app connected to the vercel postgres database already and can read and write data no problem.

from lucia.

Can you check whether you can query your database in the middleware?

from lucia.

Yes I am able to query another table from the middleware function

from lucia.

Are you querying using db instead of sql?

from lucia.

I'm able to query data with both db and sql from the middleware

from lucia.

Can you insert data with db and use transactions?

from lucia.

I realized I wasn't logging the actual error. It's saying [error: column "email" of relation "auth_user" does not exist]

I made the tables using the schemas shown here: https://lucia-auth.com/database-adapters/postgres/

from lucia.

You have to add the email and email_verified column to the user table

from lucia.