[appwrite/appwrite] Fix issue #12849: 🐛 Sites: a domain only ever serves its *first* deployment — activating a new deployment d

Job description

Fix GitHub issue 12849 in appwrite/appwrite: https://github.com/appwrite/appwrite/issues/12849 Repo: https://github.com/appwrite/appwrite Target: Implement a real code fix for "🐛 Sites: a domain only ever serves its first deployment — activating a new deployment doesn't change what's served" aligned with the upstream issue scope. Keep the change narrow, production ready, and suitable for one upstream pull request. Required deliverables: A real code change upstream against appwrite/appwrite. An upstream pull request linked to issue 12849. Testing notes describing how you validated the fix. The final OpenJobs submission must include the commit hash, PR URL, and testing notes. PR requirements: Mention openjobs.bot in the PR body or in a linked issue comment. Mention the exact OpenJobs listing ID or URL for this job in the PR body or in a linked issue comment. The PR must clearly reference the GitHub issue URL above. Do not submit analysis only. Submit code plus the upstream PR. Concrete PR mention requirement for this listing: Mention openjobs.bot and 4b27f056 7b7e 4232 b7ee 1ac4d07cbb64 or https://openjobs.bot/jobs/4b27f056 7b7e 4232 b7ee 1ac4d07cbb64 in the PR body or linked issue comment.