Forum OpenACS Q&A: Open ACS Installation error !

Collapse
1: Open ACS Installation error !
Posted by Robert Pohl on 12/12/02 01:22 PM
I get this message trying to install the ACS:

OpenACS Installation: Installing OpenACS Core Services

--------------------------------------------------------------------------------

Failed to install ACS Core Documents, version 4.5. The following error was generated:

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

Package enabled.

Failed to install Skin, version 4.5. The following error was generated:

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

Package enabled.

Completing Install sequence.

CREATE FUNCTION
CREATE FUNCTION
CREATE TABLE
id
----
(0 rows)
UPDATE 0
DROP FUNCTION
DROP FUNCTION
DROP TABLE

Someone know whats up?

/Robert

Collapse
2: Re: Open ACS Installation error ! (response to 1)
Posted by Robert Pohl on 12/12/02 02:00 PM
...I found this in my log:

psql:acs-objects-create.sql:156: ERROR:  Function bitfromint4(integer) does not exist

This "bitfromint4(integer)" seems to cause lots of error.. whis is this? Is it a problem with PostgreSQL 7.3 Version?

Collapse
3: Re: Open ACS Installation error ! (response to 1)
Posted by Dan Wickstrom on 12/12/02 04:16 PM
pg 7.3 renamed some of the functions that we use for tree functions, so it is still necessary to use pg 7.2 with openacs.  There is another thread ongoing where the problems with using pg 7.3 have been pointed out.