Project

General

Profile

Actions

Defect #20127

closed

The description column in the issues table is too short (MySQL)

Added by Future Link Corporation pkgsrc team over 9 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Normal
Category:
Issues
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

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.


Related issues

Related to Redmine - Defect #16143: Can't insert too long comment field from repository (MySQL)ClosedJean-Philippe Lang

Actions
Related to Redmine - Defect #24006: Add character limitation on description field for MySQLClosed

Actions
Related to Redmine - Defect #14626: Repositories' extra_info column is too short with MySQLClosedJean-Philippe Lang

Actions
Related to Redmine - Defect #29209: Long text custom fields don't accept values longer than 64KB if backend database is MySQLClosedJean-Philippe Lang

Actions
Has duplicate Redmine - Defect #18865: Size of text description of the problemClosed

Actions
Has duplicate Redmine - Defect #7779: Error 500 when issue description is too longClosed2011-03-04

Actions
Has duplicate Redmine - Feature #19869: Consider increasing the size limit of description and note columns for ticketsClosed

Actions
Has duplicate Redmine - Defect #24397: this text in description or note cause an internal server errorClosed

Actions
Actions #1

Updated by Jean-Philippe Lang over 9 years ago

  • 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)
Actions #2

Updated by Go MAEDA over 9 years ago

  • Related to Defect #16143: Can't insert too long comment field from repository (MySQL) added
Actions #3

Updated by Go MAEDA over 9 years ago

  • Target version set to Candidate for next major release
Actions #4

Updated by Go MAEDA over 9 years ago

  • Related to Feature #19869: Consider increasing the size limit of description and note columns for tickets added
Actions #5

Updated by Go MAEDA almost 9 years ago

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.

Actions #6

Updated by Go MAEDA almost 9 years ago

  • Has duplicate Defect #18865: Size of text description of the problem added
Actions #7

Updated by Go MAEDA almost 9 years ago

  • Has duplicate Defect #7779: Error 500 when issue description is too long added
Actions #8

Updated by Jean-Philippe Lang about 8 years ago

  • Target version changed from Candidate for next major release to 3.4.0
Actions #9

Updated by Jean-Philippe Lang about 8 years ago

  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang
  • Resolution set to Fixed

Issue description and journals changed to LONGTEXT.

Actions #10

Updated by Go MAEDA about 8 years ago

  • Related to Defect #24006: Add character limitation on description field for MySQL added
Actions #11

Updated by Toshi MARUYAMA about 8 years ago

  • Related to deleted (Feature #19869: Consider increasing the size limit of description and note columns for tickets)
Actions #12

Updated by Toshi MARUYAMA about 8 years ago

  • Has duplicate Feature #19869: Consider increasing the size limit of description and note columns for tickets added
Actions #13

Updated by Go MAEDA about 8 years ago

  • Has duplicate Defect #24397: this text in description or note cause an internal server error added
Actions #14

Updated by Go MAEDA almost 8 years ago

  • Related to Defect #14626: Repositories' extra_info column is too short with MySQL added
Actions #15

Updated by Go MAEDA over 6 years ago

  • Related to Defect #29209: Long text custom fields don't accept values longer than 64KB if backend database is MySQL added
Actions

Also available in: Atom PDF