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
stuff(www.glassjelly.com)....
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 www.glassjelly.com/note 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,
decode(acs_permission.permission_p(note_id,
..."
("uplevel" body line 21)
invoked from within
"uplevel {
# main index page for notes.
ad_page_contract {
@author mailto:rhs@mit.edu
----------------------
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
