relation "organization_role" does not exist

[jeremydelattre59]

Hi,

I have this error with the latest verstion (19-12-2025) :

[archraziel88]

Sorry the latest tag should not be set. And beta is still a work in progress. Also look like my phone with GitHub 2fa just broke. And im kinda stuck outside my urania account. I'll try to fix beta in this days

[archraziel88]

It should now migrate correctly on startup, if you would like to test it :)

(btw thanks for the feedback, i answered you while i was half-asleep, didn't meant to sound rude )

[jeremydelattre59]

Thanks for your help. (No problem ;-) )

I have another problem : Snapp listening on, port 1000 and not 3000

After restart application, I have always this error :

When I replace internal port by 1000, I have an error "401 The application is not configured to run from this origin."

But in my settings.yaml :

[archraziel88]

i should also add that i'm under a severe cold right now, and the fever could influence my work 😆

so. to make it brief, 1000 was a debug thing i forgot to remove, i will in next beta build reset it at 3000

can i ask you to share compose too, seems like it doesnt see the yaml settings file as the localhost:3000 is the fallback if not set (should match the actual localhost root, but as you noticed i forgot to remove the port 1000 thing.)

edit the migration error also i can remove it, is expected cause you have already migrated to latest version, so it will argue that you don't need migrate again. it was setup to actually get the previous error :)

[jeremydelattre59]

Ok, it's an error in our https://snapp.urania.dev/docs/guide/installation.html#basic-setup : internal volume is /config/settings.yaml instead of /data/config/settings.yaml
I'm going to configure this instead : ./config:/app/config

[archraziel88]

volumes:
   - ./data/settings.yaml:/config/settings.yaml
   # optional – uploaded user avatars
    - ./data/avatars:/app/config/avatars
   # optional – uploaded organization logos
    - ./data/logos:/app/logos

this. you'r right, i miss typed /app/config/settings.yml

[jeremydelattre59]

I have always 401 even if I don't use Nginx.
When I connect into container and open /app/config/settings.yaml :

In my navigator :

[archraziel88]

yeah that's because it failed the new build

i'm rebuilding

edit. btw thank you for your indepth test and patience 🙏

[archraziel88]

now it updated for real

[jeremydelattre59]

It's ok for port 3000 but always 401 error

[archraziel88]

This must be getting painful for you. Im sorry.

Heres my compose.yaml

Heres my settings.yaml

I dont actually have time right now to test some fix (the fever is taking its toll), but i'll get back to you soon

[jeremydelattre59]

I checked with your files but there's no change.
No worries, get well soon.

[archraziel88]

Thank you for your understanding.

Can i ask you to set env SNAPP_DEBUG=true
And also, have you tried to access locally via localhost:3000 ?

Also last check, can you access psql and see what the id of the organization? Should be a slugified version of your origin

[jeremydelattre59]

I had already added SNAPP_DEBUG=true from your screenshot
I can not access from localhost because is a server without GUI
But, organization id is "httplocalhost3000"

[archraziel88]

Thats the reason, it has still not aknowledged your settings. Last shot before going back to code and look for a better solution. Have you tried restart the compose removing the db? (As a plain canvas now that look like seeing your config file, it has not created the organization on startup as it should )