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

Collapse
Posted by Gustaf Neumann on
Frank,

The problem does not only exist with 'journal_article', but as well with at least 'journal_issue', and 'news_item'. It is strange that your installation contains the cr-content type definitions of etp, but no etp installed. ... so maybe these are traces of a non-clean de-install attempt some time ago....

What happens when you run the one-liner of the update script [1]? It should help you over the issue with content_type__refresh_view.

OpenACS.org runs 5.9.0 fine with edit this page after updating to the newest version of etp.

-g

[1] http://fisheye.openacs.org/browse/OpenACS/openacs-4/packages/edit-this-page/sql/postgresql/upgrade/upgrade-1.9d2-1.9d3.sql?r=1.1

Collapse
Posted by Frank Bergmann on
Hi!

Thanks for helping me with the issue!
Yes, the default ]po[ database may still contain stuff from ACS 3.4. That's because we had to update our users so many times already.

However, I believe I've found the source of the recent issues: In
upgrade-5.9.0d4-5.9.0d5.sql, the very "drop tree_sortkey" cascades to 47 objects that are all deleted. I'm quite sure that's not intended like this, because it deletes for example "file_storage_objectx", which is needed to re-generated the content-repository views later in the script.

Does this happen because I try to upgrade directly from OpenACS 5.7 to OpenACS 5.9?

ALTER TABLE acs_objects drop column tree_sortkey cascade;
NOTICE:  drop cascades to 47 other objects
DETAIL:  drop cascades to view cr_revisionsi
drop cascades to function cr_revisions_f(cr_revisionsi)
drop cascades to view etp_page_revisionsi
drop cascades to function etp_page_revisions_f(etp_page_revisionsi)
drop cascades to view file_storage_objecti
drop cascades to function file_storage_object_f(file_storage_objecti)
drop cascades to view imagesi
drop cascades to function images_f(imagesi)
drop cascades to view users_email_imagei
drop cascades to function users_email_image_f(users_email_imagei)
drop cascades to view workflow_case_log_revi
drop cascades to function workflow_case_log_rev_f(workflow_case_log_revi)
drop cascades to view xowiki_filei
drop cascades to function xowiki_file_f(xowiki_filei)
drop cascades to view xowiki_formi
drop cascades to function xowiki_form_f(xowiki_formi)
drop cascades to view xowiki_form_pagei
drop cascades to function xowiki_form_page_f(xowiki_form_pagei)
drop cascades to view xowiki_objecti
drop cascades to function xowiki_object_f(xowiki_objecti)
drop cascades to view xowiki_pagei
drop cascades to function xowiki_page_f(xowiki_pagei)
drop cascades to view xowiki_page_instancei
drop cascades to function xowiki_page_instance_f(xowiki_page_instancei)
drop cascades to view xowiki_page_templatei
drop cascades to function xowiki_page_template_f(xowiki_page_templatei)
drop cascades to view xowiki_plain_pagei
drop cascades to function xowiki_plain_page_f(xowiki_plain_pagei)
drop cascades to view xowiki_podcast_itemi
drop cascades to function xowiki_podcast_item_f(xowiki_podcast_itemi)
drop cascades to view cc_users
drop cascades to view cr_revisionsx
drop cascades to view etp_page_revisionsx
drop cascades to view file_storage_objectx
drop cascades to view fs_urls_full
drop cascades to view imagesx
drop cascades to view users_email_imagex
drop cascades to view workflow_case_log_revx
drop cascades to view xowiki_filex
drop cascades to view xowiki_form_pagex
drop cascades to view xowiki_formx
drop cascades to view xowiki_objectx
drop cascades to view xowiki_page_instancex
drop cascades to view xowiki_page_templatex
drop cascades to view xowiki_pagex
drop cascades to view xowiki_plain_pagex
drop cascades to view xowiki_podcast_itemx