Forum OpenACS Development: Problemas when we created templates and folders in Oracle

Collapse
1: Problemas when we created templates and folders in Oracle
Posted by César Alexander Hernández Juarez on 01/07/05 12:42 AM
Whe I created the templates and folders I goy the next errors.

creating the templates

ora9.c:3602:ora_tcl_command: error in `OCIStmtExecute ()': ORA-01400: cannot insert NULL into ("GESDEV"."ACS_OBJECTS"."CREATION_DATE")
ORA-06512: at "GESDEV.ACS_OBJECT", line 68
ORA-06512: at "GESDEV.CONTENT_ITEM", line 154
ORA-06512: at "GESDEV.CONTENT_TEMPLATE", line 44
ORA-06512: at line 4

SQL:

BEGIN
:1 := content_template.new(name => :name,
text => :text,
parent_id => :parent_id,
is_live => :is_live,
template_id => :template_id,
creation_date => :creation_date,
creation_user => :creation_user,
creation_ip => :creation_ip
);
END;

Collapse
2: Re: Problemas when we created templates and folders in Oracle (response to 1)
Posted by Dave Bauer on 01/07/05 12:49 AM
Cvs update you acs-content-repository package. This is fixed in CVS on head and oacs-5-1 branch.
Collapse
3: Problems when I created folders in Oracle (response to 2)
Posted by César Alexander Hernández Juarez on 01/07/05 10:01 PM
Hi dave! the same problem I have when I create folders, the problem is the next:

Error: SQL(): ora9.c:3602:ora_tcl_command: error in `OCIStmtExecute ()': ORA-01400: cannot insert NULL into ("GESDEV"."ACS_OBJECTS"."CREATION_DATE")
ORA-06512: at "GESDEV.ACS_OBJECT", line 68
ORA-06512: at "GESDEV.CONTENT_ITEM", line 154
ORA-06512: at line 4

Collapse
4: Re: Problemas when we created templates and folders in Oracle (response to 1)
Posted by Dave Bauer on 01/08/05 01:33 AM
Content::folder::new already does the right thing. Check that your content-folder-procs.tcl is up to date.
Collapse
5: Problems with content::item::new and content::revision::new (response to 4)
Posted by César Alexander Hernández Juarez on 01/10/05 04:33 PM
When I use the functions content::item::new and content::revision::new, i don't send the date and I obtain the following error:

ORA-01400: cannot insert NULL into ("GESDEV"."ACS_OBJECTS"."CREATION_DATE")
ORA-06512: at "GESDEV.ACS_OBJECT", line 68
ORA-06512: at "GESDEV.CONTENT_ITEM", line 153
ORA-06512: at line 4

SQL: [too long]
while executing
"ns_ora exec_plsql_bind nsdb0 {

BEGIN
:1 := content_item.new(name => :name,
paren..."

but I send the date it works correctly, but the function content::folder:new and content::template::new dont send the date.

Collapse
6: Re: Problems with content::item::new and content::revision::new (response to 5)
Posted by Dave Bauer on 01/10/05 04:49 PM
This is fixed on the oacs-5-1 branch and has been for a while. If you are using HEAD you might need to port the changes over. I will try to do that later today.
Collapse
7: The param package_id not defined in the fucntion content::template::new (response to 6)
Posted by César Alexander Hernández Juarez on 01/10/05 05:19 PM
The param package_id not defined in the fucntion content::template::new

ad_proc -public content::template::new {
-name:required
{-text ""}
{-parent_id ""}
{-is_live ""}
{-template_id ""}
-creation_date
{-creation_user ""}
{-creation_ip ""}
}

and it must be defined

ad_proc -public content::template::new {
-name:required
{-text ""}
{-parent_id ""}
{-is_live ""}
{-template_id ""}
-creation_date
{-creation_user ""}
{-creation_ip ""}
{-package_id ""}
}

so that it works correctly

thanks dave

Collapse
8: Re: The param package_id not defined in the fucntion content::template::new (response to 7)
Posted by Dave Bauer on 01/10/05 05:36 PM
Please provide ALL details if you insist of posting bug reports on the forums. Details include:

Version of OpenACS you are using.
A example of the code that was called.
A description of what you expected to happen.
A description of what actually happened including the relevant part of the error log.

On OpenACS 5.1 content::template::new does NOT accept a package_id parameter. This is because there is no package_id attribute for content repository items in this version of OpenACS. The first version of OpenACS that will support package_id for all objects in the acs_objects table is OpenACS 5.2 (current CVS HEAD).

Collapse
9: Problems with Content Revision (response to 8)
Posted by César Alexander Hernández Juarez on 01/13/05 04:24 PM
I am working with oacs-5.1 and dotLRN with package evaluation.

My problem is the next:

In the acs-content-repository in postgres exist the funcion: function
content_revision__get_content() but in oracle don't exist.

Perhaps in Oracle one works different and it is not necessary to create
it.

for your help, thanks dave.

Collapse
10: Re: Problems with Content Revision (response to 9)
Posted by Dave Bauer on 01/13/05 04:28 PM
Can you explain what the actual problem is? What does this function do? And what should the equvilant oracle function do?

This might be tricky due to differences binary object handling in PG compared to oracle.