Installed Sitemap Generator - Keep getting database errors when trying to generate my f

I am trying to run the vBSEO Sitemap Generator for the first time on my forum, and it keeps causing a database error when the generator finishes the first sitemap file and starts the second one.

This is the error:

Code:

Database error in vBulletin 3.8.6:

Invalid SQL:

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

MySQL Error   : MySQL server has gone away

I increased my wait_timeout variable to 90 seconds and the same error happens.

I commented the following out of my vbseo.php file:

Code:

 vbseo_close_db();

And the same error happens.

Within my Sitemap settings, I increased the "Delay Execution After Each Sitemap File" to 30, 60, and 90 - and none of those changes corrected this.

Please advise. What else can I do to generate a sitemap?

I'm running vBulletin 3.8.6 with vBSEO 3.5.2 and Sitemap Generator 2.5

Hello Daniel,

How many URLs are you including on each sitemap?.

I'm including 30,000 URL's for each sitemap.

I just changed the "Delay Execution After Each Sitemap File" variable to "0" and it ran just fine. I usually always have this set to 20 but for some reason, setting it back to 0 worked great. Go figure.

Thanks.

Great! . Don't forget to only include forumdisplay, showthread, CMS and blogs pages (if apply) within your sitemaps.

Best regards.

"mysql gone away" errors refer to the wait_timeout setting in /etc/my.cnf I would suggest a setting of around 180, and play with it up or down from there to match your server speeds and site needs.