Problem logging in Column User.role does not exit
n8nsecretarialife
HOBBYOP
10 months ago
Hi everyone, I'm unable to access my n8n app through railway (hobby Plan) and I get the error "Problem logging in column User.role does not exit" Could someone help me?
2 Replies
Railway
BOT
10 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 URGENT - Database corruption after failed n8n upgrade
- 🧵 Crashed suddenly for n8n
- 🧵 n8n → Postgres connection issue: “Role ‘postgres’ does not exist
If you find the answer from one of these, please let us know by solving the thread!
10 months ago
Try adding this environment variable to your n8n service in Railway:
DB_MIGRATIONS_RUN_ON_STARTUP=trueThen restart your n8n service. This should automatically fix the missing role column issue.
If that doesn't work, you'll need to manually add the column to your database but try this first as it's the easiest fix!