Forum OpenACS Q&A: openacs 4.6 non-core packages ALL fail to mount

Hello All,

I followed the install guide for openacs 4.6 to the letter(on RH8.0 using postgressql 7.2.3).  The install went smoothly, the acs installer pages loaded the core packages and kernel.  I can create users, play with the basic login

But I can't seem to get any non-core packages to load(notes/photo album/mp3 jukebox/etc)- or more specfically I get DB errors.

As an example, here is how i tried to load the notes package:

Load Package:
*Main Site->ACS Package Mnager->Install Packages->Select The 'Notes' checkboxes->Click NEXT.

    The package datamodel, etc load with no errors.

Mount Service:
*Main Site->Site Map->(Main Site) new sub folder
    call the new sub folder 'note'

*From the new 'note' link select 'add application'
    name this 'note-1' and choose the note package from the dropdown menu.

When I then try to go to I get the following error:
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind select nsdb0 {
  select note_id, owner_id, title, body,
        case when acs_permission__permission_p(note_id,:user_id,'write')='t'
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec select $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
    set selection [db_exec select $db $full_statement_name $sql]
        set local_counter 0

    while { [db_getrow $db $selection] } {..."
    (procedure "db_multirow" line 40)
    invoked from within
"db_multirow notes notes {
  select note_id, owner_id, title, body,
    ("uplevel" body line 21)
    invoked from within
"uplevel {
          # main index page for notes.

ad_page_contract {



I'm not sure if I properly added this package, or if there is a bug.

I thought it might have something to do with FTS, so I reinstalled everything minus FTS, and the error persisted unchanged.

Any suggestions or help will be appreciated!

John Major

Posted by Jarkko Laine on
You did remember to restart the aolserver in the middle, didn't you? 😊

Could you as well send the snippet from the error log:

cd /where/your/error/log/is  (/usr/local/aolserver/log/ if you have followed the installation instructions)

tail -f your-server-name-error.log

Then try to reload the page that gives the error.

Posted by John Major on
Hi Jarkko-

Restart aolserver in the middle where?(did i miss something during the package installation?)

The complete output to the error log when the page fails is here:( )
basically the same as the errors displayed on the page.


Posted by John Major on
I figured out what was wrong.... contrary to the package manager GUI- the datamodel FAILED to load.  I went the the package/notes/sql/postgres dir and loaded the datamodel by hand.... presto everything works fine.

The lesson here: don't trust everything the package manager tells you.