DB Errors Init on Login for `create-t3-app` w/ Prisma + NextAuth
For me, it was returning this
Error from Prisma:
It was not clear if there was any additional Init' Setup, but this is what I found out the hard way.
It seems that the Session model is defined in your Prisma schema but the corresponding table has not been created in your SQLite database.
To resolve this issue, you can follow these steps:
1. Run Migrations: Ensure that your database schema is up to date with your Prisma schema. You can do this by running the following command:
This command will create the necessary tables in your database based on your Prisma schema.
2. Push Schema Changes: If you are not using migrations and just want to push the current schema to the database, you can use:
3. Check Database Connection: Ensure that your DATABASE_URL in the .env file is correctly pointing to your SQLite database.
4. Prisma Studio: You can also use Prisma Studio to visually inspect your database and confirm that the Session table has been created:
After performing these steps, the Session table should exist in your database, and the error should be resolved.0 Replies