[Building Sakai] PDF uploads to Resources

[Omer Piperdi]

Is there a query that I can run against content_resource table and see 
if resource_id has .pdf in it and resource type is not application/pdf.

Which column has file type info?

Thanks
Omer

On 9/1/2010 5:07 PM, Matthew Jones wrote:
> Yea, it's a bug with firefox on some platforms, there is currently no
> fix for Sakai.
>
> There was a jira proposed (KNL-101) to use a file type detection library
> (like mime-util). However it *looked* like it involved changing some
> api's in the kernel, and I haven't finished fixing it yet. It's
> hopefully get to it to looking at it again before the 2.8 freeze, but
> have a number of higher local priorities before then. :(
>
> -Matthew
>
> On Wed, Sep 1, 2010 at 5:54 PM, Omer Piperdi <omer at rice.edu
> <mailto:omer at rice.edu>> wrote:
>
>     We have seen pdf uploads to Resources creates file type as text/url,
>     instead of application/pdf, which is causing the users not able to open
>     the file..
>
>     We upgraded our Sakai Kernel to 1.1.9 and running 2.7.x branch.. This is
>     happening mostly on a MAC with Firefox.
>
>     Anyone seen this or any pointer for JIRA?
>
>     Thanks
>     Omer
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto:sakai-dev at collab.sakaiproject.org>
>     http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
>     TO UNSUBSCRIBE: send email to
>     sakai-dev-unsubscribe at collab.sakaiproject.org
>     <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
>
>
> !DSPAM:2294,4c7ecea6185363737194024!