We're using godaddy hosting for our magento site with almost 15000 products. The website speed is good enough and everything else works perfect. The only problem we're having through generating Google sitemap. We tried to apply all the possible ways to fix but no results.
Now we need an expert to help us fixing the issue to generate sitemap to our site. Now we're getting the following error while trying to generate a sitemap:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away, query was: SELECT `main_table`.`page_id`, `main_table`.`identifier` AS `url` FROM `cms_page` AS `main_table` INNER JOIN `cms_page_store` AS `store_table` ON main_table.page_id=store_table.page_id WHERE (main_table.is_active=1) AND (store_table.store_id IN(0, '1'))