Custom Domain issues - Appwrite 1.8.1 Selfhost using DigitalOcean marketplace Droplet

Hi, I'm experimenting with Appwrite v1.8.1 on DigitalOcean. My NextJS app works fine with the Appwrite generated site url appwrite1.sites.mysite.com but the app struggles to fetch and display database data (from Appwrite db) on my /faq page if I use a custom domain like cd.mysite.com. I have my custom domain added in the Sites dashboard and pointing via CNAME to sites.mysite.com (Cloudflare DNS Only) and the SSL cert for cd.mysite.com seems fine when tested. LetsEncrypt seems to generate fine for the custom domain but I don't actually get the verify button indicating green for successful domain addition. I have a platform created for cd.mysite.com in Appwrite dashboard also. My goal is to have 5 playground projects with 5 different corresponding NextJS apps using 5 different subdomains so using _APP_DOMAIN=appwrite.mysite.com in appwrite>.env In the browser console I get intermittent fetch (pending) and 500 errors when trying to fetch data for my /faq page using the custom domain specifically. The fetch sometime loads and shows data, and sometimes it just goes to pending and eventually loads after 30 secs, and sometimes it just fails with a 500 error loading nothing. App is basic so no resource usage or bandwidth issues. App also works fine in dev on my laptop localhost:3000. Custom domains are the issue. Errors Attached Thanks