[UK Jimbo]

Originally Posted by Raun

If I were to install it on both DBs would that work the same as copying the indexes?

There are two separate parts of using Sphinx.

• Indexing (building up your index of data from the database)
• Serving results with searchd

If you were able to serve results from either of the two machines then you'd be able to balance some of the load and also handle a failure of one of the instances.

To save processing time it should be quicker to index on one of the two machines and then copy the indexes across. The alternative is to have each of the machines create their own index which will use more processing power.

[Raun]

Sorry for all the noob questions but I am a little new to this.

Once sphinx is installed on the DB and the config is setup how is it hooked into vb to serve the results there? Is that built into the config somewhere? Do I need to install anything else to get the results served?

[abuthabit]

Hello

sphinx installed in our forums and it works fine.. but when you type something that it's not included in the index for example " jkbljkhbjk" We got error as below

FireFox:
Content Encoding Error

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.
* Please contact the website owners to inform them of this problem.

Safari

Safari can’t open the page.
Safari can’t open the page “http://www.****.com/ee/search.php?do=process”. The error is: “cannot decode raw data”

IE8
IE can't display this webpage

No errors in the log: lightty .. Mysql .. sphinx logs

sphinx/query.log :
[Fri Oct 30 01:36:31.808 2009] 0.000 sec [all/0/attr- 0 (0,500)] [threadtitles] jkbljkhbjk

Installation guide from the following post
http://www.vbulletin.org/forum/showp...postcount=3877

How could I fix this issue?

[profanitytalker]

Can someone send me their edited search.php file? Mine won't work. I get confused by the last line of the edit...

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Where do I add the "#"?

[abuthabit]

Originally Posted by profanitytalker

Can someone send me their edited search.php file? Mine won't work. I get confused by the last line of the edit...

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Where do I add the "#"?

This line:
unset($datecut);

add # before unset in the same line

so it should be like this

#unset($datecut);

[cobaku]

This thing is too hard to set up. I have failed on my 10th try again.

ssh search works just fine

but search.php rejects to paste results to web !
i am guessing search_sphinx.php does not work on 3.8.4 which is my only guess

Anyone tried the new method on post #1 on 3.8.4 ? send search_sphinx.php pls.

Vbulletin Sphinx plugin is sold for 2000$

[ATForums]

Hi,

Using this with great success - trying to allow 3 char words. I have changed sphinx to include 3 chars ("wii") and results are returned from the CLI, so Sphinx seems OK.

But, in VB, I always get a no results message when I search for "wii" - I changed the min search size in VB Options to 3, but it doesn't help.

Any ideas?

John

--------------- Added 05 Dec 2009 at 16:01 ---------------

Originally Posted by ATForums

Hi,

Using this with great success - trying to allow 3 char words. I have changed sphinx to include 3 chars ("wii") and results are returned from the CLI, so Sphinx seems OK.

But, in VB, I always get a no results message when I search for "wii" - I changed the min search size in VB Options to 3, but it doesn't help.

Any ideas?

John

Err...stupid me....I needed to restart searchd....did that and now all is well...

Thought all I had to do was rebuild indexes...

John

[RedWingFan]

Sphinx 0.9.9-Stable is now out. I just compiled it on our dedicated box, killed and restarted searchd, and am rebuilding the indexes. So far, so good! I will have to wait until next month to see what new parameters I can work with to optimize it further (I'm under the gun for a paying job right now...gotta take the money while I can!)

[ivanp]

Is there any update for this plugin for vBulletin 4?

[columbusgeek]

Is there any update for this plugin for vBulletin 4?

vB4 has been gold for less the 24 hours now. Are you serious?

[kontrabass]

I'm going to get some guys on this - VB4.0's search is way too slow for our forum of 5M posts. It'll take us some time though, we just started playing around with 4.0 in a test enviro. Floren's commercial sphinx solution (Searchlight) will have 4.0 support in the future as well.

[RedWingFan]

We have close to 4.5 million posts, and even in our private test board with only around 170,000 posts, search drags. I can't see going back to MySQL fulltext search any time soon. (Plus, there are too many other issues with 4.0 that will keep us from upgrading for quite a few months.)

[snakes1100]

Originally Posted by RedWingFan

We have close to 4.5 million posts, and even in our private test board with only around 170,000 posts, search drags. I can't see going back to MySQL fulltext search any time soon. (Plus, there are too many other issues with 4.0 that will keep us from upgrading for quite a few months.)

I'd guess it's those Sheep wondering over from Novi & clogging your server up w/ wool!

[RedWingFan]

Originally Posted by snakes1100

I'd guess it's those Sheep wondering over from Novi & clogging your server up w/ wool!

True dat!



--------------- Added 29 Dec 2009 at 21:32 ---------------

P.S. I'd blame the Steelers, actually--our server is in Pittsburgh. It's just the boneheaded server admin who lives near the Sheep...erm, Whalers, Dead Wings, etc.

[eoc_Jason]

Yeah, but for most of us Searchlight is not very affordable...

I'm still super pissed at Jelsoft for not having any sort of sphinx plug-in / switch for vB 4.0... From all the previous development talk I was led to believe they were going to implement it (finally)...

It's like they don't really care about the big boards... They are implementing all these other crazy features that maybe 0.2% of people *might* use, but not taking a hard look at the core of their product... *sigh*

I'm about to install vB 4.0 on my test server. At the very least I'm going to try and code sphinx for the basic search stuff. To standardize things I'm going to try and code it with the PECL::Sphinx library.