Changing the Select Search Implementation from DB Search to Sphinx Search

[fodbrothers]

Select Search Implementation
from
DB Search
to
Sphinx Search

so when I select Sphinx Search and click go the website goes down but still able to access the admin cp
so I go to
maintenance / general update tools
and Rebuild Search Index
hoping this would sort the website out.
but the website is still down and has the following
A System Error has occured.
The software is experiencing a systems error.

You should attempt to repeat your last action. If this error occurs again, please contact the site administrator.

many help would be grateful

[noypiscripter]

<a href="http://vbmods.rocks/blogs/vbulletin-5-tips-and-tricks/532-how-to-enable-debug-mode-in-vbulletin-5-for-selected-ip-addresses-only" target="_blank">Enable debug mode</a> to see the detailed error message.

[Paul M]

Most likely your connection to Sphinx is failing, the site will fall over if it does as vB5 relies on search working.

[fodbrothers]

this is what I get when I enable debug



Error :API Error
Controller: search
Method: getInitialResults
Error(s):
array (
0 =>
array (
0 => 'sphinx_not_configured',
),
1 =>
array (
0 => 'exception_trace',
1 => '## /volume2/web/films.hopto.org/core/packages/vbsphinxsearch/core.php(78) Exception Thrown
#0 /volume2/web/films.hopto.org/core/packages/vbsphinxsearch/core.php(63): vBSphinxSearch_Core->connect(Array)
#1 /volume2/web/films.hopto.org/core/vb/search/core.php(33): vBSphinxSearch_Core->__construct()
#2 /volume2/web/films.hopto.org/core/vb/api/search.php(115): vB_Search_Core::instance()
#3 /volume2/web/films.hopto.org/core/vb/api/search.php(215): vB_Api_Search->getSearchResult(\'{"channel":"2",...\', 0)
#4 [internal function]: vB_Api_Search->getInitialResults(Array, \'999\', \'1\', \'0\')
#5 /volume2/web/films.hopto.org/core/vb/api/wrapper.php(129): call_user_func_array(Array, Array)
#6 [internal function]: vB_Api_Wrapper->__call(\'getInitialResul...\', Array)
#7 [internal function]: vB_Api_Wrapper->getInitialResults(Array, \'999\', \'1\', \'0\')
#8 /volume2/web/films.hopto.org/includes/api/interface/collapsed.php(198): call_user_func_array(Array, Array)
#9 /volume2/web/films.hopto.org/includes/vb5/template/runtime.php(506): Api_Interface_Collapsed->callApi(\'search\', \'getInitialResul...\', Array, false, true)
#10 /volume2/web/films.hopto.org/includes/vb5/template.php(324) : eval()\'d code(138): vB5_Template_Runtime::parseData(\'search\', \'getInitialResul...\', Array, \'999\', \'1\', \'0\')
#11 /volume2/web/films.hopto.org/includes/vb5/template.php(324): eval()
#12 /volume2/web/films.hopto.org/includes/vb5/template/cache.php(134): vB5_Template->render(false)
#13 /volume2/web/films.hopto.org/includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'\\r\\n\\t\\r\\n\\t\\r\\n\\t\ \r\\n\\t\\r\\n\\t...\')
#14 /volume2/web/films.hopto.org/includes/vb5/template/cache.php(134): vB5_Template->render(false)
#15 /volume2/web/films.hopto.org/includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'<!-- ##template...\')
#16 /volume2/web/films.hopto.org/includes/vb5/frontend/controller/page.php(245): vB5_Template->render()
#17 [internal function]: vB5_Frontend_Controller_Page->index(1, \'1\', \'1\', \'Home Descriptio...\', 0, \'\', \'Home\', 0)
#18 /volume2/web/films.hopto.org/index.php(84): call_user_func_array(Array, Array)
#19 {main}',
),
)

