Database error when runing vbseo sitemap

Hello everyone,

I'm running vbseo sitemap 2.5 and vbseo 3.3.0 on vbulletin 3.8.2, when i try to generate the sitemap i have a database error like this :

[SECTION START] showthread [1,839.6Kb mem used] [2,042s (+16s)]
[create sitemap file] filename: sitemap_17.xml.gz, number of urls: 10000 [1,910.9Kb mem used] [2,045s (+2s)]
[create sitemap file] filename: sitemap_18.xml.gz, number of urls: 10000 [1,906.7Kb mem used] [2,056s (+11s)]
Database error database has encountered a problem. Please try the following:

• Load the page again by clicking the button in your web browser.

The database error is :

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT p.dateline,p.postid,p.threadid
FROM post AS p
WHERE p.threadid = 16660
AND visible = 1
ORDER BY p.dateline;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, March 7th 2010 @ 06:27:05 PM
Error Date : Sunday, March 7th 2010 @ 06:27:36 PM
Script : http://www.xxxxxxxx.com/vbseo_sitemap/vbseo_sitemap.php
Referrer :
IP Address : xxxxxxx
Username : Non inscrit
Classname : vB_Database

I included just the Show Post Pages,Show Thread Pages and Forum Display Pages and still having the problem.

I also modified the max_allowed_packet variable in my.cnf to 32MB and still have the same problem.

Could anyone help me please i'm having a terrible down in my trafic :s

For information my forums contains Threads: 54 894, Posts: 294 018, Members: 244 327

Thank you in advance

Hello,

You're not currently showing as a customer. Please PM me or open a ticket with your license details so we can assign your license to your account and provide you with support.