Forum OpenACS Q&A: install ACS content repository 5.9.1d8 failed install on fresh system
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:
Installing the OpenACS kernel data model...
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.
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.