Drizzle ORM issues
Running into weird issue with ORM where
Query: select "id", "name", "email", "emailVerified", "image", "password", "role", "isNewUser", "invalidlogin_attempts", "lockedAt", "isTwoFactorEnabled", "created_at", "updated_at" from "dds_users" "users" where "users"."email" = $1 limit $2 -- params: ["xxx@gmail.com", 1]
⨯ TypeError: value.toISOString is not a function
at PgTimestamp.mapToDriverValue (C:\MyFiles\Saas\next-progress-saas.next\server\chunks\ssr\5f296_drizzle-orm_pg-core_f7448a..js:1958:22)
But NEON works
select "id", "name", "email", "emailVerified", "image", "password", "role", "isNewUser", "invalid_login_attempts", "lockedAt", "isTwoFactorEnabled", "created_at", "updated_at" from "dds_users" "users" where "users"."email" = 'xxx@gmail.com' limit 1
1 0f6f87da-2e4e-461a-9e35-d6dbbb5cec77 BrianT XXX xxx@gmail.com $2b$10$WZp3J0vsX8au5pGEw7HDluTDogz8xUOX64MLEuXZX1Ro14k539QF2 User t 0 f 2024-12-09 20:31:39.175528+00 2024-12-09 20:31:39.175528+00
Query: select "id", "name", "email", "emailVerified", "image", "password", "role", "isNewUser", "invalidlogin_attempts", "lockedAt", "isTwoFactorEnabled", "created_at", "updated_at" from "dds_users" "users" where "users"."email" = $1 limit $2 -- params: ["xxx@gmail.com", 1]
⨯ TypeError: value.toISOString is not a function
at PgTimestamp.mapToDriverValue (C:\MyFiles\Saas\next-progress-saas.next\server\chunks\ssr\5f296_drizzle-orm_pg-core_f7448a..js:1958:22)
But NEON works
select "id", "name", "email", "emailVerified", "image", "password", "role", "isNewUser", "invalid_login_attempts", "lockedAt", "isTwoFactorEnabled", "created_at", "updated_at" from "dds_users" "users" where "users"."email" = 'xxx@gmail.com' limit 1
1 0f6f87da-2e4e-461a-9e35-d6dbbb5cec77 BrianT XXX xxx@gmail.com $2b$10$WZp3J0vsX8au5pGEw7HDluTDogz8xUOX64MLEuXZX1Ro14k539QF2 User t 0 f 2024-12-09 20:31:39.175528+00 2024-12-09 20:31:39.175528+00
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
