Forum OpenACS Q&A: Acceptance Test and table user_tables

I have downloaded and installed OpenACS 3.2.4 on LinuxPPC
with the PostgreSQL 7.0.2 RPM's.
Following the instructions, with no errors, the acceptance test
fails on the following SQL;

select table_name from user_tables where lower(table_name)
in ('country_codes', 'states', 'counties') ;

because the table doesn't exist?
Is it meant to? or have messed something up along the way?

Thanks Marcus

Collapse
Posted by Roberto Mello on
You are running an Oracle-specific part of the acceptance tests. OpenACS does not have an official Acceptance test suite yet. We have to port ACS' sometime.

Just go into psql and do a "d" which should show you all table, sequences and views. That should be give you some good information showing that everything was loaded. Also, if you redirected your output when loading the datamodel (as described in the docs) you should be able to see if you had any errors righ there.

Collapse
Posted by Marcus Rowell on
Thanks Robert.

I had followed the installation instructions in the documentation
with sucess. I've just had few errors in places much further down
the line (ie /intranet/employees/admin/index.tcl) and was working
through the installation  nice and slowly and this was the first
error I came across. I couldn't find anywhere where the
user_tables were loaded so I posted the question. I guess it is
an Oracle specific table.

Thanks, Marcus