Forum OpenACS Development: Re: Upgrade Notes from 5.4.3 to 5.5.0

Collapse
Posted by Ryan Gallimore on
I was upgrading from 5.4.3 to 5.5.0 and encountered this error:

Installing data model for Reference Data - Timezone 5.5.0...

* Loading data model c:/aolserver/servers/openacs/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql...

CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

Failed to install Reference Data - Timezone, version 5.5.0. The following error was generated:

psql:ref-timezones-create.sql:59:
ERROR: relation "timezone_seq" already exists

psql:ref-timezones-create.sql:70: ERROR: relation "timezones" already exists

psql:ref-timezones-create.sql:80: ERROR: duplicate key violates unique constraint "arr_table_name_un" CONTEXT: SQL statement "INSERT INTO acs_reference_repositories (repository_id,table_name,internal_data_p, last_update,package_name,source, source_url,effective_date,expiry_date, maintainer_id,lob) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 )" PL/pgSQL function "acs_reference__new" line 66 at SQL statement PL/pgSQL function "acs_reference__new" line 9 at return

psql:ref-timezones-create.sql:103: ERROR: relation "timezone_rules" already exists psql:ref-timezones-create.sql:105: ERROR: relation "timezone_rules_idx1" already exists

psql:ref-timezones-create.sql:106: ERROR: relation "timezone_rules_idx2" already exists

Collapse
Posted by Don Baccus on
Well it was trying to *install* not *upgrade* the package.

Why did it not think the package was installed?