Forum OpenACS Q&A: Problem Installing Reference Data - Timezone 0.4

Collapse
1: Problem Installing Reference Data - Timezone 0.4
Posted by Ola Hansson on 10/24/03 05:19 PM
I'm having trouble installing .LRN on PG fresh from HEAD.

Anyone else noticed this? 

#
Installing Reference Data - Timezone 0.4

# Installing data model for Reference Data - Timezone 0.4...

    * Loading data model /web/oacsdev/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 0.4. 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: WARNING: Error occurred while executing PL/pgSQL function acs_reference__new psql:ref-timezones-create.sql:80: WARNING: line 63 at SQL statement psql:ref-timezones-create.sql:80: ERROR: Cannot insert a duplicate key into unique index arr_table_name_uq psql:ref-timezones-create.sql:103: ERROR: Relation 'timezone_rules' already exists psql:ref-timezones-create.sql:105: ERROR: relation named "timezone_rules_idx1" already exists psql:ref-timezones-create.sql:106: ERROR: relation named "timezone_rules_idx2" already exists
Collapse
2: Re: Problem Installing Reference Data - Timezone 0.4 (response to 1)
Posted by Roberto Mello on 10/24/03 05:49 PM
Ola,

I had this problem a few days ago. See this thread: https://openacs.org/forums/message-view?message_id=136133

-Roberto

Collapse
3: Re: Problem Installing Reference Data - Timezone 0.4 (response to 1)
Posted by Ola Hansson on 10/24/03 06:48 PM
Ah, okay. Thanks rbm!

I've noticed before that the ref data couldn't be copied, although it was never a showstopper when installing just OACS.

I tried to install again, this time with "install.xml" in acs_root_dir, and everything that should got installed. That is, it continued on with installing the rest of the packages despite the error. The problem "only" occurs when you follow the current .LRN installation docs ...

So, we actually have a one-click installation already. Cool!

/Ola