[SOLVED] Rescuing orphan projects

I ran into a weird bug. I have a project with ID 651fbdbfd8d3a4aa7c38 that is quite old. Maybe during some migration, it wasn't able to properly link to an existing Organization, because of which it would not show up in any projects list, either through the CLI, API, or the console. However, hitting the URL /console/project-default-651fbdbfd8d3a4aa7c38 did show the project was fully intact and working. It just won't show in any projects list.

The fix was simple--move the project to a new organization and it showed up then. But this got me thinking, I do not remember all the projects I have created. There could be other such orphan projects too. Is there a way I can get IDs of all the projects, regardless of whether they belong to an organization or not? I can then move them to the correct organization.

I am on Appwrite 1.9.5 self-hosted.

you should upgrade to 2.0.0, they migrate all organisations and projects into one org. so projects in old deleted orgs, will have their orgId changed to the single one you will be able to see.

(ps. go to 1.9.6 before 2.0.0, and also i would recommend anyways going to 1.9.6 even if you don't go to 2.0.0 as it fix most of the 1.9.5 bugs)

Good idea, I will do that

Thanks!

[SOLVED] Rescuing orphan projects

also if you stay on 1.9.6, to see all projects, you should look into the mariadb directly.

Do you know the specific table that has the projects? I can explore it on my own also, but if you know it then it would save me quite some headache

not really, what i remember, is that there is multiple tables for one project where it's like _<X>_<table_name> where X is a internal project ID.

iirc, there is also "console" as a project id, and it's maybe in there that it holds metadata of the project and it's org

looked up myself, you can check :
_console_teams for the orgs
_console_projects for the projects (and the teamId, is the org Id it's linked to)