vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Total Support Team Launches DeskPro New vBSEO Discount Level for Network Builders vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

Sitemap Not Running After Site Upgrade

This is a discussion on Sitemap Not Running After Site Upgrade within the Troubleshooting forums, part of the vBSEO SEO Plugin category; Hi - I'm running 2.1 which was working fine. At the weekend, I upgraded Apache, SQL, PHP and vBUlletin (to ...

Go Back   vBulletin SEO Forums > vBSEO SEO Plugin > Troubleshooting

Sitemap Not Running After Site Upgrade Sitemap Not Running After Site Upgrade

Enhancing 80 million pages.

 Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1  
Old 05-09-2008, 04:37 AM
Member
  
Real Name: Mike Warner
Join Date: Feb 2006
Posts: 51
Question 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:

Quote:
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 05-09-2008, 04:40 AM
Member
  
Real Name: Mike Warner
Join Date: Feb 2006
Posts: 51
Sorry - posted in wrong forum, please move. Thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 05-09-2008, 04:57 AM
Member
  
Real Name: Mike Warner
Join Date: Feb 2006
Posts: 51
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:

Quote:
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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 05-09-2008, 05:02 AM
Member
  
Real Name: Mike Warner
Join Date: Feb 2006
Posts: 51
FYI, upgraded php4 to php5 and sql4 to sql5.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 05-09-2008, 08:49 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,616
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.

Quote:
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.
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 05-09-2008, 10:15 AM
Member
  
Real Name: Mike Warner
Join Date: Feb 2006
Posts: 51
wait_timeout is set to 30. What shouild I change it to?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #7  
Old 05-09-2008, 10:26 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,616
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).
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 05-12-2008, 09:11 AM
Member
  
Real Name: Mike Warner
Join Date: Feb 2006
Posts: 51
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 05-12-2008, 03:54 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,616
Great, you are welcome
__________________
Oleg Ignatiuk / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

« All PINGS FAILED | The vBSEO Test Script? »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
error while running vbseo site map gen leanbulk URL Rewrite Settings 2 01-30-2008 11:30 AM
How do I know if my site is running sitemap? RadarReviews_Net vBSEO Reviews 3 11-29-2007 07:04 AM
site running super slow... lafsunlmtd Troubleshooting 5 06-21-2007 07:03 PM
Running site map gen on VB 3.0.8 = blank page vscope Troubleshooting 1 03-22-2006 04:23 PM


All times are GMT -4. The time now is 11:15 PM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.8.0 Release Candidate 1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.