Forum OpenACS Development: Relation 'cr_mime_types' does not exist

Collapse
1: Relation 'cr_mime_types' does not exist
Posted by Jack Purswani on 07/13/01 02:33 AM
Hi. I am new to ACS and am trying to port the wp-slim package. I am
working on the data model create file and have encountered a problem
with the following:

insert into cr_mime_types (mime_type)
select 'application/octet-stream'
from dual
where not exists (select 1 from cr_mime_types where mime_type
='application/octet-stream');

This gives me an error message that Relation type cr_mimi_types does
not exist.

I would appreciate it if someone could help me out or point me in the
right direction for this problems.

Thanks
Jack

Collapse
2: Response to Relation 'cr_mime_types' does not exist (response to 1)
Posted by Don Baccus on 07/13/01 03:01 AM
Dan Wickstrom's the person who can best answer your question.  The table's in the datamodel and should be getting loaded when you install
OpenACS.

If you're planning to make your port available to the project, please e-mail me directly and I'll assign this package to you.

Also, read the wimpy-point presentation on porting (go to http://opeancs.org/wp) and other docs here if you haven't already.  There's information on standard approaches we're taking to porting packages that we'd like folks to follow, etc.

Collapse
3: Response to Relation 'cr_mime_types' does not exist (response to 1)
Posted by Dan Wickstrom on 07/13/01 03:21 AM
I'm not sure if you're using oracle or postgresql, but you must have had a problem loading the core data-model:

Oracle: 



Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
 
SQL> describe cr_mime_types
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 LABEL                                              VARCHAR2(200)
 MIME_TYPE                                 NOT NULL VARCHAR2(200)
 FILE_EXTENSION                                     VARCHAR2(200)

postgresql: 

openacs4=# d cr_mime_types
               Table "cr_mime_types"
   Attribute    |          Type          | Modifier
----------------+------------------------+----------
 label          | character varying(200) |
 mime_type      | character varying(200) | not null
 file_extension | character varying(200) |
Index: cr_mime_types_pk

I'm assuming that cr_mimi_types was just a typo in your post.