Forum .LRN Q&A: Error trying to install assessment

Collapse
1: Error trying to install assessment
Posted by Eduardo Santos on 03/09/07 10:41 PM
I tried to install assessment in dotlrn-2.2.1 and acs-core 5.2.3 and I got this error:

apm_package_install: Error installing Assessment version 0.22d2: psql:upgrade-0.17-0.18.sql:3: ERROR: cannot drop view as_assessmentsi because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
psql:upgrade-0.17-0.18.sql:8: ERROR: cannot drop table as_assessments column entry_page_old because other objects depend on
it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
psql:upgrade-0.17-0.18.sql:13: ERROR: cannot drop table as_assessments column exit_page_old because other objects depend on
it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
psql:upgrade-0.17-0.18.sql:18: ERROR: cannot drop table as_assessments column return_url_old because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
CONTEXT: SQL statement "drop view as_assessmentsi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform

psql:upgrade-0.17-0.18.sql:3: ERROR: cannot drop view as_assessmentsi because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
psql:upgrade-0.17-0.18.sql:8: ERROR: cannot drop table as_assessments column entry_page_old because other objects depend on
it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
psql:upgrade-0.17-0.18.sql:13: ERROR: cannot drop table as_assessments column exit_page_old because other objects depend on
it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
psql:upgrade-0.17-0.18.sql:18: ERROR: cannot drop table as_assessments column return_url_old because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
CONTEXT: SQL statement "drop view as_assessmentsi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform

invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
(procedure "apm_package_install_data_model" line 32)
invoked from within
"apm_package_install_data_model -callback $callback -data_model_files $data_model_files $spec_file_path"
invoked from within
"if { $load_data_model_p } {
apm_package_install_data_model -callback $callback -data_model_files $data_model_files $spec_file_path
..."
("uplevel" body line 53)
invoked from within
"uplevel $body "

It seems like it's trying to drop the content repository view, but it's not working. Doas anybody have a clue?