Vote #76476
完了The description column in the issues table is too short (MySQL)
0%
説明
The @description@ column in the +issues+ table has a data type of @TEXT@, which has a limit of 65k. We recommend changing this data type to @LONGTEXT@, as was done for the @comment@ field in the +changesets+ table. As you've done this for the repository commits (#16143) already, please make this change. Otherwise, Redmine throws a 500 error on creating issues with long descriptions.
journals
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
"Etienne Massip":http://www.redmine.org/users/6508 wrote on #7779#note-1:
> PostgreSQL stores issue description in a column with text data type which length is unlimited, so adding a limit would be some kind of regression to PG users.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Issue description and journals changed to LONGTEXT.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
related_issues
relates,Closed,16143,Can't insert too long comment field from repository (MySQL)
relates,Closed,24006,Add character limitation on description field for MySQL
relates,Closed,14626,Repositories' extra_info column is too short with MySQL
relates,Closed,29209,Long text custom fields don't accept values longer than 64KB if backend database is MySQL
duplicates,Closed,18865,Size of text description of the problem
duplicates,Closed,7779,Error 500 when issue description is too long
duplicates,Closed,19869,Consider increasing the size limit of description and note columns for tickets
duplicates,Closed,24397,this text in description or note cause an internal server error