Defect #20127
closed
The description column in the issues table is too short (MySQL)
Added by Future Link Corporation pkgsrc team almost 9 years ago.
Updated over 7 years ago.
Description
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.
- Subject changed from The description column in the issues table is too short to The description column in the issues table is too short (MySQL)
- Related to Defect #16143: Can't insert too long comment field from repository (MySQL) added
- Target version set to Candidate for next major release
- Related to Feature #19869: Consider increasing the size limit of description and note columns for tickets added
Etienne Massip 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.
- Has duplicate Defect #18865: Size of text description of the problem added
- Has duplicate Defect #7779: Error 500 when issue description is too long added
- Target version changed from Candidate for next major release to 3.4.0
- Status changed from New to Closed
- Assignee set to Jean-Philippe Lang
- Resolution set to Fixed
Issue description and journals changed to LONGTEXT.
- Related to Defect #24006: Add character limitation on description field for MySQL added
- Related to deleted (Feature #19869: Consider increasing the size limit of description and note columns for tickets)
- Has duplicate Feature #19869: Consider increasing the size limit of description and note columns for tickets added
- Has duplicate Defect #24397: this text in description or note cause an internal server error added
- Related to Defect #14626: Repositories' extra_info column is too short with MySQL added
- Related to Defect #29209: Long text custom fields don't accept values longer than 64KB if backend database is MySQL added
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by Toshi MARUYAMA