Forum OpenACS Q&A: install ACS content repository 5.9.1d8 failed install on fresh system

Hi,

When installing a fresh openacs oacs-5-9 system on ubuntu 14.04 LTS using scripts at github.com/gustafn/install-ns.git

Server is showing the following error after posting initial startup form:

url: /installer/install

OpenACS Installation
-------
Installing the OpenACS kernel data model...
CREATE VIEW
CREATE SEQUENCE
CREATE VIEW
CREATE FUNCTION
CREATE FUNCTION
...

acs_sc_binding__new
---------------------
0
(1 row)
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
Failed to install ACS Content Repository, version 5.9.1d8. The following error was generated:



psql:content-create.sql:403: ERROR: syntax error at or near "FOREIGN"
LINE 11: FOREIGN KEY (parent_id) REFERENCES acs_...
^
psql:content-create.sql:405: ERROR: relation "cr_child_rels" does not exist
psql:content-create.sql:406: ERROR: relation "cr_child_rels" does not exist
psql:content-create.sql:407: ERROR: relation "cr_child_rels" does not exist
psql:content-create.sql:414: ERROR: relation "cr_child_rels" does not exist
psql:content-create.sql:431: ERROR: syntax error at or near "CONSTRAINT"
LINE 9: CONSTRAINT cr_item_rels_item_id_fk

oacs-5-9/log/error.log reports this as first error also.

cheers,

Hi Ben,

we are just in the progress of a series of cleanup/performance improvements of the content repository, which we have tested so far just for the upgrade scripts (the latest version runs on openacs.org) and not jet for fresh installs. I have fixed the problems above.

Actually, the default for fresh installs in install-oacs.sh should be the released tar versions, and not the CVS version. I've changed this in the install scripts on github as well.

many thanks
-g

Okay, thank you, Gustaf. I'm really impressed at all the activity that continues to evolve OpenACS.
best wishes,
Ben