Forum OpenACS Q&A: Response to Trying to fix pl-sql.sql/pseudo_contains

Collapse
3: Response to Trying to fix pl-sql.sql/pseudo_contains (response to 1)
Posted by Jim Sims on 10/07/01 01:09 AM
In the browser: Server Error The requested URL cannot be accessed due to a system error on this server. AOLserver/3.2+ad12 on http:...

In /var/log/aolserver/defaultacs.log:

[06/Oct/2001:18:12:07][711.23560][-conn13-] Error: Ns_PgExec: result status: 7 
message: ERROR:  parser: parse error at or near "to"
 
[06/Oct/2001:18:12:07][711.23560][-conn13-] Error: dbinit: error(localhost::acs,ERROR:  
parser: parse error at or near "to"
): 'select p.product_name, p.product_id, p.dirname, 
p.one_line_description,pseudo_contains(p.product_name || p.one_line_description || 
p.detailed_description || p.search_keywords, 'gi vi') as score
    from ec_products_searchable p
    where pseudo_contains(p.product_name || p.one_line_description ||  p.detailed_description || 
p.search_keywords, 'gi vi') > 0
    order by score desc'
[06/Oct/2001:18:12:07][711.23560][-conn13-] Error: Database operation "select" failed 
(exception NSDB, "Query was not a statement returning rows."), etc., etc...