Flyspray - The bug killer!

  • Status Confirmed
  • Percent Complete
    0%
  • 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 1
  • Private
Attached to Project: Flyspray - The bug killer!
Opened by Bertil Bäck - 19.10.2016

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)
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 0.9.9.5 Flyspray version?

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

50: https://github.com/Flyspray/flyspray/blob/master/setup/upgrade/0.9.9.4/flyspray-install.xml

255: https://github.com/Flyspray/flyspray/blob/master/setup/upgrade/0.9.9.5/flyspray-install.xml

But missing that change for upgrader: https://github.com/Flyspray/flyspray/blob/master/setup/upgrade/0.9.9.5/upgrade.xml

To fix this, we should add that change to https://github.com/Flyspray/flyspray/blob/master/setup/upgrade/1.0/upgrade.xml , 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 bugs.flyspray.org 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

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing