Forum OpenACS Q&A: Acceptance Test and table user_tables

Collapse
1: Acceptance Test and table user_tables
Posted by Marcus Rowell on 10/03/00 04:54 AM
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
2: Response to Acceptance Test and table user_tables (response to 1)
Posted by Roberto Mello on 10/03/00 05:05 AM
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
3: Response to Acceptance Test and table user_tables (response to 1)
Posted by Marcus Rowell on 10/03/00 05:25 AM
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