Paste number 62689: I think we need type casts

Index of paste annotations: 1

Paste number 62689: I think we need type casts
Pasted by: dbs
When:1 year, 1 week ago
Share:Tweet this! | http://paste.lisp.org/+1CDD
Channel:#openils-evergreen
Paste contents:
Raw Source | XML | Display As
[2008-06-22 23:15:44] open-ils.search [ERR :9479:EX.pm:66:] Exception: OpenSRF::EX::ERROR 2008-06-22T23:15:44 OpenSRF::Application /openils/lib/perl5/OpenSRF/Application.pm:553 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic 
 failed with exception: Exception: OpenSRF::EX::ERROR 2008-06-22T23:15:44 OpenILS::Application::AppUtils /openils/lib/perl5/OpenILS/Application/AppUtils.pm:177 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2008-06-22T23:15:44 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 <500>   *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1214190944.451186998.16405202038], thread trace [1]:
DBD::Pg::st execute failed: ERROR:  function search.staged_fts(integer, integer, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, unknown, integer, unknown) does not exist
LINE 2:           FROM  search.staged_fts(
                        ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 [for Statement "        SELECT  *
          FROM  search.staged_fts(
                    1,
                    0,
                    $${"keyword":{"fts_query":["to_tsquery('keyword','a')"],"word":["a"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','a'))"],"phrase":[]}}$$,
                    $${}$$,
                    $${}$$,
                    $${}$$,

Annotations for this paste:

Annotation number 1: casts
Pasted by: miker_
When:1 year, 1 week ago
Share:Tweet this! | http://paste.lisp.org/+1CDD#1
Paste contents:
Raw Source | Display As
    my $sth = metabib::metarecord_source_map->db_Main->prepare(<<"    SQL");
        SELECT  *
          FROM  search.staged_fts(
                    $param_search_ou\:\:INT,
                    $param_depth\:\:INT,
                    $param_searches\:\:TEXT,
                    $param_statuses\:\:INT[],
                    $param_locations\:\:INT[],
                    $param_audience\:\:TEXT[],
                    $param_language\:\:TEXT[],
                    $param_lit_form\:\:TEXT[],
                    $param_types\:\:TEXT[],
                    $param_forms\:\:TEXT[],
                    $param_vformats\:\:TEXT[],
                    $param_bib_level\:\:TEXT[],
                    $param_pref_lang\:\:TEXT,
                    $param_pref_lang_multiplier\:\:REAL,
                    $param_sort\:\:TEXT,
                    $param_sort_desc\:\:BOOL,
                    $metarecord\:\:BOOL,
                    $staff\:\:BOOL,
                    $param_rel_limit\:\:INT,
                    $param_chk_limit\:\:INT,
                    $param_skip_chk\:\:INT
                );
    SQL

Colorize as:
Show Line Numbers
Index of paste annotations: 1

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