Forum OpenACS Development: Re: OpenACS 5.9.0: journal_article and Edit This Page

Hi Frank,

where is the query above coming from? The view for the file_storage_object is supposed to be created via select content_type__refresh_view('file_storage_object'), which should create the two views

• file_storage_object_ti, and
• file_storage_object_tx,

but no file_storage_objectxi (what you are trying to create).

The last changes in this area were done more than six years ago [1] (in OpenACS 5.6). Can it be that you have missed some update scripts on file storage around that time? For your reference, on OpenACS 5.6 or newer, the type definition should look like

oacs-5-9=# select object_type, supertype, table_name, id_column, package_name  from acs_object_types where object_type like 'file%';
     object_type     |    supertype     |      table_name       |       id_column        |    package_name     
---------------------+------------------+-----------------------+------------------------+---------------------
 file_storage_object | content_revision | file_storage_object_t | file_storage_object_id | file_storage_object
(1 row)

-g
[1] https://github.com/openacs/file-storage/commit/6e10b3b140b2cb65bdf86fd791f2b070964b25c5

If someone else sees the problem above when upgrading old sites via acs-kernel/upgrade-5.9.0d4-5.9.0d5.sql, please run first the following SQL command in psql:

update acs_object_types set table_name = NULL, id_column = NULL where object_type = 'file_storage_object';