Sphinx Search

[BillP]

I know! I'm just trying to figure out why my (unmodded) site is throwing warnings, and others are not! I've turned off error reporting for now (only in search.php), but don't want to do it forever.

I didn't modify anything, I used orban's main scripts. I will take a look at the others.

[ivanp]

Should be AdminCP/Message Searching Options/Search Result Sharing turned on?

Why is
REPLACE INTO " . TABLE_PREFIX . "search
changed to
INSERT INTO " . TABLE_PREFIX . "search

I've often get 'duplicate entry' mysql error in database log.

--------------- Added [DATE]1213002737[/DATE] at [TIME]1213002737[/TIME] ---------------

Still having finduser issues.

I found that when user is having space in its name, it doesn't return any result.

[ivanp]

There is definitely some problem with finduser on vB 3.7.0.

When disabled Sphinx hooks, everything works fine.

When enabled, it returns significantly smaller result set, completely skipping posts dating Jan-Jun 2008!?

[Cyn]

We are having chronic search issues. We only have 11 million posts but this seems to be a resolution for us.

A couple of questions :

1 - Will the "New Posts" link still produce new posts results based on a member's last visit?

2 - What about searches of private forums? How does Sphinx handle these? We would not want our members and moderators to lose search functions for forums they have access to as a usergroup.

Thanks!

[rebelde]

Originally Posted by ivanp

Should be AdminCP/Message Searching Options/Search Result Sharing turned on?

Why is
REPLACE INTO " . TABLE_PREFIX . "search
changed to
INSERT INTO " . TABLE_PREFIX . "search

I've often get 'duplicate entry' mysql error in database log.

I changed that to "REPLACE" and the database errors have stopped. I'm not sure why it was changed. It doesn't make any sense to me.

Cyn,
All of Sphinx's search results are still filtered through the user permissions, so nobody sees anything that he/she is not supposed to.

[Cyn]

Thanks rebelde.

I assume New Posts works as usual?

[rebelde]

Originally Posted by Cyn

I assume New Posts works as usual?

Yes. You would have seen something somewhere in this thread if it didn't work.

[Cyn]

Excellent. Thanks!

[ALanJay]

Originally Posted by orban

Thanks rebelde, adding prefixes to the full text index is a great idea, I don't know why I haven't considered this. Also re-enabled PMs

Thanks Orban for the update - great work.

Do the current uploaded files include the various suggested modifications that have been made or will I still need to make them?

[wtrk]

i have a question, can sphinx also search other databases and show the results in vbulletin? like for example can i consolidate a search of vbulletin, photopost and reviewpost into a single result displayed in vbulletin with sphinx?