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

Deleted Posts In Sitemap...

This is a discussion on Deleted Posts In Sitemap... within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; I've noticed that there are posts which have been soft deleted that are showing up in our sitemap... These posts ...

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

Deleted Posts In Sitemap... Deleted Posts In Sitemap...

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-30-2008, 09:27 PM
Junior Member
  
Real Name: Craig
Join Date: Aug 2006
Posts: 9
Deleted Posts In Sitemap...
I've noticed that there are posts which have been soft deleted that are showing up in our sitemap... These posts are in public forums and in open threads...

I did a search on the forums, but was unable to turn anything up, does anyone have any ideas?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 05-30-2008, 10:13 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,906
Try to modify vbseo_sitemap_functions.php file:
FIND:
PHP Code:
            $getthreads = $db->query("
                SELECT *
                FROM " . TABLE_PREFIX . "thread AS thread 
ADD BELOW:
PHP Code:
                LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread') 
FIND:
PHP Code:
                WHERE forumid = $forumid
                    AND visible = 1 
ADD BELOW:
PHP Code:
                    AND deletionlog.primaryid IS NULL 
__________________
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 05-31-2008, 02:10 AM
Junior Member
  
Real Name: Craig
Join Date: Aug 2006
Posts: 9
I now have this (starting at line 253):
PHP Code:
            $getthreads = $db->query("
                SELECT *
                FROM " . TABLE_PREFIX . "thread AS thread
                LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')  
                WHERE forumid = $forumid
                    AND visible = 1
                    AND deletionlog.primaryid IS NULL
                LIMIT ".intval($vbseo_progress['step3']).",".$st['cnt']."
            "); 
However, It does not seam to have helped. I can still find soft deleted posts in my site maps...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 05-31-2008, 04:40 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,906
Did you regenerate sitemap?
__________________
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 05-31-2008, 10:42 PM
Junior Member
  
Real Name: Craig
Join Date: Aug 2006
Posts: 9
Quote:
Originally Posted by Oleg Ignatiuk View Post
Did you regenerate sitemap?
Yes, I even tried deleting the old sitemap & then regenerating...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 06-01-2008, 03:43 AM
Ky! Ky! is offline
Member
  
Real Name: KK
Join Date: Nov 2007
Location: Germany
Posts: 64
The same for me!

The easieast way would be to delete them, but how?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #7  
Old 06-01-2008, 11:59 AM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,906
Do you mean showpost URLs (not showthread)? Please also find this in vbseo_sitemap_functions.php file:
PHP Code:
WHERE p.threadid = $threadrow[threadid] 
add below:
PHP Code:
AND visible = 1 
__________________
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 06-01-2008, 03:14 PM
Junior Member
  
Real Name: Craig
Join Date: Aug 2006
Posts: 9
Quote:
Originally Posted by Oleg Ignatiuk View Post
Do you mean showpost URLs (not showthread)? Please also find this in vbseo_sitemap_functions.php file:
PHP Code:
WHERE p.threadid = $threadrow[threadid] 
add below:
PHP Code:
AND visible = 1 
That appears to have worked!

Thank you!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 06-01-2008, 03:33 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
  
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,906
Great!
__________________
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
  #10  
Old 06-01-2008, 05:37 PM
Ky! Ky! is offline
Member
  
Real Name: KK
Join Date: Nov 2007
Location: Germany
Posts: 64
I did it.

Thank you for your help.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply

« Point of view of sitemap script | Sitemap runs forever! »
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
Is there a disadvantage with including posts in sitemap? zatzy General Discussion 1 05-23-2008 11:26 AM
Single Posts in sitemap or not? etc vissa General Discussion 1 02-09-2006 07:49 PM
vbseo sitemap: should I index posts? archimedes General Discussion 5 11-14-2005 02:21 AM
Deleted Posts Blaminator Bug Reporting 11 10-12-2005 11:49 AM


All times are GMT -4. The time now is 02:16 PM.

Contact Us - vBSEO Home - Site Map - Top

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.