Sitemap Not Running After Site Upgrade

Hi - I'm running 2.1 which was working fine. At the weekend, I upgraded Apache, SQL, PHP and vBUlletin (to 3.7). Since then, the site map generator has not been running. I have checked the settings, plugins and hock are on, the individual product is on, it is listed correctly in the schedualed tasks - I just can't find what I wrong.

If you try to run the schedualed task manually, I get the following error:

vBSEO Sitemap Generator
[SECTION START] showthread [5,439.5Kb mem used] [110,086s (+26,984s)]
[create sitemap file] filename: sitemap_7.xml.gz, number of urls: 45000 [5,456.3Kb mem used] [110,109s (+23s)]
[create sitemap in text format] part #8 [5,456.3Kb mem used] [110,109s (+0s)]
Database error
The MIG Performance Vauxhalls database has encountered a problem.
--------------------------------------------------------------------------------

Database error in vBulletin 3.7.0:
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 = 52
AND visible = 1;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, May 9th 2008 @ 07:35:31 AM
Error Date : Friday, May 9th 2008 @ 07:36:18 AM
Script : xxxxxxxxxx/cronadmin.php?do=runcron&cronid=26
Referrer : xxxxxxxxxx/index.php
IP Address : xxxxxxxxxx
Username : xxxxxxxxxx
Classname : xxxxxxxxxx
MySQL Version :

Any help would be great. Thanks.

Sorry - posted in wrong forum, please move. Thanks.

Interesting - I just an email saying a sitemap had been generated and spotted it took over a day to generate! It is usually a few minutes. Here is a copy and paste from the cp:

32 2008-04-30 01:00 362.79 s 718,238 +186 Yes View details | Remove record
33 2008-05-01 01:00 349.50 s 718,422 +184 Yes View details | Remove record
34 2008-05-02 01:00 358.13 s 718,629 +207 Yes View details | Remove record
35 2008-05-03 01:00 354.96 s 718,816 +187 Yes View details | Remove record
36 2008-05-04 01:00 344.06 s 719,016 +200 Yes View details | Remove record
37 2008-05-05 01:00 172,922.46 s 719,431 +415 Yes View details | Remove record
38 2008-05-08 01:00 110,485.44 s 719,966 +535 Yes View details | Remove record

What is going on?

FYI, upgraded php4 to php5 and sql4 to sql5.

Hello,

please try to increase wait_timeout setting in MySQL configuration, sitemap generation is a relatively long process and takes more time than a "normal" web script.

Interesting - I just an email saying a sitemap had been generated and spotted it took over a day to generate! It is usually a few minutes. Here is a copy and paste from the cp:

It means that the script was interrupted at some point and resumed generation next day with new cron task.

wait_timeout is set to 30. What shouild I change it to?

Default value for that setting is 28800: MySQL :: MySQL 5.0 Reference Manual :: 5.1.3 System Variables
You might want to increase it depending on how long does it take to create sitemap.
Otherwise, you can keep it as is and generate sitemap in 2 steps (with the second cron tasks resuming generation).

Thanks for the help - works fine now.

I think I'll do one of those "server optimisation requests" over at vbulletin.com now that I've upgraded everything.

Great, you are welcome