Sphinx Search

[ALanJay]

Noticed recently that if you want search on any punctuation the default settings only include in the index letters if you change in your sphinx.conf

charset_type = sbcs
charset_table = 0..9, A..Z->a..z, +, &, _, a..z

it will search on letters / numbers + & _ obviously you can add other characters if you want to search on them.

[LauraS]

Running into a problem with sphinx in terms of getting statistics for users. Whenever I try to click on Find all posts by username or Find all threads started by username in the statistics section for a user I always get the following message back:

1. Sorry - no matches. Please try some different terms. %1$s

Any of you guys have any ideas? I know for a face there are threads/posts for the user I'm analyzing. Almost looks like something isn't being escaped out in the sphinx code. I installed sphinx using the plugin method with search_sphinx.php file. Normal search on site seems to work. It's just seems messed up when trying to analyze user stats.

Running vbulletin 3.7.3 and sphinx 0.9.8.1.

My output when I run all the indexing:

indexing index 'post'...
collected 27212 docs, 22.0 MB
sorted 3.0 Mhits, 100.0% done
total 27212 docs, 22008013 bytes
total 4.702 sec, 4680607.00 bytes/sec, 5787.38 docs/sec
indexing index 'postdelta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec
indexing index 'thread'...
collected 7214 docs, 0.2 MB
sorted 0.0 Mhits, 100.0% done
total 7214 docs, 195938 bytes
total 0.116 sec, 1687564.25 bytes/sec, 62132.35 docs/sec
indexing index 'threaddelta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec
distributed index 'fulltext' can not be directly indexed; skipping.
distributed index 'threadtitles' can not be directly indexed; skipping.
rotating indices: succesfully sent SIGHUP to searchd (pid=30404).

Danny

[Deriel]

Originally Posted by LauraS

1. Sorry - no matches. Please try some different terms. %1$s

This will sound ridiculous (and it is, but...): I simply upgraded to 0.9.9 and the message is gone

[LauraS]

Originally Posted by Deriel

This will sound ridiculous (and it is, but...): I simply upgraded to 0.9.9 and the message is gone

Thanks Deriel. When it becomes stable we will probably install it.

Danny

[mute]

So.. looks like Jelsoft backed down from supporting Sphinx in 4.0. Frankly I'm pretty disappointed, I honestly don't see how in the past how many years now that we've been running Sphinx that they couldn't at least unofficially support it like they do memcache, etc.

For us it means we've got to wait even longer to even begin thinking about upgrading to 4.0 when it comes out, until someone has a Sphinx implementation that a) doesn't cost thousands, and b) is able to replicate stock functionality more closely than the current one does.

[TechGuy]

That is a huge disappointment. Are they planning on doing something else with search? I mean, they've got to know there's a growing number of big boards!

[mute]

Originally Posted by TechGuy

That is a huge disappointment. Are they planning on doing something else with search? I mean, they've got to know there's a growing number of big boards!

From what I gather, there are "improvements" in the search (front end functionality I assume) on the way for 4.0, but a Sphinx backend won't be even unofficially supported in 4.0.

As I've stated over in the 4.0 discussion thread, I'm pretty flabberghasted that they haven't found the time to bang something out since we started using Sphinx in 2006. I simply can't run a version of vBulletin that does not have a Sphinx enabled search hack available (even if the one I'm currently running is a little wonky).

[Simetrical]

Originally Posted by TechGuy

That is a huge disappointment. Are they planning on doing something else with search? I mean, they've got to know there's a growing number of big boards!

They've said they'll make a search API that should make extensions that support Sphinx (or Lucene, etc.) considerably easier to write.

Originally Posted by mute

As I've stated over in the 4.0 discussion thread, I'm pretty flabberghasted that they haven't found the time to bang something out since we started using Sphinx in 2006.

Don't be. People running large sites are a small percentage of their customer base. They can't weigh our needs too heavily in the scheme of things: they need to focus on the ones who give them the most money.

[Wayne Luke]

Originally Posted by mute

From what I gather, there are "improvements" in the search (front end functionality I assume) on the way for 4.0, but a Sphinx backend won't be even unofficially supported in 4.0.

Its more than "improvements", the entire search architecture is being refactored and rewritten to be more scalable.

[tmc]

Yeah, this basically isn't working for me at all.. It's pretty unfortunate.

Any hope of an update for 3.8?

I get the same problems with User search as the people above, but sorting just doesn't work at all like it should.