Forum OpenACS Development: Re: File-storage not installed 5.5.1

Collapse
Posted by unuser u on
My postgres version:
8.3 the lenny version, atm i cant reach the server and say you exactly what version is .

I isolated the error, but, you are right, it comes with other stuff like this in a fresh install, some warnings and so:

__________________
[09/Oct/2009:12:45:50][11590.3060661136][-default:4-] Error: apm_package_install: Error installing File Storage version 5.5.0d2: CONTEXT: sentencia SQL: «SPL/pgSQL function "content_type__refresh_view" line 95 at PERFORM
sentencia SQL: «SELECT content_type__refresh_view( $1 )»
PL/pgSQL function "content_type__create_type" line 54 at PERFORM
psql:file-storage-create.sql:90: ERROR: falta una entrada para la tabla «content_template_globals» en la cláusula FROM
LINE 1: SELECT content_template_globals.c_root_folder_id
^
QUERY: SELECT content_template_globals.c_root_folder_id
CONTEXT: PL/pgSQL function "content_template__new" line 15 at assignment
PL/pgSQL function "content_template__new" line 6 at RETURN
PL/pgSQL function "inline_0" line 7 at assignment
psql:file-storage-package-create.sql:756: WARNING: cambiando el tipo de retorno de la función fs_package_items_delete_trig de «opaque» a «trigger»
psql:file-storage-package-create.sql:769: WARNING: cambiando el tipo de retorno de la función fs_root_folder_delete_trig de «opaque» a «trigger»

CONTEXT: sentencia SQL: «SELECT content_type__refresh_trigger( $1 )»
PL/pgSQL function "content_type__refresh_view" line 95 at PERFORM
sentencia SQL: «SELECT content_type__refresh_view( $1 )»
PL/pgSQL function "content_type__create_type" line 54 at PERFORM
psql:file-storage-create.sql:90: ERROR: falta una entrada para la tabla «content_template_globals» en la cláusula FROM
LINE 1: SELECT content_template_globals.c_root_folder_id
^
QUERY: SELECT content_template_globals.c_root_folder_id
CONTEXT: PL/pgSQL function "content_template__new" line 15 at assignment
PL/pgSQL function "content_template__new" line 6 at RETURN
PL/pgSQL function "inline_0" line 7 at assignment
psql:file-storage-package-create.sql:756: WARNING: cambiando el tipo de retorno de la función fs_package_items_delete_trig de «opaque» a «trigger»
psql:file-storage-package-create.sql:769: WARNING: cambiando el tipo de retorno de la función fs_root_folder_delete_trig de «opaque» a «trigger»

____________________________

add_missing_from is set to off

Collapse
Posted by unuser u on
I set add_missing to on, Over a reinstall after using the postgre-sql 'drops' present in the package
It looks like a different error, the drops form the sql do not clean all the data from file storage
At this moment i have the package in semi-install state . It appears but it does not work

______________________________
Error:

Failed to install File Storage, version 5.5.0d2. The following error was generated:

psql:file-storage-create.sql:58: ERROR: llave duplicada viola restricción de unicidad «acs_obj_types_pretty_name_un» CONTEXT: sentencia SQL: «insert into acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )» PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement sentencia SQL: «SELECT acs_object_type__create_type ( $1 , $2 , $3 , $4 , $5 , $6 , null, 'f', null, $7 )» PL/pgSQL function "content_type__create_type" line 41 at PERFORM LINE 1: SELECT content_template_globals.c_root_folder_id ^ QUERY: SELECT content_template_globals.c_root_folder_id CONTEXT: PL/pgSQL function "content_template__new" line 15 at assignment PL/pgSQL function "content_template__new" line 6 at RETURN PL/pgSQL function "inline_0" line 7 at assignment psql:file-storage-create.sql:90: ERROR: llave duplicada viola restricción de unicidad «cr_items_unique_name» CONTEXT: sentencia SQL: «insert into cr_items ( item_id, name, content_type, parent_id, storage_type, storage_area_key ) values ( $1 , $2 , $3 , $4 , $5 , $6 )» PL/pgSQL function "content_item__new" line 97 at SQL statement PL/pgSQL function "content_item__new" line 20 at assignment PL/pgSQL function "content_template__new" line 27 at assignment PL/pgSQL function "content_template__new" line 6 at RETURN PL/pgSQL function "inline_0" line 7 at assignment psql:file-storage-package-create.sql:756: WARNING: cambiando el tipo de retorno de la función fs_package_items_delete_trig de «opaque» a «trigger» psql:file-storage-package-create.sql:769: WARNING: cambiando el tipo de retorno de la función fs_root_folder_delete_trig de «opaque» a «trigge _____________________________________
Collapse
Posted by Don Baccus on
Package dropping scripts tend to be unreliable for many packages, I'm afraid.

My suggestion is to ...

1. Stop AOLserver (if it's currently running)

2. at the shell command line: dropdb your-acs-db;createdb your-acs-db

3. Restart AOLserver

4. You'll see the initial install page for all of OpenACS. Reinstall the core, restart, and try installing file-storage now, on this fresh instance.

Hope this helps!

Collapse
Posted by unuser u on
Hi

That is the easy solution xD
But, yes, it was the only one. I suppose a better understanding of the db could do the job but, as always, time is time.

Is good to know that the sql drops do not work properly in some packages :S

Thanks for your help