site map not working check this error plz

yesterday i shift my site to dedicated server after that my site map not working

check this issue plz ,



even its link also not working Sitemap Index: http://www.desicorner.net/sitemap_index.xml.gz

when i click here its redirect to my home page

and when i genrate sitemap through admincp ,

then show me this error



after that receive error thorugh mail

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT count(*) as cnt
,max(views) as maxv,avg(views) as avgv
,max(replycount) as maxre,avg(replycount) as avgre
FROM thread
WHERE forumid = 34
AND visible = 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, June 19th 2011 @ 02:48:39 PM
Error Date : Sunday, June 19th 2011 @ 02:50:07 PM
Script : http://www.desicorner.net/vbseo_site...eo_sitemap.php
Referrer : http://www.desicorner.net/vbseo_site...php?rlist=true
IP Address : 182.185.254.207
Username : Unregistered
Classname : vB_Database
MySQL Version :

Hello,

The sitemap appears to be loading correctly now.

"gone away" errors are a direct result of wait_timeout setting in My.Cnf file for mysql. Try raising this setting to 180, restart the sql service, and try again.

which one settings is the best for vbseo sitemap ?

it depends on your server. 180 is an 'average' setting.

i have already made this changes , but i dnt know what is issue

when i m using vps mean few days back and generate sitemap its take not more the 2 mint and right now i m genrating

almost 20 mints gone but still its processing i dnt know what is the issue sending u snap check this issue plz

now its finish on this process

[SECTION START] showthread [21,050.6Kb mem used] [4s (+0s)]
[create sitemap file] filename: sitemap_forum_1.xml.gz, number of urls: 20000 [24,694.3Kb mem used] [43s (+39s)]
[create sitemap file] filename: sitemap_forum_2.xml.gz, number of urls: 20000 [24,344.4Kb mem used] [85s (+42s)]
[create sitemap file] filename: sitemap_forum_3.xml.gz, number of urls: 20000 [24,349.4Kb mem used] [155s (+70s)]
[SECTION START] polls [21,071.4Kb mem used] [162s (+6s)]
[create sitemap file] filename: sitemap_forum_4.xml.gz, number of urls: 2378 [21,077.1Kb mem used] [162s (+1s)]
[SECTION START] tags [20,195.2Kb mem used] [162s (+0s)]



even this file not genrated

[create sitemap index] filename: sitemap_index.xml.gz, number of sitemaps: 3 [4,178.9Kb mem used] [175s (+0s)]
Sitemap has been created. Click here to return [4,175.7Kb mem used] [176s (+1s)]

replied to your ticket