Forum OpenACS Q&A: Re: Error while running Edit This Page

Collapse
2: Re: Error while running Edit This Page (response to 1)
Posted by Dave Bauer on 10/14/03 03:27 PM
Edit-this-page is definitely broken on Oracle.

You can try making this call in sqlplus:

select content_type.create_type (
        content_type => 'etp_page_revision',
        supertype => 'content_revision',
        pretty_name => 'ETP managed page',
        pretty_plural => 'ETP managed pages',
        table_name => 'etp_page_revisions',
        id_column => 'etp_page_revision_id',
        name_method => 'content_revision__revision_name'
);

Unfortunately the oracle version of ETP has not been maintained. Try creating the content type using that pl/sql call, and let me know what happens. You can ask more questions here or visit the  #openacs IRC channel at irc.freenode.net. See https://openacs.org/irc/ for more information.

Collapse
3: Re: Error while running Edit This Page (response to 2)
Posted by Boris Doesborg on 10/14/03 05:42 PM
Thanks a lot Dave,

I'll try that.

What is the future of OpenACS on Oracle? At the moment the ACS core supports both Oracle and Postgres, right?

Do you (or anyone else) foresee that one day this support for Oracle will be dropped?

I read the thread about this subject but that was 2 years ago. How is the situation now?

Collapse
4: Re: Error while running Edit This Page (response to 3)
Posted by Carl Robert Blesius on 10/14/03 05:56 PM
"Do you (or anyone else) foresee that one day this support for Oracle will be dropped"

Simple answer: No.
Simple reason: People are using it.

Collapse
5: Re: Error while running Edit This Page (response to 4)
Posted by Boris Doesborg on 10/14/03 06:00 PM
I like simple answers
Collapse
8: Re: Error while running Edit This Page (response to 2)
Posted by Boris Doesborg on 10/15/03 10:47 AM
We resolved the error by executing something slightly different: 
begin
        content_type.create_type (
        content_type => 'etp_page_revision',
        supertype => 'content_revision',
        pretty_name => 'ETP managed page',
        pretty_plural => 'ETP managed pages',
        table_name => 'etp_page_revisions',
        id_column => 'etp_page_revision_id',
        name_method => 'content_revision.revision_name'
);
end;
/
show errors;
We also changed it in the create script: /web/myserver/packages/edit-this-page/sql/oracle/edit-this-page-create.sql

Thanks a lots.