Forum OpenACS Q&A: General Comments Error

Collapse
Posted by Roger To on
Hi All,

I've received an error message when i tried to create a comment
within a package i created and tried to attach it to an object. This
occurred in openacs 4.6, however was working fine in 4.5. This is the
error message in the log

NOTICE:  Error occurred while executing PL/pgSQL function
content_search__itrg
NOTICE:  line 2 at assignment
[18/Oct/2002:00:24:05][28422.6151][-conn2-] Error: Ns_PgExec: result
status: 7 message: ERROR:  Function 'search_observer__enqueue(int4,
unknown)' does not exist
        Unable to identify a function that satisfies the given
argument types
        You may need to add explicit typecasts

[18/Oct/2002:00:24:05][28422.6151][-conn2-] Error: dbinit: error
(localhost::t2002u9,ERROR:  Function 'search_observer__enqueue(int4,
unknown)' does not exist
        Unable to identify a function that satisfies the given
argument types
        You may need to add explicit typecasts

......and a bit later

[18/Oct/2002:00:24:05][28422.6151][-conn2-] Notice: RP (132.045 ms):
error in rp_handler: serving POST /General/comment-add-3
        ad_url "/General/comment-add-3" maps to
file "/home/t2002u9/openacs-4/packages/general-comments/www/comment-
add-3.tcl"
errmsg is Transaction aborted: Database operation "0or1row" failed
(exception NSDB, "Query was not a statement returning rows.")

any help would be appreciated.

Thanks in advance

Collapse
Posted by Don Baccus on
What version of PostgreSQL are you running?
Collapse
Posted by Dave Bauer on
We found this on IRC. The search package was not installed.

Maybe we need a check on install to tell that a core package has not been installed.