Hi,
I nocited a problem when I try to "Revoke all active sessions’ from Edit User panel, as I get an error: “Store error: pq: column “rel_resource” does not exist”
Could you please help on that?
thank you
What version are you using and did this start happening after updating from an older version?
There was a change in the DB schema and a manual modification is required; I can give more info after you help me out with my questions
Hi,
It is 2024.9.6 from the begenning
https://docs.cortezaproject.org/corteza-docs/2024.9/devops-guide/upgrade/index.html
here is the role_members info
Table “public.role_members” Column | Type | Collation | Nullable | Default
--------------±--------±----------±---------±--------
rel_resource | text | | not null | rel_role | numeric | | not null |
Indexes: “role_members_pkey” PRIMARY KEY, btree (rel_resource, rel_role)