on line 510 in /volume2/web/films.hopto.org/includes/vb5/template/runtime.php
Step 0: showErrorPage() called on line 219 in /volume2/web/films.hopto.org/includes/vb5/applicationabstract.php
Step 1: handleException() called
Exception API Error
Controller: search
Method: getInitialResults
Error(s):
array (
0 =>
array (
0 => 'sphinx_not_configured',
),
1 =>
array (
0 => 'exception_trace',
1 => '## /volume2/web/films.hopto.org/core/packages/vbsphinxsearch/core.php(78) Exception Thrown
#0 /volume2/web/films.hopto.org/core/packages/vbsphinxsearch/core.php(63): vBSphinxSearch_Core->connect(Array)
#1 /volume2/web/films.hopto.org/core/vb/search/core.php(33): vBSphinxSearch_Core->__construct()
#2 /volume2/web/films.hopto.org/core/vb/api/search.php(115): vB_Search_Core::instance()
#3 /volume2/web/films.hopto.org/core/vb/api/search.php(215): vB_Api_Search->getSearchResult(\'{"channel":"2",...\', 0)
#4 [internal function]: vB_Api_Search->getInitialResults(Array, \'999\', \'1\', \'0\')
#5 /volume2/web/films.hopto.org/core/vb/api/wrapper.php(129): call_user_func_array(Array, Array)
#6 [internal function]: vB_Api_Wrapper->__call(\'getInitialResul...\', Array)
#7 [internal function]: vB_Api_Wrapper->getInitialResults(Array, \'999\', \'1\', \'0\')
#8 /volume2/web/films.hopto.org/includes/api/interface/collapsed.php(198): call_user_func_array(Array, Array)
#9 /volume2/web/films.hopto.org/includes/vb5/template/runtime.php(506): Api_Interface_Collapsed->callApi(\'search\', \'getInitialResul...\', Array, false, true)
#10 /volume2/web/films.hopto.org/includes/vb5/template.php(324) : eval()\'d code(138): vB5_Template_Runtime::parseData(\'search\', \'getInitialResul...\', Array, \'999\', \'1\', \'0\')
#11 /volume2/web/films.hopto.org/includes/vb5/template.php(324): eval()
#12 /volume2/web/films.hopto.org/includes/vb5/template/cache.php(134): vB5_Template->render(false)
#13 /volume2/web/films.hopto.org/includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'\\r\\n\\t\\r\\n\\t\\r\\n\\t\ \r\\n\\t\\r\\n\\t...\')
#14 /volume2/web/films.hopto.org/includes/vb5/template/cache.php(134): vB5_Template->render(false)
#15 /volume2/web/films.hopto.org/includes/vb5/template.php(346): vB5_Template_Cache->replacePlaceholders(\'<!-- ##template...\')
#16 /volume2/web/films.hopto.org/includes/vb5/applicationabstract.php(406): vB5_Template->render()
#17 /volume2/web/films.hopto.org/includes/vb5/applicationabstract.php(219): vB5_ApplicationAbstract::showErrorPage(Array, false)
#18 [internal function]: vB5_ApplicationAbstract::handleException(Object(vB 5_Exception_Api))
#19 {main}',
),
)

on line 510 in /volume2/web/films.hopto.org/includes/vb5/template/runtime.php

[Paul M]

There is your problem.
0 => 'sphinx_not_configured',

You cannot just switch to sphinx, you must set up a working [configured] Sphinx service, and then configure vbulletin to connect to it, and use it.

[fodbrothers]

ok I must be understanding this totally wrong.
why dont I start by telling you the problem that I have
ok so I have lots of threads and I have one called "21 jump street - tt1232829"
this is the exact name
yes it is a film website lol

if I search for 21 jump street
i get 0 results
if I search for tt1232829
i get the 1 result which is the correct thread
basically I want to be able to get better results from the search engine in vb

I have found that if i remove 21 and just search jump street.
It finds the results

Is there something wrong with adding a number to the search

[fodbrothers]

BUMP

[fodbrothers]

BUMP

please can some one help me with this

[fodbrothers]

BUMP

[noypiscripter]

Did you configure Sphinx?

[fodbrothers]

no I didnt as I dont know how so I have left it on DB Search
but really annoyed with the 21 jump street search
If i changed it to sphinx
would this solve the problem and if so could you show me how to configure this

[noypiscripter]

<a href="https://www.vbulletin.com/docs/html/main/acp_searchtype_sphinx_linux" target="_blank">https://www.vbulletin.com/docs/html/...e_sphinx_linux</a>

[IggyP]

i wonder is it an issue of disallowed 2 character search?

i believe you need to manually enter "2 character search terms"(or any less than 3) in admincp for the search to return a result...

i didnt think sphinx excluded that rule, am i mistaken?

[fodbrothers]

I am using a synology box so I guess it would be different to linux

and I have changed the minimum search to 1 letter