Personal project not found after major upgrade n8n - Selfhost

Questions
1

Describe the problem/error/question

I am doing a major upgrade of my N8N selfhost from 1.119.2 to 2.2.3.

I faced the issue regarding postgres as it’s missing pgcrypto module and I already had it enabled. I could access the n8n UI and login, but I always received Personal project not found. I checked in the database, my user has personal project.

I do inspect the browser network tab, and this endpoint rest/projects/my-projects responds my personal project, but this endpoint rest/projects/personal respond 404.

Please anyone has any idea how can I fix this, I’m stuck the whole day.

What is the error message (if any)?

installHook.js:1 ResponseError: Could not find a personal project for this user

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:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

Hello,

I had the same problem. Somehow the user database got corrupted. I had no other option than to manually adjust the creatorId to the correct user in the project table in the database.

I also cleaned up the project_relation table.

Best regards