Forum OpenACS Development: Content item creation with oacs-5-4

I just mounted a working oacs-5-1 package on a 5.4 installation.

The package uses content_item__new to create a cr_items row and then tries to insert into the special view named after the table and suffixed with 'i'.

This has always worked with oacs 5.1 and 5.2, but now I get an error complaining that "Query was not a DML or DDL command.".

I have fixed the problem inserting first a row into cr_revisions with content_revision__new and then avoiding the use of the special view, but this is very annoying: am I missing something or is there a new way to use the special view?

Collapse
Posted by Gustaf Neumann on
Claudio,

There were in this regards a view changes in OpenACS 5.3.
See e.g.

https://openacs.org/forums/message-view?message_id=461870
https://openacs.org/forums/message-view?message_id=463143

In short, you have to change in the oacs-5-1 package the SQL call performing the insert on the "i"-view from db_dml to db_0or1row to work with openacs 5.3 or newer.

best regards
-gustaf neumann

Collapse
Posted by Claudio Pasolini on
Thank you very much, Gustaf.

I completely forgot the threads you mentioned, perhaps because, for performance reasons, I don't use anymore the CR in my newer applications.