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

Collapse
2: Re: File-storage not installed 5.5.1 (response to 1)
Posted by Don Baccus on 10/11/09 02:39 AM
I just tried this and it worked fine.

I'm running PostgreSQL 8.3.1 here, what version are you using?

Also, can you post the full stack trace from the error? I have a guess as to where it's coming from, and if you're running PG 8.3 I might even know why, but I need more details.

Oh, also do you have "add_missing_from = on" in your postgresql.conf file in your [postgresql install location]/data?

Thanks!

Collapse
3: Re: File-storage not installed 5.5.1 (response to 2)
Posted by unuser u on 10/13/09 08:35 AM
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
4: Re: File-storage not installed 5.5.1 (response to 3)
Posted by unuser u on 10/13/09 09:16 AM
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
5: Re: File-storage not installed 5.5.1 (response to 4)
Posted by Don Baccus on 10/17/09 11:41 PM
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
6: Re: File-storage not installed 5.5.1 (response to 5)
Posted by unuser u on 10/27/09 10:51 AM
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