Page 20 of 20

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Sun May 05, 2013 3:58 pm
by Lumpy Burgertushie
I would suggest installing a test board and testing it out to see.


robert

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Thu May 30, 2013 1:09 am
by kdxrider
For anyone interested, I was able to get this working on shared hosting. I used figvam's fork (THANK YOU!). As long as you have shell access, you can compile and install to your home directory, like so...

Code: Select all

$ wget http://sphinxsearch.com/downloads/accept.php?file=sphinx-2.0.8-release.tar.gz
$ tar -xf sphinx-2.0.8-release.tar.gz
$ cd sphinx-2.0.8-release
$ ./configure --prefix=$home
$ make
$ make install
This will install the files to your home directory. When you make the config/data directories, make sure you know the location so you can input them into the ACP. I had to check in the control panel to get the absolute path to my files. This will vary if you're on shared hosting services. This mod has reduced my CPU usage considerably, and stopped CPU throttling from the hosting provider due to the search function. Nifty! Thanks to everyone in this thread for all the great info!

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Sun Jun 02, 2013 12:56 am
by kdxrider
Anyone still using this? It's quite awesome when it works. My problem has been that the plugin seems to do a poor job of starting/stopping searchd to merge indexes. It gets hung, and search is lost. Re-indexing gets it going again for a while, and then it crashes again. I turned off automatically run sphinx in the ACP, and start the process manually using --config to point it to sphinx.conf. Then a cron job calls indexer every 15 minutes. This so far is the best solution I can come up with to keep it running. However, if searchd crashes, I have no method of re-starting it. Have to check and then issue command manually. I was thinking of putting a --stop and then running indexer and then issuing a start. Indexing only takes a few seconds anyway. The real problem with my solution is the delta index does nothing. So search is not instant, rather it syncs every 15 minutes.

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Thu Jul 25, 2013 1:38 am
by t.sodano
Hello,

I'm attempting to install sphinx full text search using sphinx-for-phpbb (https://github.com/phpbb/sphinx-for-phpbb),

To start the board is running 3.0.11 and I installed sphinx 0.9.8.1 on the server.

I copied over the plugin files:

- root/includes/functions_sphinx.php
* To: includes/functions_sphinx.php
- root/includes/sphinxapi-0.9.8.php
* To: includes/sphinxapi-0.9.8.php
- root/includes/search/fulltext_sphinx.php
* To: includes/search/fulltext_sphinx.php
- root/language/en/mods/fulltext_sphinx.php
* To: language/en/mods/fulltext_sphinx.php

When I login to APC and check 'GENERAL' -> 'SERVER CONFIGURATION' -> 'Search Settings' for the plugin, sphinx is no where to be found.. I've tried many different steps but still can't get it to take.. any ideas? thanks in advanced!

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Thu Jul 25, 2013 4:20 am
by Oyabun1
Do you use British English en in the ACP? If not you will need to copy the language/en/mods/fulltext_sphinx.php file to whichever language you use.

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Thu Jul 25, 2013 4:25 am
by t.sodano
Hey Oyabun1, thanks for the response, current language is set to 'British English' via 'GENERAL' -> 'Board configuration' -> 'Default language' = British English

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Fri Jul 26, 2013 5:47 pm
by t.sodano
Just an update.. I did a default install on another box using phpBB 3.0.11 and did the same steps and uploaded the sphinx plugin files and it works no problem..

On the live server there isn't any heavy modifications, just automod, tapatalk, and a modified rockettheme.. could any of these plugins or theme cause a conflict with sphinx-for-phpbb?

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Fri Jul 26, 2013 9:46 pm
by Oyabun1
Tapatalk seems to cause other problems for some boards, so I would suggest starting there.

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Thu Oct 17, 2013 9:22 pm
by Fisch.666
Hi,

*Edit*
Seems this key is also used in phpBB-3.1-dev so i've reported an bug for this at the bugtracker:

http://tracker.phpbb.com/browse/PHPBB3-11938
*Edit*

just upgraded to the current Sphinx 2.1.2 stable and this API from figvam's fork still works without a problem. However there are now some deprecated warnings in the logfiles:
WARNING: key 'sql_attr_str2ordinal' is deprecated in /etc/sphinxsearch/sphinx.conf line 39; use 'sql_attr_string for sorting' instead.
Line 39 matches this part of the config file:
sql_attr_str2ordinal = post_subject
Don't know if i just can change this line to:
sql_attr_string = post_subject
Anyone familiar with such changes?

Thanks in advance for a reply.

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Posted: Sat Mar 08, 2014 9:42 pm
by Fisch.666
Hi,

seems this is easy to fix. The changes in here should be enough to fix that issue:

https://github.com/phpbb/phpbb/pull/2094/files