Hi all,
I have successfully managed to create a sign up + login flow, the dB is connected fine and all schema retrieves correctly.
I’ve followed the creating a login doc, and set the remember property - but after logging out if I have a security enforcer I keep getting logged out - so for now, I’ve removed it from all pages while I continue to build.
The issue i’m constantly facing, and I’m sure it’s just user error - is creating a session to keep a user logged in, then referring back to the security provider for the user ID. I’m constantly getting 500 and/or unauthorized errors, specifically a weird syntax error being reported:
This is the error message:
{status: “500”, code: “22P02”,…}
code: “22P02”
message: “select “users”.“firstName”, “users”.“lastName”, “users”.“email”, “users”.“id”, “users”.“job_title”, “users”.“organization”, “users”.“user_information”, “user_information”.“calendar_link”, “user_information”.“job_title”, “user_information”.“avatar” from “users” inner join “user_information” on “user_information”.“user” = “users”.“id” where “users”.“id” = $1 - invalid input syntax for type integer: “false””
The security proider is setup as ‘Database’ which connects fine, and I’m using the Use Password Has Verify, I’m using SHA256 + salt, the sign up and login is working fine with this method.
What I’m trying to do on each content page is a server connect to get_current_user and to achieve this I need to refer back to the security provider to get the user ID. I then with most workflows try to refer back to this when doing and updates/form inserts - so with this not working it’s blocking any further progress.
I’d appreciate any ideas here for what I’m doing wrong. I’ll keep re-reading all docs, but there is only so many times I can read and double check everything.
Last updated: