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


	The Toolkit for Online Communities 15889 Community Members, 2 members online, 1831 visitors today			Log In	Register

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

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

Back to OpenACS Q&A

Icon of Envelope Request notifications

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.

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.

Back to OpenACS Q&A