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

VB Seo clarification / manual?

This is a discussion on VB Seo clarification / manual? within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; Hey there, I installed VB Google/Yahoo Sitemap add-on last week. I am looking in my data directory and see sitemap_xxx.xml.gz ...

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 12-04-2006, 10:40 AM
Junior Member
 
Real Name: Deron
Join Date: Oct 2006
Posts: 23
Send a message via ICQ to CreationNation Send a message via AIM to CreationNation Send a message via MSN to CreationNation Send a message via Yahoo to CreationNation Send a message via Skype™ to CreationNation
VB Seo clarification / manual?

Hey there,

I installed VB Google/Yahoo Sitemap add-on last week. I am looking in my data directory and see sitemap_xxx.xml.gz files (over 500 of them @ 20,000 per file setting). I don't know that this finished though? All the files are dated 11/29. I only see a progress.dat file, no download.dat like I have seen mentioned in various threads here.

So I guess my question is, how do I know if this sitemap completely finished or not? Also, I am trying to set up the URL in Google Sitemap but it 404s me, I am assuming because the "sitemap_index.xml.gz" files doesn't exist because the sitemap process possibly never finished?

Any guidance appreciated.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 12-04-2006, 12:28 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
Hello Deron,

you should see the list of all successfull sitemap generations in vbseo_sitemap/ interface. You could also manually execute generator there and see if it finished successfully.
__________________
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
  #3  
Old 12-04-2006, 12:30 PM
Junior Member
 
Real Name: Deron
Join Date: Oct 2006
Posts: 23
Send a message via ICQ to CreationNation Send a message via AIM to CreationNation Send a message via MSN to CreationNation Send a message via Yahoo to CreationNation Send a message via Skype™ to CreationNation
Ok I tried to manually execute it and got this:

[SECTION START] polls [458,837s (+454,168s)]
[addon module] vbseo_sm_downloads.php [458,843s (+5s)]
Database error The Ultimate Metal Forum database has encountered a problem.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 12-04-2006, 12:41 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
You should remove vbseo_sm_downloads.php from your addons list in vBSEO Sitemap generator options as it seems to cause db error.
__________________
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
  #5  
Old 12-04-2006, 01:02 PM
Junior Member
 
Real Name: Deron
Join Date: Oct 2006
Posts: 23
Send a message via ICQ to CreationNation Send a message via AIM to CreationNation Send a message via MSN to CreationNation Send a message via Yahoo to CreationNation Send a message via Skype™ to CreationNation
A quick update in case this changes your answer (not sure if it is related):

Quote:
Invalid SQL:
SELECT id,name FROM file_cats ORDER BY `order`;

MySQL Error : Table 'myforum_forum.file_cats' doesn't exist
Error Number : 1146
Date : Monday, December 4th 2006 @ 10:27:32 AM
Script : http://www.path_to/vbseo_sitemap.php
Referrer : http://path_to/vbseo_sitemap/index.php?rlist=true
IP Address : 71.114.45.88
Username : Unregistered
Classname : vb_database
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 12-04-2006, 01:04 PM
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
The file_cats table is part of the "Downloads" hack.
__________________
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
  #7  
Old 12-04-2006, 01:04 PM
Junior Member
 
Real Name: Deron
Join Date: Oct 2006
Posts: 23
Send a message via ICQ to CreationNation Send a message via AIM to CreationNation Send a message via MSN to CreationNation Send a message via Yahoo to CreationNation Send a message via Skype™ to CreationNation
I removed vbseo_sm_downloads.php (from admincp options) and tried to re-run it and got the same error.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 12-04-2006, 02:03 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
Please also try to remove vbseo_sm_downloads.php file from addons folder.
__________________
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
  #9  
Old 12-04-2006, 02:16 PM
Junior Member
 
Real Name: Deron
Join Date: Oct 2006
Posts: 23
Send a message via ICQ to CreationNation Send a message via AIM to CreationNation Send a message via MSN to CreationNation Send a message via Yahoo to CreationNation Send a message via Skype™ to CreationNation
Now I get the same message for the other addon:

[SECTION START] polls [465,170s (+460,500s)]
[addon module] vbseo_sm_vba.php [465,175s (+6s)]

What exactly do these specific addons do?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #10  
Old 12-04-2006, 02:31 PM
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
That one is for vBadvanced CMPS. If you're not running CMPS, remove that file as well.
__________________
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
  #11  
Old 12-04-2006, 02:41 PM
Junior Member
 
Real Name: Deron
Join Date: Oct 2006
Posts: 23
Send a message via ICQ to CreationNation Send a message via AIM to CreationNation Send a message via MSN to CreationNation Send a message via Yahoo to CreationNation Send a message via Skype™ to CreationNation
Thanks you kind sirs, all fixed!
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
SEO Software Joe Ward General Discussion 26 12-02-2008 09:41 AM
vB SEO performance hit bjornstrom General Discussion 7 05-28-2006 05:35 PM
the archives SEO acers General Discussion 11 07-29-2005 02:18 AM


All times are GMT -4. The time now is 09:45 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.