Flyspray - The bug killer!

  • Status Closed
  • Percent Complete
  • Task Type Bug Report
  • Category Installer and Upgrader
  • Assigned To No-one
  • Operating System All
  • Severity Medium
  • Priority Medium
  • Reported Version 1.0-rc
  • Due in Version Undecided
  • Due Date Undecided
  • Votes 2
  • Private
Attached to Project: Flyspray - The bug killer!
Opened by Bertil Bäck - 19.10.2016
Last edited by peterdd - 03.03.2018

FS#2218 - Not possible to attach a Libreoffice .odt file

Trying to add a .odt file does not work.

Following error message

Query {INSERT INTO `flyspray_attachments` ( task_id, comment_id, file_name, file_type, file_size, orig_name, added_by, date_added) VALUES (?, ?, ?, ?, ?, ?, ?, ?)} with params {1929,1974,1929_572e9904dff52c39a00fd5fdc,application/vnd.oasis.opendocument.text; charset=binary,8982,test document.odt,2,1476863033} Failed! (Data too long for column 'file_type' at row 1)
Closed by  peterdd
03.03.2018 10:25
Reason for closing:  Fixed in devel
Bertil Bäck commented on 19.10.2016 07:41

Trying to add test file

Bertil Bäck commented on 19.10.2016 07:45
Project Manager
peterdd commented on 19.10.2016 12:42

Mmh, can't reproduce on a testinstall of me.

Could it be that you upgraded from an older than Flyspray version?

The length of table field attachments.file_type was changed from 50 chars to 255 chars with version, and uuhhh.. I see they forgot to handle this with upgrade.xml .



But missing that change for upgrader:

To fix this, we should add that change to , right?

If you know how to handle sql or mysqladmin, you can fix it in your installation by changing the file_type field of table attachments from 50 to 255 chars.

Project Manager
peterdd commented on 19.10.2016 12:44

test here

Project Manager
peterdd commented on 19.10.2016 12:47

Haha, reproduced problem now on too.

Ok, thanks for finding the bug.

Bertil Bäck commented on 19.10.2016 18:55

Now I don't remember what version I upgraded from I need to check. But yes got it on this issue tracker also


Available keyboard shortcuts


Task Details

Task Editing