Vote #71650
完了Extend Filesize in the attachments table for files with size > 2147483647 bytes
0%
説明
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(11) - 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 ...
journals
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.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
I have created a patch to change type of filesize column to bigint.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
I believe that you can use _bigint_ instead of _:limit => 8_
<pre>
def up
change_column :attachments, :filesize, :bigint, :default => 0, :null => false
end
</pre>
--------------------------------------------------------------------------------
bigint is not mentionned in the Rails doc:
http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/TableDefinition.html#method-i-column
--------------------------------------------------------------------------------
Change committed in r14709.
--------------------------------------------------------------------------------