Forum OpenACS Q&A: Error installing photo album

Collapse
1: Error installing photo album
Posted by Luis Garcia on 09/09/07 11:09 PM
I got this error installing photo album. I installed OpenACS 5.3.2, PostgreSQL 8.0 and AOLServer 4.5

[09/Sep/2007:03:59:32][444.3070958496][-conn:0-] Error: apm_package_install: Error installing Photo Album version 5.2.3: CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_type" line 54 at perform
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval from dual"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
PL/pgSQL function "content_type__create_attribute" line 36 at assignment
CONTEXT: SQL statement "drop view pa_albumsi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_albumsi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_type" line 54 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
psql:pl-pgsql.sql:263: ERROR: syntax error at or near "album_id" at character 450
psql:pl-pgsql.sql:263: LINE 13: ...n album must be empty before it can be deleted.'', album_id;
psql:pl-pgsql.sql:263: ^[09/Sep/2007:03:59:32][444.3070958496][-conn:0-] Error: apm_package_install: Error installing Photo Album version 5.2.3: CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_type" line 54 at perform
CONTEXT: SQL statement "SELECT acs_attribute_id_seq.nextval from dual"
PL/pgSQL function "acs_attribute__create_attribute" line 28 at select into variables
PL/pgSQL function "content_type__create_attribute" line 36 at assignment
CONTEXT: SQL statement "drop view pa_albumsi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_albumsi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_type" line 54 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "drop view pa_photosi CASCADE"
PL/pgSQL function "content_type__refresh_view" line 38 at execute statement
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
CONTEXT: SQL statement "SELECT content_type__refresh_trigger( $1 )"
PL/pgSQL function "content_type__refresh_view" line 95 at perform
SQL statement "SELECT content_type__refresh_view( $1 )"
PL/pgSQL function "content_type__create_attribute" line 52 at perform
psql:pl-pgsql.sql:263: ERROR: syntax error at or near "album_id" at character 450
psql:pl-pgsql.sql:263: LINE 13: ...n album must be empty before it can be deleted.'', album_id;
psql:pl-pgsql.sql:263: ^

Collapse
2: Re: Error installing photo album (response to 1)
Posted by Luis Garcia on 09/12/07 05:49 AM
Hi,
Anyone has any idea about this?
Thanks!