ian at flash
May 27, 2011, 2:32 AM
Post #2 of 2
On 05/26/2011 03:50 PM, Mike Raynham wrote:
Re: Media Type already in use when no media types present
[In reply to]
> Deleting items from the GUI just deactivates them in the database. Unfortunately, I don't think
> there's a way to reactivate Media Types from the GUI. However, you can reactivate them directly from
> the database:
> To view deleted (deactivated) media types:
> SELECT * FROM media_type WHERE NOT active;
> To reactivate all deleted media types:
> UPDATE media_type SET active = true WHERE NOT active;
> Or for a specific media type:
> UPDATE media_type SET active = true WHERE name="application/pdf"
> On 26/05/11 15:32, Ian Gibbs wrote:
>> Dear all,
>> I deleted all the existing media types. Searching now returns "No Media
>> Types were found". When I try to add image/jpeg or text/plain as a new
>> media type, I get the message "The name "image/jpeg" is already used by
>> another Media Type." If try to add "invented/mimetype" (not one that was
>> in the list previously), it is accepted. If I then delete it and try to
>> recreate it, I am again told it is in use. It seems like deleting a
>> media type doesn't really delete it.
>> Can anyone help, please?
>> Ian Gibbs
Single quotes were required, rather than double:
UPDATE media_type SET active = true WHERE name='application/pdf'
but otherwise this did work around the issue. Unfortunately it wasn't the cause of my problem (see