Forum OpenACS Q&A: Does load-data-model.sql create all tables?

Collapse
1: Does load-data-model.sql create all tables?
Posted by Lee McKusick on 07/31/00 05:30 AM
I have OpenACS 3.2.2 installed, but attempts at activating modules in
the administrative pages result in errors, like table does not exist,
relation does not exist.

Regarding  load-data-model.sql , is it supposed to create all the
tables for all the modules?

Are the individual .sql files supposed to be executed in psql? Like
by-hand from the command line before using the administrative web
pages?

Thanks for a reply.

Collapse
2: Response to Does load-data-model.sql create all tables? (response to 1)
Posted by Don Baccus on 07/31/00 06:29 PM
This is strictly an RTFM issue, as the installation guide tells you exactly what to do.

In brief...

First you must customize <pageroot>/parameters/ad.tcl and the aolserver nsd.tcl scripts.

You run load-geo-tables in <pageroot>/install next.

Then you run psql -f load-data-model.sql in <pageroot>/doc/sql

Please read, and follow, the installation guide.