I installed OpenACS 4.6.3 from tarball.

When trying to create a new object in the table "acs_objects" it looks for the object type "etp_page_revision". It seems like the object type "etp_page_revision" does not exist in the table "acs_object_types".

I hope this makes sense because this is as far as my knowledge of the ACS content system and Oracle reaches.

I encountered problems with the "Edit This Page" package in all the versions of OpenACS I installed.

We're planned to develop a web site that relies on "Edit This Page".

What version of OpenAcs do you recommend?

--- error ---


ora8.c:3463:ora_tcl_command: error in `OCIStmtExecute ()': ORA-02291: integrity constraint (MYSERVER.ACS_OBJECTS_OBJECT_TYPE_FK) violated - parent key not found
ORA-06512: at "MYSERVER.ACS_OBJECT", line 68
ORA-06512: at "MYSERVER.ETP", line 30
ORA-06512: at line 3

SQL: 
	begin
	  :1 := etp.create_page(
	           package_id     => :package_id,
	           name           => :name,
                   title          => :title,
	           content_type   => :content_type
	        );
	end;

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?

I just looked, and this is fixed in the most recent CVS version of OpenACS.

It is in /web/myserver/packages/edit-this-page/sql/oracle/edit-this-page-create.sql

We replaced these lines (68-81) ...

    function get_attribute_value (
      object_id    in acs_objects.object_id%TYPE,
      attribute_id in acs_attribute_values.attribute_id%TYPE
    ) return varchar is
      v_value acs_attribute_values.attr_value%TYPE;
    begin
        select attr_value
        into v_value
        from acs_attribute_values
        where object_id = object_id
        and attribute_id = attribute_id;
        return v_value;
        exception when no_data_found then return null;
    end get_attribute_value;

function get_attribute_value (
      object_id    in acs_objects.object_id%TYPE,
      attribute_id in acs_attribute_values.attribute_id%TYPE
    ) return varchar is
      v_value acs_attribute_values.attr_value%TYPE;
    begin
        select attr_value
        into v_value
        from acs_attribute_values
        where object_id = get_attribute_value.object_id
        and attribute_id = get_attribute_value.attribute_id;
        return v_value;
        exception when no_data_found then return null;
    end get_attribute_value;

Harish and Malte, I'm still interested in other changes you made to the package including the new functionalties like the sliding menu.

Sometimes the "Commit your work" link simply didn't show up.

(for more info search for "batigol" in the IRC log http://openacs.org/irc/log/2003-10-17)

the problem is in line 209 and 210 of /web/yourserver/packages/edit-this-page/sql/edit-this-page-create.sql

      where i.name = name
      and i.parent_id = etp.get_folder_id(package_id)

      where i.name = create_new_revision.name
      and i.parent_id = etp.get_folder_id(create_new_revision.package_id)