Forum OpenACS Development: Relation 'cr_mime_types' does not exist

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

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.


Posted by Don Baccus on
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

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 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.

Posted by Dan Wickstrom on
I'm not sure if you're using oracle or postgresql, but you must have had a problem loading the core data-model:


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


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.