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

Vbseo Sitemap Generator gives error.

This is a discussion on Vbseo Sitemap Generator gives error. within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; I am manually trying to run the sitemap generator and it gives a database error after following: Code: [homepage] [5,834.1Kb ...

Go Back   vBulletin SEO Forums > vBSEO Google/Yahoo Sitemap > Troubleshooting

Enhancing 80 million pages.

Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read
  #1  
Old 07-21-2008, 11:14 AM
Senior Member
Big Board Administrator
 
Real Name: Future
Join Date: Mar 2006
Posts: 440
Vbseo Sitemap Generator gives error.

I am manually trying to run the sitemap generator and it gives a database error after following:

Code:
[homepage] [5,834.1Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [5,834.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 81, total threads: 0, pages: 1 [5,834.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 70, total threads: 0, pages: 1 [5,844.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 144, total threads: 0, pages: 1 [5,846.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 129, total threads: 474, pages: 16 [5,848.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 95, total threads: 185, pages: 7 [5,864.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 96, total threads: 48, pages: 2 [5,873.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 106, total threads: 66, pages: 3 [5,878.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 89, total threads: 34, pages: 2 [5,883.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 145, total threads: 0, pages: 1 [5,888.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 118, total threads: 107, pages: 4 [5,892.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 119, total threads: 246, pages: 9 [5,898.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 120, total threads: 92, pages: 4 [5,917.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 121, total threads: 68, pages: 3 [5,930.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 122, total threads: 46, pages: 2 [5,940.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 146, total threads: 0, pages: 1 [5,944.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 108, total threads: 280, pages: 10 [5,947.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 109, total threads: 266, pages: 9 [5,961.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 77, total threads: 1457, pages: 49 [5,973.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 110, total threads: 313, pages: 11 [6,023.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 111, total threads: 1786, pages: 60 [6,040.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 112, total threads: 263, pages: 9 [6,100.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 113, total threads: 193, pages: 7 [6,118.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 127, total threads: 789, pages: 27 [6,127.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 84, total threads: 1170, pages: 39 [6,154.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 82, total threads: 218, pages: 8 [6,197.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 147, total threads: 0, pages: 1 [6,213.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 115, total threads: 126, pages: 5 [6,218.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 114, total threads: 116, pages: 4 [6,222.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 116, total threads: 181, pages: 7 [6,228.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 83, total threads: 3557, pages: 119 [6,236.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 117, total threads: 214, pages: 8 [6,358.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 123, total threads: 141, pages: 5 [6,376.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 124, total threads: 154, pages: 6 [6,383.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 125, total threads: 111, pages: 4 [6,390.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 128, total threads: 3565, pages: 119 [6,396.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 73, total threads: 667, pages: 23 [5,991.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 126, total threads: 467, pages: 16 [6,018.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 74, total threads: 227, pages: 8 [6,038.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 148, total threads: 0, pages: 1 [6,050.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 92, total threads: 280, pages: 10 [6,055.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 91, total threads: 652, pages: 22 [6,062.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 76, total threads: 1649, pages: 55 [6,085.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 88, total threads: 305, pages: 11 [6,142.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 93, total threads: 30, pages: 1 [6,163.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 94, total threads: 30, pages: 1 [6,169.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 149, total threads: 0, pages: 1 [6,171.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 79, total threads: 469, pages: 16 [6,174.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 103, total threads: 184, pages: 7 [6,188.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 104, total threads: 196, pages: 7 [6,199.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 105, total threads: 167, pages: 6 [6,208.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 107, total threads: 117, pages: 4 [6,216.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 150, total threads: 0, pages: 1 [6,222.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 99, total threads: 1140, pages: 38 [6,227.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 101, total threads: 54, pages: 2 [6,263.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 100, total threads: 71, pages: 3 [6,275.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 102, total threads: 24, pages: 1 [6,278.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 85, total threads: 933, pages: 32 [6,282.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 87, total threads: 269, pages: 9 [6,311.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 151, total threads: 0, pages: 1 [6,327.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 97, total threads: 32, pages: 2 [6,332.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 98, total threads: 16, pages: 1 [6,335.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 130, total threads: 38, pages: 2 [6,338.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 131, total threads: 24, pages: 1 [6,341.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 75, total threads: 179, pages: 6 [6,344.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 152, total threads: 0, pages: 1 [6,349.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 132, total threads: 4926, pages: 165 [6,355.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 133, total threads: 240, pages: 8 [5,989.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 134, total threads: 236, pages: 8 [5,999.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 135, total threads: 379, pages: 13 [6,011.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 136, total threads: 1332, pages: 45 [6,031.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 137, total threads: 1004, pages: 34 [6,077.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 138, total threads: 798, pages: 27 [6,119.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 139, total threads: 418, pages: 14 [6,155.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 140, total threads: 881, pages: 30 [6,174.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 141, total threads: 592, pages: 20 [6,205.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 142, total threads: 403, pages: 14 [6,231.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 143, total threads: 389, pages: 13 [6,249.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 15, total threads: 0, pages: 1 [6,265.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 146, pages: 5 [6,272.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 198, pages: 7 [6,276.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 297, pages: 10 [6,287.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 24, total threads: 331, pages: 12 [6,299.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 37, total threads: 0, pages: 1 [6,314.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 38, total threads: 2987, pages: 100 [6,320.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 40, total threads: 3167, pages: 106 [6,419.6Kb mem used] [1s (+1s)]
[forumdisplay] forum_id: 42, total threads: 1264, pages: 43 [6,537.1Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 39, total threads: 237, pages: 8 [6,041.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 41, total threads: 561, pages: 19 [6,061.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 6, total threads: 0, pages: 1 [6,081.2Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 14, total threads: 236, pages: 8 [6,085.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 11, total threads: 327, pages: 11 [6,094.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 46, total threads: 2761, pages: 93 [6,109.9Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 10, total threads: 415, pages: 14 [6,212.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 54, total threads: 98, pages: 4 [6,234.1Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 30, total threads: 0, pages: 1 [6,242.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 32, total threads: 3166, pages: 106 [6,245.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 33, total threads: 2559, pages: 86 [6,359.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 43, total threads: 2374, pages: 80 [6,456.2Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 34, total threads: 597, pages: 20 [6,545.5Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 31, total threads: 982, pages: 33 [6,571.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 19, total threads: 0, pages: 1 [6,054.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 7, total threads: 506, pages: 17 [6,063.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 20, total threads: 49, pages: 2 [6,084.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 5, total threads: 581, pages: 20 [6,089.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 45, total threads: 30, pages: 1 [6,109.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 68, total threads: 3, pages: 1 [6,115.8Kb mem used] [1s (+0s)]
[SECTION START] showthread [6,118.6Kb mem used] [1s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 49000 [6,064.2Kb mem used] [9s (+8s)]
[create sitemap in text format] part #2 [6,064.2Kb mem used] [9s (+0s)]
[create sitemap file] filename: sitemap_2.xml.gz, number of urls: 49000 [6,066.8Kb mem used] [22s (+13s)]
[create sitemap in text format] part #3 [6,066.8Kb mem used] [22s (+0s)]
[SECTION START] member [6,088.3Kb mem used] [32s (+10s)]
[create sitemap file] filename: sitemap_3.xml.gz, number of urls: 49000 [6,063.1Kb mem used] [34s (+2s)]
[create sitemap in text format] part #4 [6,063.0Kb mem used] [34s (+0s)]
[create sitemap file] filename: sitemap_4.xml.gz, number of urls: 49000 [6,063.6Kb mem used] [44s (+10s)]
[create sitemap in text format] part #5 [6,063.6Kb mem used] [44s (+0s)]
[SECTION START] polls [6,420.9Kb mem used] [53s (+9s)]
Morever even the email of database error is not send to webmaster address.

Last edited by Future; 07-21-2008 at 11:25 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 07-21-2008, 11:18 AM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,277
What is the error?
__________________
Keith Cohen / 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.


My Personal Sites: My Blog | GPS Discussion Forum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 07-21-2008, 12:12 PM
Senior Member
Big Board Administrator
 
Real Name: Future
Join Date: Mar 2006
Posts: 440
Sitemap generator hangs giving a database error same has been send to webmaster email address, but we have not received any email on webmaster email ID.

This was happening when we set following option to YES.
If you have vBSEO, include old urls?

We set the above to NO, and now its working fine, however there are no showthread.php and forumdisplay.php urls in ur sitemap now is it good better ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 07-21-2008, 01:26 PM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
 
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 5,780
yes, you DONT want those.

turning that on is good for like the first couple weeks of having vbseo installed... but after that, no good.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 07-22-2008, 04:38 AM
Senior Member
Big Board Administrator
 
Real Name: Future
Join Date: Mar 2006
Posts: 440
Thanks but in case we set the above option to YES sitemap generator gets crash.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 07-22-2008, 12:16 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,923
When you have that option enabled there are two times more URLs included in sitemap and probably you have your memory_limit PHP setting exceeded. And as Brian mentioned, you don't need to enable that option.
__________________
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
  #7  
Old 07-26-2008, 04:20 AM
Senior Member
Big Board Administrator
 
Real Name: Future
Join Date: Mar 2006
Posts: 440
Quote:
memory_limit PHP setting exceeded.
We have 8 MB setup for this. But as Brain said including the same for a few weeks shall be helpful hence thought if we can fix the problem.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 07-26-2008, 05:08 AM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
 
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 5,780
8mb is really low.

i run 128
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

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
vBSEO Sitemap Generator ile album sayfalari icin sitemap olusturma ABDALWAHID Türkçe 9 12-26-2008 03:40 PM
Running sitemap generator gives database error T2DMan Troubleshooting 2 07-01-2008 09:39 AM
Received error when running sitemap generator POLiSH General Discussion 6 06-15-2008 08:22 PM
sitemap 2.1 Generator DB Error! Fragmaster Troubleshooting 2 05-13-2008 01:36 AM
Run Sitemap Generator error Cos Troubleshooting 2 07-22-2007 04:17 PM


All times are GMT -4. The time now is 10:35 PM.


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