🐛 Bug Report: Self-hosted functions via domain: deployment_not_found #13619

👟 Reproduction steps

1. Create a function + deployment
2. Access the generated domain or a custom domain
3. Then this error appears:
   This page is empty; activate a deployment to make it live.
   deployment_not_found

👍 Expected behavior

The activated deployment should be automatically assigned by the corresponding domain

👎 Actual Behavior

Whether it's a custom domain or the generated domain, the following error always appears: "This page is empty; activate a deployment to make it live. deployment_not_found"

Creating a new deployment or activating a different deployment does not solve the problem; instead, you must activate the deployment using the following commands - every time:

• DB_CONTAINER=$(docker compose ps -q postgresql)
• docker exec -it "$DB_CONTAINER" psql -U user -d appwrite -c "UPDATE appwrite._console_rules SET \"deploymentId\" = '<DEPLOYMENT_ID>' WHERE domain = '<FUNCTION_DOMAIN>';"

After that, the deployment works via the corresponding URL.
The same problem also affects sites, as has already been reported here: #13088

🎲 Appwrite version

Different version (specify in environment)

💻 Operating system

Linux

🧱 Your Environment

Self-Hosted 2.0

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct