Can't upload Open Office documents
Hi, I'm currently testing Project Pier to be used in our institution - AOSI (Association of Open Source organizations in Indonesia)
I have a small problem - I can upload certain files (doc, png, jpg, etc); but not Open Office files.
I kept on getting the following error message :
Failed to save object because some of its properties are not valid :
Unknown file type
Inspection to Project Pier's source code revealed traces to the database, table pp_file_types to be exact.
There I found list of extensions. Perhaps the upload form (http://aosiproject.ourwebsite.com/index.php?c=files&a=add_file&active_project=1) looks up to this table to find out if certain file extension can be allowed to be uploaded or not.
Funny thing is - even after I added Open Office's extensions to that table (odt, ott, sxw, etc), I still got the same error message. I thought adding Open Office's extensions to that table will resolve the issue. Unfortunately, that's not the case.
With my very limited PHP coding skill, I'm stuck here at the moment.
Could anyone please give me a hint or clue? Where else do I need to look to solve this issue ?
Thank you in advance.
Cheers,
Harry
I'm not sure why OO docs wouldn't work. Is it possible that you are working from a mac? it is a known limitation of some mac files (keynote, pages, etc) that they are actually special folders (called "bundles") and that's why they can't be uploaded. If you compress them into a zip file, that works.
Perhaps OO uses a similar approach when used with a mac.
Apologies, this issue was resolved the day after, but I forgot to update this post.
Basically, what happened (I think) is that MySQL still caches the old results on its cache. So Project Pier ended up kept saying that odt is Unknown file type. The next day, I guess the cache has been refreshed, and now Project Pier will accept odt files happily.
You do need to edit the pp_file_types table as I mentioned above first.
To force MySQL to refresh its cache, just restart it.
Thanks again.
I have PP 0.8.0.3 and have no problems uploding .odt files...
Have not made any changes in the installation.