Forum OpenACS Development: CR problem with "title" column

Collapse
1: CR problem with "title" column
Posted by Eduardo Pérez on 06/28/04 04:04 PM
I have this problem when using the CR (TCL API):
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  column "title" duplicated
CONTEXT:  PL/pgSQL function "content_type__refresh_view" line 53 at execute statement
PL/pgSQL function "content_type__create_type" line 54 at perform

SQL:

        select content_type__create_type('as_assessments','content_revision','Assessment Assessment','Assessment Assessments','as_assessments','assessment_id',NULL)

This is the code:
content::type::create_type -content_type {as_assessments} -supertype {content_revision} -pretty_name {Assessment Assessment} -pretty_plural {Assessment Assessments} -table_name {as_assessments} -id_column {assessment_id}

and the table doesn't contain any title column.

Collapse
2: Re: CR problem with "title" column (response to 1)
Posted by Dave Bauer on 06/28/04 04:14 PM
I figured this out.

On HEAD the acs_objects table has a title column. The code that creates the cr_revisionsi and cr_revisionsX views does not take this into account.

I am not sure how to fix it yet.

Collapse
3: Re: CR problem with "title" column (response to 1)
Posted by Dave Bauer on 06/28/04 04:34 PM
This is already fixed on HEAD. Make sure you have the latest version.
Collapse
4: Re: CR problem with "title" column (response to 3)
Posted by Eduardo Pérez on 06/28/04 05:43 PM
OK, I resourced:
acs-content-repository/sql/postgresql/content-type.sql
and now it's working.