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?

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 


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...

Did you regenerate sitemap?

Originally Posted by Oleg Ignatiuk

Did you regenerate sitemap?

Yes, I even tried deleting the old sitemap & then regenerating...

The same for me!

The easieast way would be to delete them, but how?

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 


Originally Posted by Oleg Ignatiuk

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!

Great!

I did it.

Thank you for your help.