Paste number 63471: miker_, db changes needed on the acq box?

Paste number 63471: miker_, db changes needed on the acq box?
Pasted by: berick
When:11 months, 3 weeks ago
Share:Tweet this! | http://paste.lisp.org/+1CZ3
Channel:#openils-evergreen
Paste contents:
Raw Source | XML | Display As
Exception: OpenSRF::EX::ERROR 2008-07-09T17:25:14 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2008-07-09T17:25:14 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 <500>   *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1215638714.3328510561.7862080606], thread trace [1]:
DBD::Pg::st execute failed: ERROR:  function search.staged_fts(integer, integer, text, integer[], integer[], text[], text[], text[], text[], text[], text[], text[], text, real, text, boolean, boolean, boolean, integer, integer, integer) does not exist
LINE 2:           FROM  search.staged_fts(
                        ^
HINT:  No function matches the given name and argument types. You may need to add explicit type casts. [for Statement "        SELECT  *
          FROM  search.staged_fts(
                    1::INT,
                    0::INT,
                    $${"keyword":{"fts_query":["to_tsquery('keyword','water&around')"],"word":["water","around"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','water&around'))"],"phrase":[]}}$$::TEXT,
                    $${}$$::INT[],
                    $${}$$::INT[],
                    $${}$$::TEXT[],
                    $${}$$::TEXT[],
                    $${}$$::TEXT[],
                    $${}$$::TEXT[],
                    $${}$$::TEXT[],
                    $${}$$::TEXT[],

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.