Feature #10672


Extend Filesize in the attachments table for files with size > 2147483647 bytes

Added by Oliver Maurhart over 11 years ago. Updated about 8 years ago.

Target version:
Start date:
Due date:
% Done:


Estimated time:


We use Redmine for our Projects. On the "Files" Tab we also offer complete VirtualBox images containing trial versions for our software. Naturally these files exceed 2.1 GB in size.

It was a bit tricky to get these files into Redmine but I managed it. (No, I did not upload them via web browser). Now all is perfect. I can download the images and play around with them.

Sadly, due to the "attachment" table definition in the Redmine Database been filesize of INT - which is basically a signed 32 bit integer - the displayed filesize is wrong. So the "Files" Tab always shows the wrong size.

It's not a big deal anyway, since download works. It's just a minor quirk. Maybe a BIGINT in the SQL database definition would help ...


Actions #1

Updated by Glenn Gould over 10 years ago

We had a similar problem with bigger downloads. In our case, we manually wrote "-1" to the filesize field and added the real filesize manually in the description, however, it would be very nice to be able to store bigger filesizes directly in the redmine database.

Actions #2

Updated by Etienne Massip over 10 years ago

  • Target version set to Candidate for next minor release
Actions #3

Updated by Etienne Massip over 10 years ago

  • Target version changed from Candidate for next minor release to Candidate for next major release
Actions #4

Updated by Go MAEDA over 8 years ago

I have created a patch to change type of filesize column to bigint.

Actions #5

Updated by Toshi MARUYAMA over 8 years ago

  • Target version changed from Candidate for next major release to 3.2.0
Actions #6

Updated by Karel Pičman about 8 years ago

I believe that you can use bigint instead of :limit => 8

def up 
 change_column :attachments, :filesize, :bigint, :default => 0, :null => false
Actions #8

Updated by Jean-Philippe Lang about 8 years ago

  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang
  • Resolution set to Fixed

Change committed in r14709.


Also available in: Atom PDF