Sphinx Search

[jwksite]

Originally Posted by TECK

If it is a community forum for sharing, why they allow here paid services?

Well, for one, they allow REQUESTS for paid services, and those have specific forums you must post in. Coming into this topic and throwing stats around is a sales pitch, and if I had to interpret the Site Rules myself, I would say that's not allowed.

You have every right to try and sell your services, just not on vB.org.

# No posting messages anywhere on this site that are primarily for the promotion or advertising of any website, forums, email address, business, MLM, activity, or other entities that you have an affiliation with (ie. no self-promotion).

Discussion of commercial modifications is permitted on the forums at vBulletin.org as long as they are discussed with no promotion. Any promotional threads will be closed and/or deleted on sight.

1. Promotion of commercial modifications is not allowed.
2. Commercial modification authors are not permitted to create threads regarding their own products or promote their products in any way, shape or form, or to encourage another user to do so.

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

.... And I feel silly for somehow missing the last two pages of posts bashing on TECK. Wasn't trying to bring it back up, sorry! (I really just thought that page 35 was the last page.. haha)

[Simetrical]

Originally Posted by Xorlev

It currently supports non-exact checking. The nice thing about sphinx filters is you can pass it an array.

I'm actually working on it right now. Mostly I just ripped out vBulletin's search completely rather than the conditional "is the query blank or not?" and handling with vB's or Sphinx. Right now I'm working on adding the features sphinx.php lacks from the advanced search as well as all the sorting modes. If it's on the advanced search page, I'll add it.

After that it's most likely sanity checking to make sure it's all working.

Coventry: All we want to do is exclude posts/threads from userids in the list, right?

How's progress on this?

Edit: Actually, I got the instructions from earlier working, hurrah. I haven't seen any problems yet.

[andrewkhunn]

Any update Xorlev? Hoping that something concrete emerges before 3.7 is released into the wild.

[NickCat]

I just set up 0.9.8 on my 3.6.8 forum (nasioc.com) and we have just over 20 million posts. So far the performance increase is night and day. I'm using the sphinx.php from weeno and everything seems to be working well.

There is a results issue I can't quite understand.

I have a max_results of 5000 in my sphinx.conf, and my vbulletin is set to display 2500 results.

When I search a very common word (raw results from search on fulltext are 982507) on my site and display the results as threads, I get about 581 results. If I search the same term and display as posts I get the full 2500 results. I'm presuming this is because it's finding raw posts with my word in it and condensing that 2500 posts by grouping them into the proper threads. Is that correct?

Is there anyway to ask sphinx to actually return 2500 threads instead?

Otherwise things seem to be running quite smoothly... to have gone from searches that were taking upwards of 60 seconds to this is a dream come true. Now it's just a matter of working out the kinks.

Has anyone produced a newer example sphinx.php for 0.9.8 yet?

[mlx]

Originally Posted by NickCat

Is there anyway to ask sphinx to actually return 2500 threads instead?

Yes, there is. You need to group the results by threadid.

https://vborg.vbsupport.ru/showpost....&postcount=430
https://vborg.vbsupport.ru/showpost....&postcount=432

[NickCat]

Originally Posted by mlx

Yes, there is. You need to group the results by threadid.

https://vborg.vbsupport.ru/showpost....&postcount=430
https://vborg.vbsupport.ru/showpost....&postcount=432

Thanks...

I just added this snippet from your file to the one I'm using:

if (!$vbulletin->GPC['showposts'] && $vbulletin->GPC['searchthreadid'] == 0 && $vbulletin->GPC['titleonly'] == 0)
{
    // show results as threads
    $cl->SetGroupBy('threadid', SPH_GROUPBY_ATTR);
    // end show results as threads
}

That's pulling the proper number of results now. How else does that affect the search though since the results it's pulling seem to be much different. I'm comparing the new and old version of the sphinx.php.

And since moving to 0.9.8 from 0.9.7 I'm getting the following warnings when I start searchd:

WARNING: key 'strip_html' is deprecated in /etc/sphinx.conf line 12; use 'html_strip (per-index)' instead.
WARNING: key 'sql_group_column' is deprecated in /etc/sphinx.conf line 28; use 'sql_attr_uint' instead.

sql_group_column looks like I just rename any instances to sql_attr_uint, but strip_html looks like the new command html_strip might want some sort of other variable.

Or does anyone just have an updated 0.9.8 sphinx.conf file to share?

[Kevlar]

Has anybody had any problems with certain users not getting indexed in particualr forums? i.e. I have one user and if you search for his name anywhere on the forum, it works fine, unless you search in one particular forum... and then it comes up blank.

Also... I have an issue where a particular user was indexed up until 2/28/08 ... but then nothing between 2/28/08 and today (3/12/08).

Finally ... is there anyway to search for the term "K&N" ... if I try to search it now it comes up blank.

Thoughts?

[Kevlar]

Originally Posted by TECK

Look at the html code, does it have an ampersand?
I can search fine for "K&N", on my test forums. I can also search with no problems in a specific forum for a specific username.

When I try to search for K&N ... I get sorry, no matches.

In regrads to the username problem... for some reason, that user, in a certain forum just didn't get indexed. If I search for him in any other forum, all his posts show up fine.

Also... a different user for some reason did not get indexed between 2/28/08 and yesterday 3/12/08.

[Marco van Herwaarden]

Thread cleaned from all posts discussing TECK's commercial venture.

[Paul M]

Off topic post also removed, stick to the subject please.