Comments (9)
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.
Related Issues (20)
- [SOLVED]: Session lifetime never extended even though the user is actively using the app. HOT 4
- [Docs]: Postgres user database HOT 1
- [Docs]: A guide on how to extend or create a custom DB adapter HOT 2
- [Bug]: Anyone got lucia working with nestjs ? HOT 1
- [Docs]: Add specific guides and examples for Remix HOT 1
- [Feature Request]: Support timestamp mode for Drizzle SQLite expiry column
- [Feature Request]: Customizable session.fresh / active period expiration HOT 8
- [Bug]: ERR_REQUIRE_ESM error in an Express + Typescript project HOT 2
- [Docs]: Include contents on how to test an application with Lucia HOT 1
- [Docs]: SolidStrat middleware does not work on new versions
- Prisma Adapter does not accept Session and User models HOT 3
- RFC: Remove adapter packages HOT 36
- [Bug]: None of the Argon package works for Next.js app HOT 2
- [Bug]: getUserAttributes doesn't include relations field of the user HOT 1
- Global Register types conflicting with each other HOT 1
- [Bug]: Adapter querying all columns, not respecting DatabaseUserAttributes HOT 2
- [Bug]: validateSession returns null. Sveltekit + MongoDB + Lucia HOT 8
- [Docs]: clarify `getUserAttributes()` should mention how it handles the user `id` column HOT 1
- [Feature Request]: Add sequelize ORM support
- lucia auth get data from from different table
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
π Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. πππ
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google β€οΈ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from lucia.