Support

What you did is correct and there is no bug in ATS. In fact, that's how Joomla works.

Akeeba Ticket System, like every other reasonably written Joomla extension, does NOT implement its own files upload. Instead, it goes through Joomla. Joomla controls what can be uploaded by looking at the Options of the Media Manager. I know it sounds insane but that's what it is... You need to change both the Legal extensions (file types) AND the allowed MIME type options for the uploads to work.

Do NOT touch the Legal image extensions! This option is currently inert in Joomla 3 but it has a meaning in Joomla 4: it controls which files will be displayed inline in the Media Manager page. You do NOT want to add ZIP and, worse, Office files there – it will cause all sorts of trouble for you when you upgrade to Joomla 4.

Moreover, please bear in mind that Joomla performs upload prefiltering using the code that was formerly part of Admin Tools' UploadShield. This may prevent the upload of certain files despite having a legal extension and MIME type, depending on their contents. If you want to disable this behavior you need to go to ATS' Options, Common and set Allow Unsafe Uploads to Yes. Please note that your uploads are still subject to file extension and MIME type checks; it's only their contents that won't be scanned by Joomla's UploadShield implementation.

I think you misunderstood me :) I understand that you want to allow people filing tickets to upload the following types of files: PDF, ZIP, CSV, DOC, DOCX, XLS, XLSX, PPT, PPTX, ODG, ODP, ODS and ODT.

Go to Content, Media, Options.

In the “Legal extensions (file types)” make sure the following extensions are listed in addition to the image files: pdf,PDF,zip,ZIP,csv,CSV,doc,DOC,docx,DOCX,xls,XLS,xlsx,XLSX,ppt,PPT,pptx,PPTX,odg,ODG,odp,ODP,ods,ODS,odt,ODT

Since you do not want to check the MIME types of these files, set the “Ignored Extensions” to: pdf,PDF,zip,ZIP,csv,CSV,doc,DOC,docx,DOCX,xls,XLS,xlsx,XLSX,ppt,PPT,pptx,PPTX,odg,ODG,odp,ODP,ods,ODS,odt,ODT

“Restrict Uploads” must always be enabled on this page for security reasons. This is a safety switch. If something breaks in your PHP installation then and only then will Joomla prevent users below manager to upload any file that's not an image type. This is not something that applies to your site at the moment. It's there to prevent a security issue if something breaks in your PHP installation.

First of all, let me tell you two things.

1. Attachments do work. We use ATS on our own site and we rely on attachments to provide support. Posting images is actually quite rare. Most of our clients post Akeeba Backup log files in ZIP files.

2. File upload is handled by PHP and Joomla, not Akeeba Ticket System. Once Joomla has the temporary upload in place we simply copy it to the attachments storage. If PHP or Joomla decided that for whatever reason your file cannot be uploaded we have no idea that you even tried an upload, let alone if there was an error or what the error message was. That's why you do not see any kind of feedback about failed uploads.

The attachment area in ATS shows you the maximum allowed size per your server settings and the allowed extensions per your Media Manager configuration. View this ticket on our site an look at the bottom of the reply area. You will see that it reads:

Maximum allowed size for attachments: 10 MB Allowed extensions: bmp, csv, doc, gif, ico, jpg, jpeg, odg, odp, ods, odt, pdf, png, ppt, txt, xcf, xls, zip, 7z, rar, json

Now go back to your site and look at the same area.

Are you uploading a file that's bigger than the size specified here? If you did, you need to increase your PHP maximum upload size and possible your PHP maximum POST size. If you are not sure how to do that please ask your host. There is no universal answer to that since PHP configuration modification is an intrinsically server-specific operation.

When you entered the file extensions did you use both the lowercase and uppercase variants of each one? If not, please do so now. Also double check that your filename matches the extension case. The extensions pdf, PDF, Pdf and pDf are all four different extensions as far as Joomla is concerned.

You told me that you had turned “Check MIME Types“ off. If this is not the case you will need to also modify the “Legal MIME Types” with the MIME types of all extensions you want to support. You can find a reference for common MIME types at https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types/Common_types

Assuming that you want to allow PDF, ZIP, CSV, DOC, DOCX, XLS, XLSX, PPT, PPTX, ODG, ODP, ODS and ODT files the following MIME types need to be present in that comma-separated list:

• application/pdf
• application/zip
• text/csv
• application/msword
• application/vnd.openxmlformats-officedocument.wordprocessingml.document
• application/vnd.ms-excel
• application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
• application/vnd.ms-powerpoint
• application/vnd.openxmlformats-officedocument.presentationml.presentation
• application/vnd.oasis.opendocument.graphics
• application/vnd.oasis.opendocument.presentation
• application/vnd.oasis.opendocument.spreadsheet
• application/vnd.oasis.opendocument.text

You will see that Joomla has some of these but not all, especially not those MIME types used by Microsoft Office 2006 or later (for the file types with an X in their extension), OpenOffice / LibreOffice files and PDFs.

Furthermore, bear in mind that Microsoft Office 2007 and later uses a different file extension depending on whether your file includes macros or not. An Excel spreadsheet with macros has the file extension XLSM. If it doesn't have macros it has the extension XLSX. I strongly recommend AGAINST allowing DOCM, XLSM and PPTM files to be uploaded to your server. Macro-enabled Office document are the most common source of malware intrusion.

No problem :) I understand this is a confusing topic since Joomla needs to apply all sorts of filtering and cross filtering and additional checks on top of a bunch of checks when a file is being uploaded. Even for those of us who wrote parts of the code it's a real headache to remember every little detail.

Have a great day!