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,