[fixed] Deleted threads with polls still appear in search!

[aldamon]

Hi,

For some reason, deleted threads that HAD POLLS are appearing when I search my bulletin board. I have reindexed with no luck.

The reason this came up is that I was practicing using the polls, like five posts in a row, and deleted them each time. Now they all show up in search!

Can anyone shed any light on this?

Thanks!

[klisis]

It's probably becasue of searchindex. As you may know, VB stores a copy of entire thread/posts in a mysql table called "SearchIndex".

Because of that, even if you delete thread A, the thread A may still be in the searchindex table.

To make the seachindex table up to date, you may need to empty your searchindex and rebuilt the index. However, rebuilding searchindex is a resource hog so do it at non-pick time.

[aldamon]

Thanks for the fast reply. I have already cleared and rebuilt the index with no luck.

Only deleted threads that orginally had POLLS ATTACHED are showing up in search.

What could be causing this?

[klisis]

Then I got a feeling that you have to manually clear Poll table.

P.S. I am not sure whether it is a bug or not..

[aldamon]

Can anyone shed any light on this??

[aldamon]

Ed, tubedog ... does anyone know why vB search indexes deleted posts that had polls?

[Mike Sullivan]

It doesn't.

You have to realize we can't just magically say "yeah, that's a bug." Or "no, it's not". You're the first person to have reported this so we have to actually try to reproduce it. If we can't, we have to try all other possibilities. Suffice to say, we haven't checked it out yet.

[aldamon]

Fair enough. I removed the word "bug" from my previous post.

Sorry :(

If you need to see this in action, go here:

http://www.dissolution.com/vbulletin/search.php?

And search for posts for User Name: aldamon

The first 6 posts that come up in the search had test polls and then were deleted.

[Mike Sullivan]

Still couldn't reproduce it, but when searching in posts, I changed the thread table join to a standard equi-join instead of a left join. This should fix it/prevent it from happening.