Error after upgrading version

[karim-soufi]

Describe the problem/error/question

Cannot acces the application after upgrading from 1.53.2 to 1.68.0

What is the error message (if any)?

QueryFailedError: column User.apiKey does not exist

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version:1.68.0
• Database (default: SQLite): Postgres
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): docker
• Operating system: Linux

[ria]

Hi @karim-soufi

It sounds like your n8n database schema got out of sync… Sometimes during updates there are db migrations that do not execute correctly and in your case the apiKey column got deleted but the schema didn’t pick up on that change.

Did you get anything else in the logs that said anything about migration?

Actually the best thing to do here is to Rollback the migration and try to update again.
See more on that here - Release notes | n8n Docs

[karim-soufi]

didnt get anything i nthe logs.
I tried rollingback to previous version but the database is broken now.

[javierfuentesm]

@ria Im getting the same error . I didnt change nor update anything it suddenly stopped working . The last deployment was 2 months ago
These are the errors in the DB

the workflows stopped working too

[javierfuentesm]

I dont know what happened , i had to redeploy everything again and it started working , according to railway there was not a deployment made in the last 2 months, but maybe it got updated somehow ?