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

Collapse
1: Content item creation with oacs-5-4
Posted by Claudio Pasolini on 03/21/08 08:34 PM
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
2: Re: Content item creation with oacs-5-4 (response to 1)
Posted by Gustaf Neumann on 03/21/08 10:16 PM
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
3: Re: Content item creation with oacs-5-4 (response to 2)
Posted by Claudio Pasolini on 03/22/08 08:41 AM
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.