“If debugging is the process of removing bugs, then programming must be the process of putting them in.” – Edsger Dijkstra
This is the Bug Tracking System for the Flyspray project. This is not a demo! Before opening a new task, please read the guidelines!
Do not issue bugs reports against versions earlier than 0.9.9.6
Security problem? Check the security section.
FS#1576 - Problem when uploading Office 2007 files
Opened by Frederic (Fred91) - Wednesday, 01 July 2009, 09:36 GMT+2
Last edited by Florian Schmitz (Floele) - Tuesday, 07 July 2009, 20:11 GMT+2
|
DetailsHello, I get an SQL error when uploading Office 2007 files (xlsx, docx, pptx,...) : Query {INSERT INTO `flyspray_attachments` ( task_id, comment_id, file_name, file_type, file_size, orig_name, added_by, date_added) VALUES (?, ?, ?, ?, ?, ?, ?, ?)} with params {3,1,3_fef0adbdfe0c42be9192cb1f7026,application/vnd.openxmlformats-officedocument.presentationml.presentation,65884,Service informatique.pptx,3,1246433139} Failed! (Data too long for column ‘file_type’ at row 1) It seems that Office 2007 files Mime Type are quit long (http://www.bram.us/2007/05/25/office-2007-mime-types-for-iis/) whereas the file_type field is limited to 50 characters. Other file types (jpg,pdf) are correctly uploaded.
Fred |
Tuesday, 07 July 2009, 20:11 GMT+2
Reason for closing: Fixed in devel
Additional comments about closing: rev 1642 (column needs to be upgraded manually though)
heh, nice catch.