Paste number 63362: Search Error

Paste number 63362: Search Error
Pasted by: gpal
When:11 months, 3 weeks ago
Share:Tweet this! | http://paste.lisp.org/+1CW2
Channel:#openils-evergreen
Paste contents:
Raw Source | XML | Display As
20080707
fm Gpal::

Have been trying to find an online solution for a few days 
before this.
NB:: Have tried resetting the openils_db
rechecked all settings

nb: XML::LibXSLT can't be installed even by force install

!! Could that be the cause ??
---------------------------------------------------------
/openils/var/log/open-ils.search_unix.log
---------------------------------------------------------

received error : service=open-ils.storage : method=open-ils.storage.biblio.multiclass.staged.search_fts.atomic : params=$VAR1 = ['skip_check',0,'depth',0,'searches',{'keyword' => {'term' => 'nalwa'}},'org_unit',1,'limit',1000,'default_class','keyword','visibility_limit',3000,'check_limit',1000,'offset',0];
   * ! EXCEPTION ! *
TYPE: OpenSRF::EX::ERROR
Mess: System ERROR
Mess:   * ! EXCEPTION ! *
Mess: TYPE: OpenSRF::DomainObject::oilsMethodException
Mess: Mess: <500>   *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1215379943.52634527.041624441286], thread trace [1]:
Mess: Mess: DBD::Pg::st execute failed: ERROR:  schema "search" does not exist [for Statement "        SELECT  *
Mess: Mess:           FROM  search.staged_fts(
Mess: Mess:                     1,
Mess: Mess:                     0,
Mess: Mess:                     $${"keyword":{"fts_query":["to_tsquery('keyword','nalwa')"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','nalwa'))"],"phrase":[],"word":["nalwa"]}}$$,
Mess: Mess:                     $${}$$,
Mess: Mess:                     $${}$$,
Mess: Mess:                     $${}$$,
Mess: Mess:                     $${}$$,
Mess: Mess:                     $${}$$,
Mess: Mess:                     $${}$$,
Mess: Mess:                     $${}$$,
Mess: Mess:                     $$$$,
Mess: Mess:                     NULL,
Mess: Mess:                     $$$$,
Mess: Mess:                     'f',
Mess: Mess:                     'f',
Mess: Mess:                     'f',
Mess: Mess:                     NULL,
Mess: Mess:                     1000,
Mess: Mess:                     NULL
Mess: Mess:                 );

This paste has no annotations.

Colorize as:
Show Line Numbers

Lisppaste pastes can be made by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively.