Home
The Toolkit for Online Communities
15936 Community Members, 0 members online, 2334 visitors today
Log In Register

Forum OpenACS Q&A: Install ACS 4.6 problem

OpenACS Home : Forums : OpenACS Q&A : Install ACS 4.6 problem

Icon of Envelope Request notifications

+
Posted by Nagita Karunaratne on
I followed the instructions for installing Postgres 7.3.2, aol server 3.3+ad13, and ACS 4.6
When I started aolserver and started the OPenACS Installer, it did not completely render the first page. Part if the error.log file (~/web/birdnotes/log/error.log) at the point where aolserver is accepting connections and where errors start is below.

Can anyone give me a hint?

---------------- error.log START -----------------------
... [snip] ...
[14/Feb/2003:01:16:21][2147.8192][-main-] Notice: sched: idle
[14/Feb/2003:01:16:21][2147.8192][-main-] Notice: nssock: listening on 127.0.0.1:8000
[14/Feb/2003:01:16:21][2147.65545][-nssock-] Notice: nssock: starting
[14/Feb/2003:01:16:21][2147.65545][-nssock-] Notice: nssock: accepting connections


[14/Feb/2003:01:17:53][2147.24580][-conn0-] Error: Error sourcing /home/karunnt/web/birdnotes/packages/acs-bootstrap-installer/installer/install-data-model.tcl:
psql:acs-objects-create.sql:156: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:acs-objects-create.sql:156: WARNING:  line 20 at return
psql:acs-objects-create.sql:156: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
psql:acs-relationships-create.sql:299: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:acs-relationships-create.sql:299: WARNING:  line 20 at return
psql:acs-relationships-create.sql:299: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
psql:community-core-create.sql:237: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:community-core-create.sql:237: WARNING:  line 20 at return
psql:community-core-create.sql:237: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
psql:community-core-create.sql:576: ERROR:  acs_obj_type_tbls_obj_type_fk referential integrity violation - key referenced from acs_object_type_tables not found in acs_object_types
psql:groups-create.sql:125: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:groups-create.sql:125: WARNING:  line 20 at return
psql:groups-create.sql:125: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
... [snip] ...
---------------- END -----------------------------------

+
Posted by Cathy Sarisky on
You need Postgres 7.2.3.  Try that - should fix you right up. :)
+
Posted by Bart Teeuwisse on
Cathy,

the current CVS version of OpenACS core does not require PG 7.2.x It also works with PG 7.3.x. However not all packages besides the core support PG 7.3.x yet.

Nagita, it appears that you installed from the OpenACS 4.6 tarball. In that case you will have to use PG 7.2.x as Cathy said.

/Bart