Feature #10672

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

Added by Oliver Maurhart over 6 years ago. Updated over 2 years ago.

Status:ClosedStart date:
Priority:LowDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Attachments
Target version:3.2.0
Resolution:Fixed

Description

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 ...

change_attachments_file_size_limit.diff Magnifier (559 Bytes) Go MAEDA, 2015-07-25 04:25

Associated revisions

Revision 14709
Added by Jean-Philippe Lang over 2 years ago

Extend Filesize in the attachments table for files with size > 2GB (#10672).

History

#1 Updated by Glenn Gould about 5 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.

#2 Updated by Etienne Massip about 5 years ago

  • Target version set to Candidate for next minor release

#3 Updated by Etienne Massip about 5 years ago

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

#4 Updated by Go MAEDA almost 3 years ago

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

#5 Updated by Toshi MARUYAMA almost 3 years ago

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

#6 Updated by Karel Pičman over 2 years ago

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

def up 
 change_column :attachments, :filesize, :bigint, :default => 0, :null => false
end

#8 Updated by Jean-Philippe Lang over 2 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