Thank you for the prompt reply. Very much appreciated.
For the benefit for those reading this post, some of the pages somehow were set to Private therefore the site is not showing up. I have to manually set them back to Public one by one and it works.
Thank you SeedProd.