Defect #20127
closed
The description column in the issues table is too short (MySQL)
Added by Future Link Corporation pkgsrc team about 11 years ago.
Updated almost 10 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